blob: 92c05e88842a799a707bd6551553b8d35ceca2cf [file] [log] [blame]
explain plan for select * from ( select max(col_int), col_boln from (select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_0_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_1_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_0_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_1_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_0_v` union all select col_int, col_bgint, col_char, col_vchar, col_tmstmp, col_date, col_boln, col_dbl from `prqUnAll_1_v`) tmp group by tmp.col_boln ) t limit 0;