How to access columns containing space in there name using VDB.

[kulbhushanc]

Hi,

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.

Queries are:-

--

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?

Thanks,

Kulbhushan Chaskar.

[shawkins]

Identifiers need to be double quoted to contain whitespace - "FIRST NAME".