how to handle case sensitivity
Bug #1213025 reported by
Darshan Patel
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Akiban SQL Parser |
Invalid
|
Undecided
|
Unassigned |
Bug Description
SELECT a.Pbc AS PBC
O/P
SELECT a.pbc AS pbc
i am using linux mysql combination so that gives error
To post a comment you must log in.
Unquoted identifiers are case-insensitive in standard SQL. Out of all the quirky behavior MySQL has, their case handling is about the worst.
The parser itself won't be able to give you all same behavior, as it is just dealing with the query, but there is an IdentifierCase option if you want to preserve instead of normalize.
See the example here: /gist.github. com/nathanlws/ 5797500
https:/