Behavior of asc table

Community Support
,
1

https://learninghub.kx.com/forums/topic/behavior-of-asc-table

The doc on asc says

table, returns it sorted by the first non-key column and with the partitioned attribute set on it

But when there is only one non-keyed column, it’s actually the sorted attribute that is set.

q)meta asc ([c1:`a`b] c2:2 1) 
c | t f a 
--| ----- 
c1| s 
c2| j   s 

q)meta asc ([c1:`a`b] c2:2 1; c3:01b) 
c | t f a 
--| ----- 
c1| s 
c2| j   p 
c3| b

Perhaps an incomplete doc? Wonder if there is other edge case.

2

Hi darrenwsun,

Yes, this is expected behavior and we will update the documentation to reflect.

Thanks for raising, I’ve created a GitHub issue for tracking.

Kind regards,

David