Skip to content

Fix malformed CQL from spatial filters#369

Merged
boshek merged 8 commits into
mainfrom
fix/cql-translation
Jun 23, 2026
Merged

Fix malformed CQL from spatial filters#369
boshek merged 8 commits into
mainfrom
fix/cql-translation

Conversation

@boshek

@boshek boshek commented Jun 23, 2026

Copy link
Copy Markdown
Collaborator

Fixes a bug where filter() calls using CQL geometry predicates (such as INTERSECTS()) produced malformed CQL that the server rejected with a 400 error.

The reason the CQL was malformed was because CQL leaked a spurious TRUE AS "drop_null" clause and extra parentheses following the removal of c.sql() method in dbplyr 2.6.0 (tidyverse/dbplyr#1691).

Closes (#368)

@boshek boshek requested a review from ateucher June 23, 2026 16:42
@boshek boshek marked this pull request as ready for review June 23, 2026 16:42

@ateucher ateucher left a comment

Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for doing this @boshek! A couple of comments below

Comment thread tests/testthat/test-query-geodata-filter.R Outdated
Comment thread R/utils-classes.R Outdated
@boshek

boshek commented Jun 23, 2026

Copy link
Copy Markdown
Collaborator Author

Thanks @ateucher. Have a look at the changes. Also note I fixed those instances of @describeIn that didn't work with roxygen 8.0.0

@ateucher

Copy link
Copy Markdown
Collaborator

LGTM thanks @boshek!

@boshek boshek merged commit 6d856a6 into main Jun 23, 2026
8 of 9 checks passed
@boshek boshek deleted the fix/cql-translation branch June 23, 2026 21:51
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 this pull request may close these issues.

2 participants