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

UPDATE command with non-pushdown functions leads to TEIID30253 error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.1
    • 8.12.x
    • Query Engine
    • None
    • Hide

      1. Create textagg_test_2 table in a MySQL database:

      CREATE TABLE `textagg_test_2` (
  `id` varchar(4000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

      2. Configure a datasource to the MySQL database in standalone-teiid.xml.
      3. Configure a VDB in deployments folder containing a model with source to the MySQL datasource.

      4. Run the following queries:

      update test.textagg_test_2 set id =(select uuid());;

update test.textagg_test_2 set id =(select now());;

update test.textagg_test_2 set id =(select rand());;
      Show
      1. Create textagg_test_2 table in a MySQL database: CREATE TABLE `textagg_test_2` ( `id` varchar (4000) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 2. Configure a datasource to the MySQL database in standalone-teiid.xml. 3. Configure a VDB in deployments folder containing a model with source to the MySQL datasource. 4. Run the following queries: update test.textagg_test_2 set id =( select uuid());; update test.textagg_test_2 set id =( select now());; update test.textagg_test_2 set id =( select rand());;

      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.

              rhn-engineering-shawkins Steven Hawkins
              dalex005 Dmitrii Pogorelov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: