sql: support left (<<) and right (>>) bounding box operators

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

30.03k stars 3.8k forks source link

sql: support left (<<) and right (>>) bounding box operators #57092

Open timgraham opened 3 years ago

timgraham commented 3 years ago

They should adopt PostGIS behavior: https://postgis.net/docs/ST_Geometry_Left.html https://postgis.net/docs/ST_Geometry_Right.html

Currently it fails like this: unsupported binary operator: <geometry> >> <geometry> (desired <bool>).

Jira issue: CRDB-2868

blathers-crl[bot] commented 3 years ago

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I was unable to automatically find someone to ping.

If we have not gotten back to your issue within a few business days, you can try the following:

Join our community slack channel and ask on #cockroachdb.
Try find someone from here if you know they worked closely on the area and CC them.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!

timgraham commented 1 year ago

Still a valid issue.