Strict subset of columns in sort order of superprojection

fsaintjacques

I can't find in the documentation what happens when a user provide a sort order in a CREATE TABLE statement (or superprojection) where the columns provided is a strict subset of the table column-list.

 

 

CREATE TEMP TABLE order_subset (a int, b int, c int, d int)
ORDER BY d, c;

 

 

Will Vertica enforce a total ordering of the rows by joining the missing column with the ordering in the column-list. In this case, the previous CREATE statement would be equivalent to

 

CREATE TEMP TABLE order_subset (a int, b int, c int, d int)
ORDER BY d, c, a, b;

 

The documentation state the default case when the user doesn't provide an ordering, I'd like to know the behaviour when the ordering is strictly partial.