Using File > Export > Database to SQL File:
Tables containing some data, are written correctly. But for empty tables, an extra ); is added on a new line, after the table.
Example:
correct:
CREATE TABLE "Table_with_data" (
"object_id" INTEGER NOT NULL,
"value" REAL NULL);
INSERT INTO Table_with_data VALUES (1,40.0);
INSERT INTO Table_with_data VALUES (2,90.0);
incorrect:
CREATE TABLE "Empty_table" (
"object_id" INTEGER NOT NULL,
"value" REAL NULL);
); <<<<<<<<<< redundant closing bracket
AFAICS, this occurs since v3.6.0 (export was correct in 3.5.1)
Reactions are currently unavailable
Using File > Export > Database to SQL File:
Tables containing some data, are written correctly. But for empty tables, an extra ); is added on a new line, after the table.
Example:
correct:
CREATE TABLE "Table_with_data" (
"object_id" INTEGER NOT NULL,
"value" REAL NULL);
INSERT INTO Table_with_data VALUES (1,40.0);
INSERT INTO Table_with_data VALUES (2,90.0);
incorrect:
CREATE TABLE "Empty_table" (
"object_id" INTEGER NOT NULL,
"value" REAL NULL);
); <<<<<<<<<< redundant closing bracket
AFAICS, this occurs since v3.6.0 (export was correct in 3.5.1)