| ==== |
| ---- 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 |
| ==== |