Loading...

XML

Word

Printable

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 References:
https://bugzilla.redhat.com/show_bug.cgi?id=1260874

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