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

Browser just crashes after executing this query · Issue #228 · sqlitebrowser/sqlitebrowser · GitHub

Browser just crashes after executing this query #228

Description

Hello,

Start with a new DB and go to SQL tab and execute:

CREATE TABLE customer(
id INTEGER,
firstName TEXT,
middleName TEXT,
lastName TEXT,
address TEXT,
contactNum TEXT
);

CREATE TABLE item(
id INTEGER,
name TEXT,
description TEXT
);

CREATE TABLE orders(
id INTEGER,
customerID INTEGER,
date TEXT,
FOREIGN KEY(customerId) REFERENCES customer(id)
);

CREATE TABLE item_order(
id INTEGER,
orderID INTEGER,
itemId INTEGER,
quantity INTEGER,
FOREIGN KEY(orderId) REFERENCES orders(Id),
FOREIGN KEY(itemId) REFERENCES item(Id)
);

After you execute this, save the db.

Now switch to the "Database structure" tab, and SQLite Browser will simply close!

Now anytime you try to open that DB, the browser crashes!

Metadata

Metadata

Assignees

No one assigned

    Labels

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

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


    Back | FazBrowse Home | New Git URL