• Martin Hansson's avatar
    Bug#54568: create view cause Assertion failed: 0, · 0c81dcf3
    Martin Hansson authored
    file .\item_subselect.cc, line 836
    
    IN quantified predicates are never executed directly. They are rather wrapped
    inside nodes called IN Optimizers (Item_in_optimizer) which take care of the
    execution. However, this is not done during query preparation. Unfortunately
    the LIKE predicate pre-evaluates constant right-hand side arguments even
    during name resolution. Likely this is meant as an optimization.
    
    Fixed by not pre-evaluating LIKE arguments in view prepare mode.
    0c81dcf3
subselect4.test 1.88 KB