KX Insights Core 3.2.3
Release Date
2022-10-03
KX Core
[NEW] NUC - various changes to .Q.id
// NUC
// .Q.id for atom now produces `a when contains single character that is not in .Q.an (instead of empty sym) e.g.
q).Q.id`$"+"
`a // (previous version returned `)
// .Q.id for atom changes are reflected in .Q.id for tables (as before, it was applied to each column name).
// .Q.id for tables also has additional logic to cater for duplicate col names (names now appended with 1,2,etc when matched against previous cols) after applying previously defined rules e.g.
q)cols .Q.id(`$("count+";"count*";"count1"))xcol([]1 2;3 4;5 6)
`count1`count11`count12 // (previous version returned `count1`count1`count1)
q)cols .Q.id(`$("aa";"=";"+"))xcol([]1 2;3 4;5 6)
`aa`a`a1 // (previous version returned `aa`1`1)
// .Q.id now follows the same rule when provided name begins with an underscore as it does when it begins with a numerical character. Previously could produce an invalid column name.
q).Q.id`$"_"
`a_
q)cols .Q.id(`$("3aa";"_aa";"_aa"))xcol([]1 2;3 4;5 6)
`a3aa`a_aa`a_aa1Object Store
[FIX] qce now works with Data Enablement license instead of throwing the below error:
'Object Storage not licensed SQL
[FIX] select w/o aggregates performance improvement.
[FIX] Errors when browsing tables in Spotfire information designer have been fixed.
[NEW] pgwire text format now has 1us precision timestamp.
[FIX] q type minute now mapped to pgwire time.