Default values are ignored in FILESTORAGE and LOCALSTORAGE #1848
Open
Description
I have the following tables:
CREATE TABLE IF NOT EXISTS banks (
name STRING PRIMARY KEY,
is_open BOOLEAN DEFAULT true,
[key] STRING
);
CREATE TABLE IF NOT EXISTS pigs (
id STRING PRIMARY KEY,
bank STRING DEFAULT null,
ready BOOLEAN DEFAULT false,
dream STRING,
notes STRING,
kind STRING,
timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (bank) REFERENCES bank(name)
);I have noticed that when I do an INSERT, all unspecified values are left as undefined instead of using any of the DEFAULT specifications.
This has been tested for both FILESTORAGE and LOCALSTORAGE.