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

using LIKE on columns causes no results though they indeed exist

    Details

    • Steps to Reproduce:
      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

      Description

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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  van.halbert Van Halbert
                  Reporter:
                  virtualdatabase Tom Johnston
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: