The following tests

main.warnings main.limit main.order_by main.subselect_no_mat main.udf

fail with mwl106 . Before mwl106 , those tests either passed or failed with errors due to different ordering of result sets.

The failures are as follows:

• main.warnings, main.limit - select from view with LIMIT 0 seems to return 1 row

• main.order_by - query reports "out of memory"

• main.subselect_no_mat - crash in replace_where_subcondition(), a separate known semijoin bug

• main.udf - queries return different results when compared to no view-protocol