Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Quote all SQL identifiers to retain the case. #17

Closed
OndraZizka opened this issue Oct 4, 2018 · 1 comment
Closed

Quote all SQL identifiers to retain the case. #17

OndraZizka opened this issue Oct 4, 2018 · 1 comment
Assignees
Milestone

Comments

@OndraZizka
Copy link
Owner

OndraZizka commented Oct 4, 2018

HSQLDB SQL identifiers are case sensitive, but also converted to upper case unless quoted in "...".

Case sensitivity rules for identifiers can be described simply as follows:
* all parts of SQL statements are converted to upper case before processing, except identifiers in double quotes and strings in single quotes
* identifiers, both unquoted and double quoted, are then treated as case-sensitive
* most database engines follow the same rule, except, in some respects, MySQL and MS SQLServer.

To retain the case, we would have to quote all uses of columns everywhere.

@OndraZizka
Copy link
Owner Author

Looks like this works in commit 0b62ca4 (which will likely become 2.1.0).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant