Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Lowercase UNIQUE in PostGIS subquery #6060

Closed
kalbermattenm opened this issue Apr 29, 2020 · 1 comment · Fixed by #6062
Closed

Lowercase UNIQUE in PostGIS subquery #6060

kalbermattenm opened this issue Apr 29, 2020 · 1 comment · Fixed by #6062

Comments

@kalbermattenm
Copy link

I do not know if this is an issue or if this was actually done on purpose. I tested the master branch (downloaded the latest mapserver build on gisinternals)

It looks like UNIQUE has now to be lowercase when using a subquery in a PostGIS data connection:

Working:

DATA "geom FROM (SELECT * from routes.rt101_entretien_talus) AS foo USING unique idobj USING srid=2056"

Not working anymore (is working with Mapserver 7.4.2):

DATA "geom FROM (SELECT * from routes.rt101_entretien_talus) AS foo USING UNIQUE idobj USING srid=2056"

The returned error is:

msWMSApplyFilter(): WMS server error. FLTApplyFilterToLayer() failed msPostGISParseData(): Query error. Error parsing PostGIS DATA variable. You must specify 'using unique' when supplying a subselect in the data definition. 

Is that a bug or do with have to use "unique" only in its lowercase form ?

@kalbermattenm
Copy link
Author

Thanks a lot for fixing this @rouault! I wasn't expecting such a quick reaction!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant