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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 4.5.1
    • Fix Version/s: None
    • Component/s: Query
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      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

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

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response: