SQLite Forum

Bug: ALTER TABLE RENAME COLUM TO vs CTE VIEWs
Login
Similar to https://sqlite.org/forum/forumpost/04f72b274e but with `RENAME COLUMN` and after the changes there. Test case:

```sql
SELECT sqlite_source_id();

CREATE TABLE t0 AS SELECT 1 AS col1;

CREATE VIEW v0 AS
  WITH
  n AS (
    SELECT
      t0.col1
    FROM
      t0 
  ),
  o AS (
    SELECT
      col1
    FROM
      n
  )
  SELECT * FROM o
;

SELECT * FROM v0;

ALTER TABLE t0 RENAME COLUMN col1 TO col2;
```

```
% sqlite < sqlite-bug-rename-column
sqlite_source_id()                                                                  
------------------------------------------------------------------------------------
2021-06-11 13:18:56 230fedd923c87741d20caf55f29e8464cc6df344536f9b89331e0a0059a926f7
Run Time: real 0.000 user 0.000211 sys 0.000000
Run Time: real 0.001 user 0.000624 sys 0.000000
Run Time: real 0.000 user 0.000379 sys 0.000000
col1
----
1   
Run Time: real 0.000 user 0.000187 sys 0.000000
(1) statement aborts at 157: [ALTER TABLE t0 RENAME COLUMN col1 TO col2;] error in view v0 after rename: no such column: col1
Run Time: real 0.003 user 0.000000 sys 0.003209
Error: near line 24: error in view v0 after rename: no such column: col1
```