2 Replies Latest reply on Jun 1, 2016 6:09 PM by Marco Ardito

    Can I have dots in a column alias?

    Marco Ardito Master

      I'm trying a simple query, but I wish to specify a column alias that contains a dot (for a column name abbreviation)




      SELECT id, rag_soc as `r.s` FROM "apifdbunica"."ag";


      but this fails with

      Error: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ", rag_soc as [*]`[*]r.s`" at line 1, column 23.

      Lexical error. Character is not a valid token: `

      SQLState:  50000

      ErrorCode: 0


      I tried escaping the dot, using backtick or double quotes delimiter, nothing seems to work


      Can this be done?

      I wonder how I never tried this before...