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