[
https://issues.apache.org/jira/browse/SIS-606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Martin Desruisseaux resolved SIS-606.
-------------------------------------
Resolution: Fixed
> 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)
