You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sis.apache.org by "Martin Desruisseaux (Jira)" <ji...@apache.org> on 2025/09/28 09:42:00 UTC

[jira] [Closed] (SIS-606) SQLStore fails if a table contains 2 foreigner keys referencing the same table

     [ https://issues.apache.org/jira/browse/SIS-606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Martin Desruisseaux closed SIS-606.
-----------------------------------

> SQLStore fails if a table contains 2 foreigner keys referencing the same table
> ------------------------------------------------------------------------------
>
>                 Key: SIS-606
>                 URL: https://issues.apache.org/jira/browse/SIS-606
>             Project: Spatial Information Systems
>          Issue Type: Bug
>    Affects Versions: 1.0, 1.1, 1.2, 1.3, 1.4
>            Reporter: Martin Desruisseaux
>            Assignee: Martin Desruisseaux
>            Priority: Major
>             Fix For: 1.5
>
>
> When a database contains a table with two or more foreigner keys referencing the same table, {{SQLStore}} creation fails with an exception like below:
>  {code}
> Exception in thread "main" org.apache.sis.storage.DataStoreContentException: Doublon inattendu d’une colonne nommée « id ».
>     at org.apache.sis.storage.sql/org.apache.sis.storage.sql.feature.Relation.<init>(Relation.java:212)
>     at org.apache.sis.storage.sql/org.apache.sis.storage.sql.feature.TableAnalyzer.getForeignerKeys(TableAnalyzer.java:113)
>     at org.apache.sis.storage.sql/org.apache.sis.storage.sql.feature.Table.<init>(Table.java:177)
>     at org.apache.sis.storage.sql/org.apache.sis.storage.sql.feature.Analyzer.table(Analyzer.java:305)
>     at org.apache.sis.storage.sql/org.apache.sis.storage.sql.feature.FeatureAnalyzer.createAssociations(FeatureAnalyzer.java:326)
>     at org.apache.sis.storage.sql/org.apache.sis.storage.sql.feature.Table.<init>(Table.java:180)
>     at org.apache.sis.storage.sql/org.apache.sis.storage.sql.feature.Analyzer.table(Analyzer.java:305)
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)