LOAD 'chdb_hook';
/****************************************************************************/
-- Enums.
CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');
CREATE TYPE dow AS ENUM ('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');
CREATE TABLE enums (
    dow  dow  NOT NULL,
    mood mood NOT NULL
);
INSERT INTO enums
VALUES ('Sun', 'ok')
     , ('Mon', 'sad')
     , ('Fri', 'happy')
;
-- Execute round-trip to all supported formats.
CREATE TABLE enums2 (LIKE enums INCLUDING ALL);
\set from_table enums
\set to_table enums2
\set output_file enums.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
/****************************************************************************/
-- Enum Arrays.
CREATE TABLE enum_arrays (
    dow  dow[]  NOT NULL,
    mood mood[] NOT NULL
);
INSERT INTO enum_arrays
VALUES ('{Sun, NULL, Thu}', '{ok, NULL, ok}')
     , ('{Mon, Tue, Wed}', '{sad, NULL, happy}')
;
-- 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 enum_arrays2 (LIKE enum_arrays INCLUDING ALL);
\set from_table enum_arrays
\set to_table enum_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