• Martin Hansson's avatar
    Bug#54568: create view cause Assertion failed: 0, · ffdeb062
    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.
    
    Back-ported to 5.0s
    ffdeb062
subselect4.test 1.88 KB