-
Bug
-
Resolution: Done
-
Major
-
8.12.x
-
None
-
teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA
teiid-9.0.3 on WildFly Full 9.0.2.Final
Running the following queries:
update test.textagg_test_2 set id =(select uuid());;
or
update test.textagg_test_2 set id =(select rand());;
leads to the following errors:
TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = (SELECT uuid() LIMIT 2)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates.
and
TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = convert((SELECT rand() LIMIT 2), string)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates.
though the following query:
update test.textagg_test_2 set id =(select now());;
works without errors.