Dameng database case_sensitive #25
baoyachi
announced in
Announcements
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
The docker image :dm_single run default ignore case_sensitive, and when there are double quotes in the table creation statement, it will not be converted to uppercase by default. If there are no double quotes, it will be automatically converted to uppercase.
E.g:
Then,query table describe about code:
Output:
╭───────────┬──────┬───────┬───────────────────┬────────────┬───────┬───────────┬────────┬────────────┬────────────────────────────╮ │ NAME │ ID │ COLID │ TYPE$ │ LENGTH$ │ SCALE │ NULLABLE$ │ DEFVAL │ TABLE_NAME │ CRTDATE │ ├───────────┼──────┼───────┼───────────────────┼────────────┼───────┼───────────┼────────┼────────────┼────────────────────────────┤ │ ID │ 1060 │ 0 │ INT │ 4 │ 0 │ N │ │ T4 │ 2022-10-27 18:53:21.649000 │ │ USER_ID │ 1060 │ 1 │ CHARACTER VARYING │ 8188 │ 0 │ N │ │ T4 │ 2022-10-27 18:53:21.649000 │ │ USER_NAME │ 1060 │ 2 │ TEXT │ 2147483647 │ 0 │ N │ │ T4 │ 2022-10-27 18:53:21.649000 │ │ role │ 1060 │ 3 │ TEXT │ 2147483647 │ 0 │ N │ │ T4 │ 2022-10-27 18:53:21.649000 │ │ source │ 1060 │ 4 │ TEXT │ 2147483647 │ 0 │ N │ │ T4 │ 2022-10-27 18:53:21.649000 │ ╰───────────┴──────┴───────┴───────────────────┴────────────┴───────┴───────────┴────────┴────────────┴────────────────────────────╯
Beta Was this translation helpful? Give feedback.
All reactions