sql>create table t(a int);
operation successful (0.650ms)
sql>insert into t values (1),(0),(3),(2);
4 affected rows (0.638ms)
sql>
sql>create table sorted_t as select a from t order by a with data;
operation successful (0.807ms)
sql>
sql>select table,column,sorted from sys.storage() where "table"='sorted_t';
+----------+--------+--------+
| table | column | sorted |
+==========+========+========+
| sorted_t | a | false |
+----------+--------+--------+
I am pretty sure it use to be that the sorting used in a "CREATE TABLE AS ... WITH DATA" would result in the tsorted property to be true for the (first) sorted column.
Now this isn't the case. Is that a bug or a feature?