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

Calcite integration. Merge index conditions for the same field.

    XMLWordPrintableJSON

    Details

    • Ignite Flags:
      Release Notes Required

      Description

      Index scans should be able to merge index conditions. For example query

      SELECT * FROM tbl WHERE a<5 AND a<10
      

      should be reduced to

       

      SELECT * FROM tbl WHERE a<5
      

      Parameters should be handled in a more tricky way:

      SELECT * FROM tbl WHERE a<?1 AND a<?2
      

      can be rewritten as

      SELECT * FROM tbl WHERE a<MIN(?1, ?2)

      where the expression MIN(?1, ?2) should be evaluated right before the execution when parameters are known.

       

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rkondakov Roman Kondakov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: