Loading...

XML

Word

Printable

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

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

relates to

MODE-2267 Query constraints on node name and local name are swapped