Martin Desruisseaux created SIS-609:
---------------------------------------
Summary: SQLStore should accept "sis:identifier" in queries
Key: SIS-609
URL: https://issues.apache.org/jira/browse/SIS-609
Project: Spatial Information Systems
Issue Type: Improvement
Components: Storage
Affects Versions: 1.4
Reporter: Martin Desruisseaux
Assignee: Martin Desruisseaux
Fix For: 1.5
When {{SQLStore}} builds the features from database tables that {{SQLStore}}
analyzed itself, it automatically generate {{sis:identifier}} properties made
of the primary keys. However, if the features are the result of a
{{FeatureQuery}} containing only a subset of the columns (a "projection" in SQL
sense), and if that subset include the automatically-generated
{{sis:identifier}}, it doesn't work. The reason is a because {{SQLStore}} tries
to generate a SQL {{SELECT}} statement with only the requested columns. But the
{{sis:identifier}} column does not exist.
Fixing this issue is difficult. The {{sis:identifier}} property is often a
{{PropertyType}} of type {{Operation}}. That operation may have dependencies
that were not in the list of columns required by the user. Or it may be, but
with different names.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
