Closed
Description
I've been playing with chdb and I was experimenting with creating tables.
I did a mistake while creating the following table:
const createSql = `CREATE TABLE IF NOT EXISTS invalid_create_table (id Int32)
ENGINE = MergeTree()
PARTITION BY (id)
SETTINGS index_granularity = 8192;`
const res = session.query(createSql);
console.log(res);
The console.log(res);
returns empty result and not indication for an error.
Where the ClickHouse playground returns:
Code: 36. DB::Exception: You must provide an ORDER BY or PRIMARY KEY expression in the table definition. If you don't want this table to be sorted, use ORDER BY/PRIMARY KEY (). Otherwise, you can use the setting 'create_table_empty_primary_key_by_default' to automatically add an empty primary key to the table definition. (BAD_ARGUMENTS) (version 24.4.4.113 (official build))
Am I doing something wrong is is this a real bug/issue?
Metadata
Metadata
Assignees
Labels
No labels