SQLite Forum

Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8
Login
Command-line shell test case:

> ~~~
CREATE TABLE t1(a,b,c,d);
.limit function_arg 8
ALTER TABLE t1 RENAME COLUMN c to x;
.schema
~~~

Should now be fixed on trunk.  Please report back if you disagree.