Skip to main content

FIXTURE_T

krishiv_sql::coverage

Constant FIXTURE_T 

Source 
pub const FIXTURE_T: &str = "CREATE TABLE t AS SELECT * FROM (VALUES \
    (1, 'a', TIMESTAMP '2024-01-01 00:00:00'), \
    (2, 'b', TIMESTAMP '2024-01-01 00:01:30'), \
    (3, 'a', TIMESTAMP '2024-01-01 00:03:00')) v(id, name, ts)";
Expand description

The fixture DDL run before the SQL checklist cases: t(id, name, ts) and u(id, val) as session tables.