Column names with dots
17 views
Skip to first unread message
Danel Kotev
May 1, 2021, 5:12:52 PM5/1/21
to ScalikeJDBC Users Group
Hi!
I have a set of column names which contain dots. In order to support these names, I wrap them with double quotes.
However, it seems like the library doesn't support this column naming since it's ResultSQLSyntaxProvider selects names in the following way:
I have a set of column names which contain dots. In order to support these names, I wrap them with double quotes.
However, it seems like the library doesn't support this column naming since it's ResultSQLSyntaxProvider selects names in the following way:
"${tableAliasName}.${c.value} as ${name}${delimiterForResultName}${tableAliasName}"
And in my case, if the column name is "x" and my table name is pr, it translates it into:
pr."x" as "x"_pr
pr."x" as "x"_pr
meaning: the as expressing is not a valid sql syntax.
How can I overcome this obstacle?
Reply all
Reply to author
Forward
0 new messages