v.25.12Improvement

Allow implicit type conversion when casting Array

Official CH changelog text
Allow implicit type conversion when casting Array to QBit. Integer and float arrays can now be inserted directly into QBit columns without explicit type casts. #91846 (Raufs Dunamalijevs).
ClickHouse now supports implicit type conversion when casting Array to QBit, allowing integer and float arrays to be inserted directly into QBit columns without explicit type casting.

Why it matters

This feature simplifies data insertion workflows by removing the need for explicit type casts when working with QBit columns. It improves usability by enabling direct insertion of numeric arrays, reducing errors and streamlining queries involving bitset operations.

How to use it

Users can directly insert integer or float arrays into QBit typed columns without performing any manual casting. For example:

INSERT INTO table_with_qbit (qbit_column) VALUES ([1, 0, 1]);

ClickHouse will implicitly convert the Array to QBit automatically.

Related resources

PreviousNext