• Martin Hansson's avatar
    Bug#54568: create view cause Assertion failed: 0, · f7799695
    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.
    f7799695
subselect4.result 2.59 KB