Pavan Nambi

Don't allow dropping column if trigger referencing it

1

seed : ```1155061234992720784``` ```sql Use ".open FILENAME" to reopen on a persistent database turso> CREATE TABLE t ( n REAL ); CREATE TABLE t1 ( m TEXT, d REAL );...

trigger with recursive update and inserts causes rowids ordering messed up (corruption?)

4

this might go more bad if we insert more or do more operations. ```sql CREATE TABLE t (a REAL, b INTEGER, c TEXT); INSERT INTO t VALUES (1.0, 100, 'row1'),...

btree page type mismatch after recursive trigger inserts

1

seed: `18153314986703395229` ```sql turso> CREATE TABLE courageous_most_0 ( incredible_estonia_1 TEXT, imaginative_reclus_2 TEXT, romantic_provocazione_3 INTEGER, fortuitous_rublyov_4 INTEGER, incredible_hostis_5 REAL, optimistic_oneal_6 REAL, resourceful_king_7 TEXT, fortuitous_holdsworth_8 REAL ); INSERT INTO courageous_most_0 VALUES ('adaptable_shiar',...

Alloc default header for empty dbs

1

closes https://github.com/tursodatabase/turso/issues/3441 ``` turso> select group_concat(name) over () from sqlite_schema; turso> values (1) intersect values (1); ┌───┐ │ 0 │ ├───┤ │ 1 │ └───┘ turso> PRAGMA integrity_check; ┌────┐ │...

triggers shall not be created on vtabs

1

```sql turso> .load target/debug/liblimbo_csv.so turso> CREATE VIRTUAL TABLE t USING csv(filename='data.csv', header=1); turso> CREATE TABLE t1(id INT, name TEXT); turso> CREATE TRIGGER trg AFTER INSERT ON t BEGIN INSERT INTO...

seed: ```10798804968462485620``` similar to https://github.com/tursodatabase/turso/issues/4028 ```sql turso> CREATE TABLE t ( a INTEGER, b TEXT ); CREATE TABLE t1 ( x INTEGER, y TEXT ); CREATE TRIGGER trg AFTER UPDATE...

```sql turso> CREATE TABLE t ( id INT PRIMARY KEY, n TEXT, m INT ); CREATE TABLE t1 ( eid INT PRIMARY KEY, d INT ); CREATE TRIGGER trg AFTER...

Alter rename shall update table name(entire sql?) inside views

1

similar to https://github.com/tursodatabase/turso/issues/4007 ```sql turso> CREATE TABLE t1(id INT); turso> CREATE VIEW v AS SELECT * FROM t1 WHERE id > 0; turso> ALTER TABLE t1 RENAME TO t1_new; turso>...

Alter rename should rewrite stuff inside trigger

2

seed - `11128012010874390124` - just for my reference so i can later pull main and run ```sql turso> CREATE TABLE t1 (id INT); CREATE TABLE t (id INT); turso> CREATE...

```sql turso> create table t(x); turso> create index ye on t(rowid); turso> turso on  main [?] is 📦 v0.4.0-pre.3 via 🐍 v3.12.3 via 🦀 v1.88.0 took 56s ❯ sqlite3...