0.1.7

This is the sixth preview release of DuckDB. Feedback is very welcome. Binary builds are available as well.

SQL

• Add / remove columns, change default values & column type #612
• Collation support
• CSV sniffer READ_CSV_AUTO for dialect, data type and header detection #582
• SHOW & DESCRIBE Tables #501
• String function CONTAINS #488
• String functions LPAD / RPAD, LTRIM / RTRIM, REPEAT, REPLACE & UNICODE #597
• Bit functions BIT_LENGTH, BIT_COUNT, BIT_AND, BIT_OR, BIT_XOR & BIT_AGG #608

Engine

• LIKE optimization rules #559
• Adaptive filters in table scans #574
• ICU Extension for extended Collations & Extension Support #594
• Extended zone map support in scans #551
• Disallow NaN/INF in the system #541
• Use UTF Grapheme Cluster Breakers in Reverse and Shell #570

Clients

• Relation API for C++ #509 and Python #598
• Java (TM) JDBC (R) Client for DuckDB #492 #520 #550