LOAD 'chdb_hook';
/****************************************************************************/
-- Bit Strings.
CREATE TABLE bits (
    b  BIT       NOT NULL,
    bn BIT(3)    NOT NULL,
    vb varbit(6) NOT NULL
);
INSERT INTO bits
VALUES ('1', '111', '111111')
     , ('0', '000', '000000')
     , ('0', '000', '000000')
;
-- Execute round-trip to all supported formats.
CREATE TABLE bits2 (LIKE bits INCLUDING ALL);
\set from_table bits
\set to_table bits2
\set output_file bits.tmp
\i test/utils/round-trip-formats.sql
\set ECHO errors
t: TabSeparated
t: TabSeparatedRaw
t: TabSeparatedWithNames
t: TabSeparatedWithNamesAndTypes
t: TabSeparatedRawWithNames
t: TabSeparatedRawWithNamesAndTypes
t: CSV
t: CSVWithNames
t: CSVWithNamesAndTypes
t: CustomSeparated
t: CustomSeparatedWithNames
t: CustomSeparatedWithNamesAndTypes
t: Values
t: JSON
t: JSONColumns
t: JSONColumnsWithMetadata
t: JSONCompact
t: JSONCompactColumns
t: JSONEachRow
t: JSONStringsEachRow
t: JSONCompactEachRow
t: JSONCompactStringsEachRow
t: JSONCompactEachRowWithNames
t: JSONCompactEachRowWithNamesAndTypes
t: JSONCompactStringsEachRowWithNames
t: JSONCompactStringsEachRowWithNamesAndTypes
t: JSONObjectEachRow
t: TSKV
t: Native
t: RowBinary
t: RowBinaryWithNames
t: RowBinaryWithNamesAndTypes
t: Parquet
t: Arrow
t: ArrowStream
t: ORC
t: Avro
t: Protobuf
t: ProtobufList
t: MsgPack
t: BSONEachRow
/****************************************************************************/
-- Bit String Arrays
CREATE TABLE bit_arrays (
    b  BIT[]       NOT NULL,
    bn BIT(3)[]    NOT NULL,
    vb varbit(6)[] NOT NULL
);
INSERT INTO bit_arrays
VALUES ('{1}', '{111}', '{111111}')
     , ('{0,1,NULL}', '{000,001,111,110}', '{000000,111001,101010}')
;
-- Execute round-trip to all supported formats. Protobuf has no null in a
-- repeated field, so the arrays carrying one come back short.
CREATE TABLE bit_arrays2 (LIKE bit_arrays INCLUDING ALL);
\set from_table bit_arrays
\set to_table bit_arrays2
\i test/utils/round-trip-formats.sql
\set ECHO errors
t: TabSeparated
t: TabSeparatedRaw
t: TabSeparatedWithNames
t: TabSeparatedWithNamesAndTypes
t: TabSeparatedRawWithNames
t: TabSeparatedRawWithNamesAndTypes
t: CSV
t: CSVWithNames
t: CSVWithNamesAndTypes
t: CustomSeparated
t: CustomSeparatedWithNames
t: CustomSeparatedWithNamesAndTypes
t: Values
t: JSON
t: JSONColumns
t: JSONColumnsWithMetadata
t: JSONCompact
t: JSONCompactColumns
t: JSONEachRow
t: JSONStringsEachRow
t: JSONCompactEachRow
t: JSONCompactStringsEachRow
t: JSONCompactEachRowWithNames
t: JSONCompactEachRowWithNamesAndTypes
t: JSONCompactStringsEachRowWithNames
t: JSONCompactStringsEachRowWithNamesAndTypes
t: JSONObjectEachRow
t: TSKV
t: Native
t: RowBinary
t: RowBinaryWithNames
t: RowBinaryWithNamesAndTypes
t: Parquet
t: Arrow
t: ArrowStream
t: ORC
t: Avro
f: Protobuf
f: ProtobufList
t: MsgPack
t: BSONEachRow
\set ECHO errors