Strict subset of columns in sort order of superprojection
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.
0