Skip to content

Bug: External file can't be referenced twice in the config.json #68

@arnaudfnr

Description

@arnaudfnr

Consider this config.json (full file available here:

{
"meteto_rain": "meteo.pluv",
"meteo_wind": "meteo.vent"
}

The folllowing error isn returned by Coordo:

  File "/usr/local/dev/14_Data4Trees/backend/.venv/lib/python3.13/site-packages/coordo/map/__init__.py", line 37, in handle_request
    return self.get_maplibre_style()
           ~~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/dev/14_Data4Trees/backend/.venv/lib/python3.13/site-packages/coordo/map/__init__.py", line 67, in get_maplibre_style
    sources, layer = layer.to_maplibre(self._base_path)
                     ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
  File "/usr/local/dev/14_Data4Trees/backend/.venv/lib/python3.13/site-packages/coordo/map/datapackage.py", line 37, in to_maplibre
    data = self.get_data(base_path=base_path)
  File "/usr/local/dev/14_Data4Trees/backend/.venv/lib/python3.13/site-packages/coordo/map/datapackage.py", line 82, in get_data
    df = package.read_resource(
        self.resource,
    ...<2 lines>...
        self.groupby,
    )
  File "/usr/local/dev/14_Data4Trees/backend/.venv/lib/python3.13/site-packages/coordo/datapackage/package.py", line 154, in read_resource
    relation = conn.sql(query_str)
_duckdb.BinderException: Binder Error: Ambiguous reference to table "meteo" (duplicate alias "meteo", explicitly alias one of the tables using "AS my_alias")

Strangely, other external data like dens_bois and dens_bois_mort are referenced in several formulas with no error.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No fields configured for Bug.

    Projects

    Status

    Ready to dev

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions