Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5163

Google Spreadsheet translator incorrect results DELETE with boolean in criteria

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • None
    • 8.12.11.6_4
    • Misc. Connectors
    • None

    Description

      When performing DELETE against Google Spreadsheet everything evaluates to false.

      DELETE FROM SmallA WHERE BooleanValue
      

      update count is 0, but should be 16.

      DELETE FROM SmallA WHERE NOT BooleanValue
      

      update count is 26, but should be 10.

      The BooleanValue column is modeled as:

              booleanvalue boolean OPTIONS (NATIVE_TYPE 'BOOLEAN'),
      

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: