Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4236

EXIST2IN in any place of the query

        Details

          Description

          Remove IN NULL processing in converted EXISTS for IN2EXISTS and Materialization strategies.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Technical task - A technical task. MDEV-4246 Assertion `!exists_transformed || null_value == (0)' fails with exists_to_in=on, LEFT JOIN, NOT EXISTS

                • Major - Major loss of function.
                • Open

                  Activity

                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  IN2EXISTS:
                  left part NULL processed in Item_in_optimizer::val_int()
                  NULL caused by presence of NULL in answer processed in Item_in_subselect::val_*

                  Show
                  sanja Oleksandr Byelkin added a comment - IN2EXISTS: left part NULL processed in Item_in_optimizer::val_int() NULL caused by presence of NULL in answer processed in Item_in_subselect::val_*

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      Reporter:
                      sanja Oleksandr Byelkin
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: