Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
github.com/mariadb-corporation/mariadb-columnstore-docker.git
mariadb-columnstore-1.0.9-1-centos7.x86_64.rpm.tar.gz
Description
I'm using Pentho Kettle to load data into the DW.
Some pdi steps generate SQL queries for lookup data.
The following is a snippet of a generated SQL where the CAST() function throw a exception if we try to cast for VARCHAR:
MariaDB [dbtest]> SELECT dpro_id
|
-> FROM dbtest.d_prov
|
-> WHERE ( CAST('NotNull' AS VARCHAR(256)) IS NULL ) |
-> ;
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VARCHAR(256)) IS NULL )' at line 3 |
But the same SQL works if we try to cast for CHAR:
MariaDB [dbtest]> SELECT dpro_id
|
-> FROM dbtest.d_prov
|
-> WHERE ( CAST('NotNull' AS CHAR) IS NULL ) |
-> ;
|
Empty set (0.04 sec) |
|
Best Regards.