Martin Desruisseaux created SIS-606:
---------------------------------------
Summary: 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.4, 1.3, 1.2, 1.1, 1.0
Reporter: Martin Desruisseaux
Assignee: Martin Desruisseaux
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)
