====
---- QUERY
# Make sure that specifying sort by zorder columns sets the 'sort.columns'
# and 'sort.order' properties correctly.
create table zsortbytest (i int, d int, b boolean) sort by zorder (d, i);
describe formatted zsortbytest;
---- RESULTS: VERIFY_IS_SUBSET
'','sort.columns        ','d,i                 '
'','sort.order          ','ZORDER              '
---- TYPES
STRING,STRING,STRING
====