• gkodinov/kgeorge@magare.gmz's avatar
    Bug #32036: EXISTS within a WHERE clause with a UNION · 55afc5c2
    gkodinov/kgeorge@magare.gmz authored
      crashes MySQL 5.122
    There was a difference in how UNIONs are handled
    on top level and when in sub-query.
    Because the rules for sub-queries were syntactically
    allowing cases that are not currently supported by
    the server we had crashes (this bug) or wrong results
    (bug 32051).
    Fixed by making the syntax rules for UNIONs match the 
    ones at top level.
    
    These rules however do not support nesting UNIONs, e.g.
    (SELECT a FROM t1 UNION ALL SELECT b FROM t2) 
     UNION
    (SELECT c FROM t3 UNION ALL SELECT d FROM t4)
    Supports for statements with nested UNIONs will be
    added in a future version.
    55afc5c2
subselect.test 112 KB