[ https://issues.jboss.org/browse/TEIID-5060?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-5060: ------------------------------------ I created sample VDB which reproduces the issue: {code:xml|title=teiid5060-vdb.xml} <vdb name="teiid5060" version="1"> <model name="Source" type="PHYSICAL" visible="false"> <source name="jdg7-source" translator-name="infinispan-hotrod" connection-jndi-name="java:/jdg71HotrodDS" /> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE SmallA ( StringNum string, StringKey string PRIMARY KEY ) OPTIONS(UPDATABLE true, "teiid_ispn:cache" 'jdg71_crud_null'); ]]> </metadata> <metadata type = "NATIVE"/> </model> <model name="CRUD" type="VIRTUAL"> <metadata type="DDL"><![CDATA[ CREATE VIEW SmallA( StringNum string, StringKey string PRIMARY KEY ) OPTIONS (UPDATABLE true) AS SELECT source.StringNum, source.StringKey FROM Source.SmallA as source; ]]> </metadata> </model> </vdb> {code} Then steps to reproduce: # {code:sql|title=SELECT query}SELECT * FROM SMallA{code} returns || StringNum || StringKey || (empty resultset) # {code:sql|title=INSERT query}INSERT INTO SmallA(StringKey, StringNum) VALUES ('1','23'),('2','34');{code} # {code:sql|title=SELECT query 2}SELECT * FROM SMallA{code} returns || StringNum || StringKey || | 34 | 2 | | 23 | 1 | # {code:sql|title=UPDATE query}UPDATE SmallA SET StringKey=5 WHERE StringNum>30{code} # {code:sql|title=SELECT query 3}SELECT * FROM SMallA{code} returns || StringNum || StringKey || | 34 | 2 | | 23 | 1 | Note that 'SELECT query 2' and 'SELECT query 3' returns identical results. -- This message was sent by Atlassian JIRA (v7.2.3#72005)