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

org.teiid.padSpace does not affect to the "IN" operator

    Details

    • Steps to Reproduce:
      Hide
      • Start JDV with -Dorg.teiid.padSpace=true option
      • Download and open an attached teiid project based on JBDS 8.1
      • Download an attached csv file, and set the file path to the teiid project
      • Build and deploy the vdb
      • Execute following query

      EXECUTE TestModel.test1();
      EXECUTE TestModel.test2();
      EXECUTE TestModel.test3();

      Show
      Start JDV with -Dorg.teiid.padSpace=true option Download and open an attached teiid project based on JBDS 8.1 Download an attached csv file, and set the file path to the teiid project Build and deploy the vdb Execute following query EXECUTE TestModel.test1(); EXECUTE TestModel.test2(); EXECUTE TestModel.test3();
    • Bugzilla Update:
      Perform

      Description

      org.teiid.padSpace does affect to "=" operator. But does not affect to "IN" operator.

      [data for a column named "id"]

        "test1     "
      

      ["=" operator] I can get a result

        SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id ='TEST1';
      

      ["IN" operator] I can not get a result

        SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id IN ('TEST1', 'TEST2');
      

        Gliffy Diagrams

          Attachments

          1. datasert.csv
            0.0 kB
          2. INTERNAL_TEST.zip
            78 kB
          3. test.vdb
            16 kB

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                hisao.furuichi hisao furuichi
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: