search

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 @ operator #56124

Open otan opened 3 years ago

otan commented 3 years ago

Currently we've special cased the @ operator for column specification, e.g. tbl_name@3.

This special casing prevents us from using @ for legitimate Postgre-esque operations, such as @ for bounding box for PostGIS.

Jira issue: CRDB-3574

jordanlewis commented 3 years ago

We also use it for index specification: SELECT * FROM t@idx WHERE...

I didn't know we used it to specify columns. That usage feels like it could be more easily removed. I think people like the index hints quite a bit, though.

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!