/ 
DBIO-ClickHouse-0.900004
/ DBIO::ClickHouse::Test::Schema::Reading

NAME

DBIO::ClickHouse::Test::Schema::Reading - Test result class -- partition key, PRIMARY KEY prefix, LowCardinality

VERSION

version 0.900004

DESCRIPTION

The table that exercises every clickhouse_table clause a CREATE TABLE can carry at once: a PARTITION BY expression, a PRIMARY KEY that is a strict prefix of the sorting key, and a multi-column ORDER BY.

Deploying it is what puts three separate live assumptions under test without a single assertion being written for them:

  • system.tables reports partition_key, sorting_key and primary_key as distinct values over the MySQL wire protocol -- if the primary key merely mirrored the sorting key here, the round trip would come back different from what was deployed.

  • Date32 and DateTime64(3) (what the portable date and datetime map to, see "Type mapping" in DBIO::ClickHouse::DDL) are accepted by the server version under test.

  • toYYYYMM() accepts a DateTime64 argument, which is the partition expression any time-series schema on this driver will write.

AUTHOR

DBIO Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.