I am trying to fire insert query on a column which contains space in it's name using teiid admin api. I have tried following variants of queries but Teiid driver throwing sql exception.
1. INSERT INTO WITHSPACECONN.DATABASE_NAME.TABLE_NAME(TABLE_NAME.ID,TABLE_NAME.FIRST NAME)VALUES('1','fdsaf') -- hre column is surrounded by nothing.
2. INSERT INTO WITHSPACECONN.DATABASE_NAME.TABLE_NAME(TABLE_NAME.ID,TABLE_NAME.`FIRST NAME`)VALUES('1','fdsaf') -- here column is surrounded by "`" character
3. INSERT INTO VDB_NAME.DATABASE_NAME.TABLE_NAME(TABLE_NAME.ID,TABLE_NAME.'FIRST NAME')VALUES('1','fdsaf') -- here single quote
Where "First Name" is column contains space in its name, WITHSPACECONN is VDB name, DATABASE_NAME is the name of database and TABLE_NAME is name of table.
I am using mysql database
Is there any other way form a query?
Identifiers need to be double quoted to contain whitespace - "FIRST NAME".