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

Regression in salesforce translator when using LIKE query with wildcard

    Details

    • Sprint:
      DV Sprint 62
    • Story Points:
      0.5

      Description

      Running any query with a LIKE and wildcard such as

      select Name from Account where Name like 'gene%'
      

      results in

      SQL Error [30504] [50000]: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 bqt: null
      

      In the client.

      The exception in the vdb pod is

      org.teiid.translator.TranslatorException: null
      	at org.teiid.spring.data.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:247) ~[spring-data-salesforce-1.4.1.fuse-jdk11-800014-redhat-00001.jar!/:1.4.1.fuse-jdk11-800014-redhat-00001]
      	at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:249) ~[translator-salesforce-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:402) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at jdk.internal.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) ~[na:na]
      	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
      	at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
      	at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:228) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at com.sun.proxy.$Proxy121.execute(Unknown Source) ~[na:na]
      	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
      	at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:59) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:124) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$2.run(ThreadReuseExecutor.java:212) ~[teiid-engine-13.1.1.fuse-jdk11-800017-redhat-00001.jar!/:13.1.1.fuse-jdk11-800017-redhat-00001]
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na]
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na]
      	at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na]
      Caused by: com.sforce.soap.partner.fault.InvalidFieldFault: null
      	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
      	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:na]
      	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
      	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[na:na]
      	at java.base/java.lang.Class.newInstance(Class.java:584) ~[na:na]
      	at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:673) ~[force-wsc-45.1.0.jar!/:na]
      	at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:556) ~[force-wsc-45.1.0.jar!/:na]
      	at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:236) ~[force-wsc-45.1.0.jar!/:na]
      	at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:210) ~[force-wsc-45.1.0.jar!/:na]
      	at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:156) ~[force-wsc-45.1.0.jar!/:na]
      	at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99) ~[force-wsc-45.1.0.jar!/:na]
      	at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1197) ~[force-partner-api-45.1.0.jar!/:na]
      	at org.teiid.spring.data.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:244) ~[spring-data-salesforce-1.4.1.fuse-jdk11-800014-redhat-00001.jar!/:1.4.1.fuse-jdk11-800014-redhat-00001]
      	... 18 common frames omitted
      
      2020-04-20 13:11:21.198  WARN 1 --- [ocessorQueue310] org.teiid.PROCESSOR                      : TEIID30020 Processing exception for request 9oUsxRHqO3g6.35 'TEIID30504 bqt: null'. Originally TeiidProcessingException java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method). Enable more detailed logging to see the entire stacktrace.
      

      When not using a wildcard, the query passes.

      This used to work correctly in 7.6

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  shawkins Steven Hawkins
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - 2 hours
                    2h
                    Remaining:
                    Remaining Estimate - 2 hours
                    2h
                    Logged:
                    Time Spent - Not Specified
                    Not Specified