Uploaded image for project: 'Nuxeo Studio'
  1. Nuxeo Studio
  2. NXS-128

problem in query operation with '<' and '>'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2
    • Component/s: Automation

      Description

      aused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.query.QueryParseException. message: org.nuxeo.ecm.core.query.QueryParseException: Lexical Error: Illegal character <&> at offset 70 in query: SELECT * From DocumentationItem where documentationitem:archival_date <= TIMESTAMP '2010-04-19 11:18:52.442'
      at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:56)
      at org.nuxeo.ecm.core.storage.sql.NXQLQueryMaker.buildQuery(NXQLQueryMaker.java:198)
      at org.nuxeo.ecm.core.storage.sql.Mapper.query(Mapper.java:1946)
      at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:714)
      at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:277)
      at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:505)
      at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1377)
      ... 140 more
      Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.query.QueryParseException. message: org.nuxeo.ecm.core.query.QueryParseException: Lexical Error: Illegal character <&> at offset 70
      at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:46)
      at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:52)
      ... 146 more
      Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.query.QueryParseException. message: Lexical Error: Illegal character <&> at offset 70
      at org.nuxeo.ecm.core.query.sql.parser.Scanner.scanError(Scanner.java:653)
      at org.nuxeo.ecm.core.query.sql.parser.Scanner.next_token(Scanner.java:1082)
      at java_cup.runtime.lr_parser.scan(lr_parser.java:335)
      at java_cup.runtime.lr_parser.parse(lr_parser.java:563)
      at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:44)
      ... 147 more

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: