Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-11511

SQL: Possible bug with parameters passing for complex DML queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.8
    • sql
    • None

    Description

      See methods IgniteH2Indexing.executeSelectLocal and IgniteH2Indexing.executeSelectForDml. They both could be invoked for SELECT statements extracted from DML.

      But notice how parameters are passed: it seems that we may pass parameters from DML statement unchanged, which is illegal. E.g. consider the following DML:

      UPDATE table SET x=? WHERE x=?
      

      In this case SELECT statement should get only the second parameter.

      Need to create tests to confirm that this is the case and make necessary fixes if needed.

      Attachments

        Issue Links

          Activity

            People

              pkouznet Pavel Kuznetsov
              vozerov Vladimir Ozerov
              Votes:
              0 Vote for this issue
              Watchers:
              3 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 - 20m
                  20m