Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3186

IN expressions in UPDATE statements throws Exceptions

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Invalid
    • 1.20.0
    • 1.22.0
    • None

    Description

      The patch to get correlated sub-queries working in UPDATE statements had this side-effect.

       

      CREATE TABLE t1 (id1 INT, val1 TEXT);
CREATE TABLE t2 (id2 INT, val2 TEXT);

UPDATE t1 SET val1 = 't2' WHERE id1 IN (1, 2, 3);

-- or

UPDATE t1 SET val1 = 't2' WHERE id1 IN (SELECT id2 FROM t2);

       

      These seem to raise exceptions now.

      Attachments

        Issue Links

          depends upon

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3219 Allow finer control over which expressions get expanded in SqlToRelConverter

          • Major - Major loss of function.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2427 Sub-queries not supported in DML statements

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #1341

          Activity

            People

              Unassigned Unassigned
              psockali Pressenna
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h