====
---- QUERY
# Test setting zsort.columns and sort.zorder when using create table like.
create table zsortbytest sort by zorder (int_col, bool_col) like functional.alltypes;
describe formatted zsortbytest;
---- RESULTS: VERIFY_IS_SUBSET
'','sort.columns        ','int_col,bool_col    '
'','sort.order          ','ZORDER              '
---- TYPES
STRING,STRING,STRING
====
---- QUERY
# Test that sort.columns and sort.ordering will be inherited from the source table.
create table zsortbytest_clone like zsortbytest;
describe formatted zsortbytest_clone;
---- RESULTS: VERIFY_IS_SUBSET
'','sort.columns        ','int_col,bool_col    '
'','sort.order          ','ZORDER              '
---- TYPES
STRING,STRING,STRING
====
---- QUERY
# Test that sort.columns and sort.zorder can be overridden in the query.
create table zsortbytest_override sort by zorder (id, int_col) like zsortbytest;
describe formatted zsortbytest_override;
---- RESULTS: VERIFY_IS_SUBSET
'','sort.columns        ','id,int_col          '
'','sort.order          ','ZORDER              '
---- TYPES
STRING,STRING,STRING
====