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

GetFeature request with count and without startIndex fails with SqlFeatureStore and MS SQL database #1500

Open
lgoltz opened this issue May 12, 2023 · 0 comments
Labels
bug error issue and bug (fix) WFS deegree Web Feature Service

Comments

@lgoltz
Copy link
Contributor

lgoltz commented May 12, 2023

GetFeature with count [1] fails:
Error performing query by operator filter: Invalid usage of the option NEXT in the FETCH statement.
Generated SQL:
SELECT X2.bmlid FROM geodin_loc_bmlgenin X2 ORDER BY X2.bmlid ASC FETCH NEXT 10 ROWS ONLY;

GetFeature with count and startIndex [1] returns the expected number of features. Generated SQL:
SELECT X2.bmlid FROM geodin_loc_bmlgenin X2 ORDER BY X2.bmlid ASC OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY

[1] http://localhost:8180/deegree-webservices/services/wfs?service=WFS&request=GetFeature&version=2.0.0&typeNames=bmlh:BoreholeHeader&count=10
[2] http://localhost:8180/deegree-webservices/services/wfs?service=WFS&request=GetFeature&version=2.0.0&typeNames=bmlh:BoreholeHeader&count=10&startIndex=10

@lgoltz lgoltz added bug error issue and bug (fix) WFS deegree Web Feature Service labels May 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug error issue and bug (fix) WFS deegree Web Feature Service
Projects
None yet
Development

No branches or pull requests

1 participant