2 Replies Latest reply on Feb 15, 2012 6:57 PM by skethire

    8.0 Alpha1:  QueryParserException if column name is 'value'

    skethire
    skethire Feb 15, 2012 6:22 PM

      I have a Vdb that includes several

       

      tables with a column called 'value'.  When I do a select query against this table, I get QueryParseException.  I am connecting to teiid  using squirrel 3.0.1

       

      Query String: 

       

           SELECT value, create_date, create_user_id, data_source, description, update_date, update_user_id FROM input_data_type;

       

      Response from Teiid:

      Error: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "value" at line 1, column 8.

      Was expecting one of:

          <ALL_IN_GROUP> ...

          "not" ...

          "?" ...

          <POS_REF> ...

          <STRINGVAL> ...

          <INTEGERVAL> ...

          <FLOATVAL> ...

          <DECIMALVAL> ...

          "false" ...

          "true" ...

          ...

       

      Is 'value' a keyword in teiid?  If so, what is the workaround?

       

      Thanks

      srini