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

Google Spreadsheet translator incorrect results DELETE with boolean in criteria

XMLWordPrintable

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

      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'),
      

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

                Created:
                Updated:
                Resolved: