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
    • Bugzilla Update:
      Perform

      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: