# in column name

Question

Opened this issue 4 years ago · 2 comments

Working with an exsisting DB structure and they have # special char all over their column names in a DB2 database.

Using
->orderBy( 'A.G01GL#' )

results in the sql statement being

ORDER BY
"A"."G01GL"# ASC

Any advice on how to get around this?

Answer 1 · 2020-05-28T18:34:28.000Z

problem is in function replaceNamesIn

Answer 2 · 2020-05-28T18:45:04.000Z

Modifying the regex in replaceNamesIn to /(\b)([a-z_][a-z0-9_]).([a-z#][a-z0-9#])/i solved it for me.