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

using LIKE on columns causes no results though they indeed exist

XMLWordPrintable

    • Hide

      After publishing a TeiiD view model issue the following query:

      select *
      from transform_withSql

      You should see a record for each 'view' in your model.

      Now issue the query:

      select *
      from transform_withSql
      where transform_selectSql like '%SELECT%'

      Which SHOULD return likely the same number of rows as all VIEWS will contain the word SELECT, yet NO rows return

      Show
      After publishing a TeiiD view model issue the following query: select * from transform_withSql You should see a record for each 'view' in your model. Now issue the query: select * from transform_withSql where transform_selectSql like '%SELECT%' Which SHOULD return likely the same number of rows as all VIEWS will contain the word SELECT, yet NO rows return

      Use of LIKE doesn't appear to work when querying modeshape through JDBC.

              van.halbert Van Halbert (Inactive)
              tljohnst@gmail.com thomas johnston (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: