SQL INSERT allows NULL on non-nullable SHORT column

[amunra]

To reproduce

1. CREATE TABLE with a SHORT datatype.
2. INSERT INTO a NULL into the SHORT column.
3. Query back.

Expected:

• The SQL Insert statement (step 2) should have failed.

Actual:

• All statements pass, the actual value returned is 0 instead instead of NULL.

QuestDB version:

7.4.0

OS, in case of Docker specify Docker and the Host OS:

MacOS

File System, in case of Docker specify Host File System:

APFS

Full Name:

Adam Cimarosti

Affiliation:

QuestDB

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response

[ideoma]

There are no non-nullable types in QuestDB. You cannot specify NOT NULL when you create table.