Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-9043

It is not possible to compare TIMESTAMP and DATE in HSQLDB

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • None
    • 4.5.1
    • Query
    • Unknown
    • N/A
    • N/A

    Description

      From the XWQL documentation, this query should work:

      $services.query.xwql("where doc.date > '2012-01-02'").execute()

      But instead an error occurs:

      Caused by: org.hsqldb.HsqlException: incompatible data types in combination

      Attachments

        Activity

          People

            tmortagne Thomas Mortagne
            sdumitriu Sergiu Dumitriu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: