Open
Description
Details for the issue
DROP TABLE command doesn't work in Execute SQL with saved Projects.
What did you do?
I wrote and run a code:
CREATE TABLE IF NOT EXISTS stock (
company TEXT NOT NULL,
stock_exchange TEXT NOT NULL,
price REAL,
PRIMARY KEY (company, stock_exchange)
);
INSERT INTO stock (company, stock_exchange, price)
VALUES ('ABC', 'GPW', 180.0),
('DEF', 'GPW', 190.0);
DROP TABLE stock;
It was working perfectly, so I saved my database as Project.
On another day I loaded my project and ran it.
What did you expect to see?
That table stock disappeared from tree in DB Schema.
What did you see instead?
"Console":
Execution finished without errors.
SQL Log:
-- EXECUTING LINE IN '05_primaty_key.sql'
--
Screen:
Terminal code to compare:
$ sqlite3
SQLite version 3.40.1 2022-12-28 14:03:47
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open app.db
sqlite> .tables
stock user
sqlite> DROP TABLE stock;
sqlite> .tables
user
sqlite>
Useful extra information
DB4S v3.12.99 (Mar 15 2023) [built for x86_64-little_endian-lp64] on Ubuntu Core 20 (linux/5.19.0-38-generic) [x86_64]
using SQLCipher Version 4.4.3 community (based on SQLite 3.34.1)
and Qt 5.12.8