ktorm icon indicating copy to clipboard operation
ktorm copied to clipboard

Incorrect typeName for CastingExpressions in mysql

Open dchung-cargurus opened this issue 2 years ago • 0 comments

In our upgrade to ktorm 3.6, we've found an issue related to the typeName being incorrect for mysql when visitCasting runs on CastingExpressions. For example, from https://www.w3schools.com/sql/func_mysql_cast.asp the VarCharSqlType yields a syntax breaking argument for cast.

For instance, the expressiontable.cast(VarCharSqlType) will yield the sql cast( id AS VARCHAR) rather than cast(id AS CHAR), which would be the valid sql expression (https://www.w3schools.com/sql/func_mysql_cast.asp).

dchung-cargurus avatar Aug 23 '23 20:08 dchung-cargurus