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

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

XMLWordPrintable

    • 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();

      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');
      

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

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-hfuruich Hisao Furuichi
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: