1 Reply Latest reply on Sep 6, 2016 10:41 AM by Steven Hawkins

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

    Kulbhushan Chaskar Master

      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.