Hacker News new | ask | show | jobs
by wgjordan 2923 days ago
> what if there was a different query language with explicit index syntax..

There is, it's a feature in MySQL called Index Hints [1].

[1] https://dev.mysql.com/doc/refman/8.0/en/index-hints.html

1 comments

Or oracle has it

A DBA can even sit there as queries fly past, and add hints on the fly.

And then you change a query from "select" (lowercase) to "SELECT" (uppercase), and query plans break and you break production.

Fun times

Could you elaborate why changing select from lowercase to uppercase would break anything?
Stored procedures where master and slave are on different OSs and/or case-sensitivity settings are not the same?

Just a guess.