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

Google translator throws SpreadsheetOperationException for query DELETE FROM table

    XMLWordPrintable

Details

    Description

      Query "DELETE FROM smalla" where smalla is table throws exception:

      07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request
      Invalid query parameter value for sq.

      Please see server.log, standalone.xml and vdb for other information.

      Attachments

        1. googlespreadsheetcrud-vdb.xml
          5 kB
        2. server.log
          219 kB
        3. standalone.xml
          35 kB
        4. teiid-4666.png
          teiid-4666.png
          42 kB

        Issue Links

          is incorporated by

          Bug - A problem that impairs or prevents the functions of the product. TEIID-4468 Google translator evaluates 0 as not NULL for operator <>

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved
          is related to

          Quality Risk - A potential bug. TEIID-4672 Sheet with header becomes invalid

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) TEIID-3216 Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              lfabriko@redhat.com Lucie Krejcirova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: