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

Sending teiid varbinary value (x'') to Microsoft SQL Server errors

XMLWordPrintable

      When sending a query to Microsoft SQL Server with a varbinary in criteria:

      select * from debBinary where ipv6= x'FFFF6BBE85D8'

      It pushes the criteria to Microsoft SQL Server, but as X'FFFF6BBE85D8'[1] so Microsoft gives the syntax error[2] and needs to just be select * from debBinary where ipv6= 'FFFF6BBE85D8':

      [1]14:26:08,951 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8) Source-specific command: SELECT g_0."id", g_0."ipv6" FROM "bqt2"."dbo"."debbinary" g_0 WHERE g_0."ipv6" = X'FFFF6BBE85D8'

      [2] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'FFFF6BBE85D8'.

            [TEIID-4008] Sending teiid varbinary value (x'') to Microsoft SQL Server errors

            RH Bugzilla Integration added a comment -

            Filip Elias <felias@redhat.com> changed the Status of bug 1313407 from VERIFIED to CLOSED

            RH Bugzilla Integration added a comment - Filip Elias <felias@redhat.com> changed the Status of bug 1313407 from VERIFIED to CLOSED

            RH Bugzilla Integration added a comment -

            Juraj Duráni <jdurani@redhat.com> changed the Status of bug 1313407 from ON_QA to VERIFIED

            RH Bugzilla Integration added a comment - Juraj Duráni <jdurani@redhat.com> changed the Status of bug 1313407 from ON_QA to VERIFIED

            RH Bugzilla Integration added a comment -

            Alex Szczuczko <aszczucz@redhat.com> changed the Status of bug 1313407 from MODIFIED to ON_QA

            RH Bugzilla Integration added a comment - Alex Szczuczko <aszczucz@redhat.com> changed the Status of bug 1313407 from MODIFIED to ON_QA

            RH Bugzilla Integration added a comment -

            jolee@redhat.com changed the Status of bug 1313407 from ASSIGNED to MODIFIED

            RH Bugzilla Integration added a comment - jolee@redhat.com changed the Status of bug 1313407 from ASSIGNED to MODIFIED

            RH Bugzilla Integration added a comment -

            jolee@redhat.com changed the Status of bug 1313407 from MODIFIED to ASSIGNED

            RH Bugzilla Integration added a comment - jolee@redhat.com changed the Status of bug 1313407 from MODIFIED to ASSIGNED

            RH Bugzilla Integration added a comment -

            jolee@redhat.com changed the Status of bug 1313407 from ASSIGNED to MODIFIED

            RH Bugzilla Integration added a comment - jolee@redhat.com changed the Status of bug 1313407 from ASSIGNED to MODIFIED

            Steven Hawkins added a comment -

            Updated to address the pg select with a cast.

            Steven Hawkins added a comment - Updated to address the pg select with a cast.

            Steven Hawkins added a comment -

            No, this is not a regression.

            Steven Hawkins added a comment - No, this is not a regression.

            Johnathon Lee added a comment -

            jdurani, does this represent a regression? ie: from the title, it doesn't appear to target postgres.

            Johnathon Lee added a comment - jdurani , does this represent a regression? ie: from the title, it doesn't appear to target postgres.

            Steven Hawkins added a comment -

            This isn't directly related to this fix. Postgresql is complaining because the default type is string for a select literal (which is really odd behavior sometimes). In most any other position in the query, this would work as expected. I'll just address under this same issue.

            Steven Hawkins added a comment - This isn't directly related to this fix. Postgresql is complaining because the default type is string for a select literal (which is really odd behavior sometimes). In most any other position in the query, this would work as expected. I'll just address under this same issue.

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-dsteigner Deborah Steigner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: