[teiid-issues] [JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13343031#comment-13343031 ] 

Steven Hawkins commented on TEIID-4666:
---------------------------------------

To clarify Q1 was causing a NPE on our side with the initial fix for TEIID-4468.  It does appear that google expects a predicate for the delete and thus an exception on their side.  We'll have to see if there is a workaround for this, such as a dummy predicate.  If not, then that will simply be an unsupported operation.

> Google translator throws SpreadsheetOperationException for query DELETE FROM table
> ----------------------------------------------------------------------------------
>
>                 Key: TEIID-4666
>                 URL: https://issues.jboss.org/browse/TEIID-4666
>             Project: Teiid
>          Issue Type: Feature Request
>    Affects Versions: 8.12.8.6_3
>            Reporter: Lucie Fabrikova
>            Assignee: Steven Hawkins
>         Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)