v22.8.6.72-clib

Release v22.8.6.72-clib

Image is published at icr.io/clickhouse/clickhouse:22.8.6.72-1-clib-ibm

• This Release is on top of v22.8.6.71-lts
• From branch Kusto-phase3

---

October 12, 2022

operator

• distinct
  Customers | distinct *
Customers | distinct Occupation
Customers | distinct Occupation, Education
Customers | where Age <30 | distinct Occupation, Education
Customers | where Age <30 | order by Age| distinct Occupation, Education

String functions

• reverse
  print reverse(123)
print reverse(123.34)
print reverse('clickhouse')
print reverse(3h)
print reverse(datetime(2017-1-1 12:23:34))

• parse_command_line
  print parse_command_line('echo \"hello world!\" print$?', \"Windows\")

• parse_csv
  print result=parse_csv('aa,b,cc')
print result_multi_record=parse_csv('record1,a,b,c\nrecord2,x,y,z')

• parse_json
  print parse_json( dynamic([1, 2, 3]))
print parse_json('{"a":123.5, "b":"{\\"c\\":456}"}')

• extract_json
  print extract_json( "$.a" , '{"a":123, "b":"{\\"c\\":456}"}' , typeof(int))

• parse_version
  print parse_version('1')
print parse_version('1.2.3.40')

Bug fixed

• correct array index in expression
  array index should start with 0

• Summarize should generate alias or use correct columns

  • if bin is used , the column should be in select list if no alias include
  • if no column included in aggregate functions, ( like count() ), should has alias with fun name + '',e.g count
  • if column name included in aggregate functions, should have fun name + "_" + column name , like count(Age) -> count_Age
  • if argument of an aggregate functions is an exprision, Columns1 ... Columnsn should be used as alias

    Customers | summarize count() by bin(Age, 10)  
    ┌─Age─┬─count_─┐
    │  40 │      2 │
    │  20 │      6 │
    │  30 │      4 │
    └─────┴────────┘
    Customers | summarize count(Age) by bin(Age, 10)  
    ┌─Age─┬─count_Age─┐
    │  40 │         2 │
    │  20 │         6 │
    │  30 │         4 │
    └─────┴───────────┘
    Customers | summarize count(Age+1) by bin(Age+1, 10)
    ┌─Columns1─┬─count_─┐
    │       40 │      2 │
    │       20 │      6 │
    │       30 │      4 │
    └──────────┴────────┘
    

• extend doesn't replace existing columns

• throw exception if use quoted string as alias

• repeat() doesn't work with count argument as negative value

• substring() doesn't work right with negative offsets

• endofmonth() doesn't return correct result

• split() outputs array instead of string

• split() returns empty string when arg goes out of bound

• split() doesn't work with negative index