• unknown's avatar
    MDEV-5401: Wrong result (missing row) on a 2nd execution of PS with... · 39afdcdd
    unknown authored
    MDEV-5401: Wrong result (missing row) on a 2nd execution of PS with exists_to_in=on, MERGE view or a SELECT SQ
    
    The problem was that the view substitute its fields (on prepare) with reverting the change after execution. After prepare on optimization exists2in convertion substituted arguments of '=' with constsnt '1', but then one of the arguments of '=' was reverted to the view field reference.This lead to incorrect WHERE condition on the second execution.
    
    To fix the problem we replace whole '=' with '1' permannently.
    39afdcdd
subselect_exists2in.test 29.4 KB