Oracle Dialect Quote Brackets #1434

New Issue

jama707 · 2019-09-25T09:05:45Z

sumiet commented

2019-09-25 09:05:45 +00:00

(Migrated from github.com)

I am using this library to generate queries for Oracle (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) and it generates table and column names with square brackets around them. For example:

Actual: Select [column_name] from [table_name];
Expected: Select column_name from table_name;

I did some analysis and found that the brackets are coming from the Quote method in oracl_dialect file. Is there a way to disable the quote application? or to go back to "\"" quote format?

If not please consider fixing it. Thanks in advance.

I am using this library to generate queries for Oracle (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) and it generates table and column names with square brackets around them. For example: Actual: Select [column_name] from [table_name]; Expected: Select column_name from table_name; I did some analysis and found that the brackets are coming from the `Quote` method in oracl_dialect file. Is there a way to disable the quote application? or to go back to `"\""` quote format? If not please consider fixing it. Thanks in advance.

👍 1

sumiet commented

2019-09-25 09:08:06 +00:00

(Migrated from github.com)

The reference git commit in which this change was brought in: b757473de7?diff=split

The reference git commit in which this change was brought in: https://github.com/go-xorm/xorm/commit/b757473de7f547d767fc5425c060026d5c89af5c?diff=split

jama707 referenced this issue

2020-01-08 16:15:17 +00:00

Oracle bracket quote is breaking queries #1507

lunny added this to the 1.1.1 milestone 2020-01-20 05:26:49 +00:00

lunny modified the milestone from 1.1.1 to 1.0.0

2020-02-29 09:22:43 +00:00

lunny closed this issue

2020-03-06 07:49:39 +00:00

lunny commented

2020-03-06 07:49:53 +00:00

Should be resolved by #1567

Sign in to join this conversation.