FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

incorrect CREATE TABLE ending in sql export · Issue #349 · sqlitebrowser/sqlitebrowser · GitHub

incorrect CREATE TABLE ending in sql export #349

Description

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)

Metadata

Metadata

Assignees

Labels

bugConfirmed bugs or reports that are very likely to be bugs.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions


Back | FazBrowse Home | New Git URL