Am Do., 20. Dez. 2018 um 16:34 Uhr schrieb Mark Johnson < mj10...@googlemail.com>:
> Based on ticket > > https://www.sqlite.org/src/tktview?name=43ddc85a63 > > > > However, the column count is not correct. > In my case 2 columns are missing: which should be 19. > After a fresh look at this today, I realized that this error was caused by a faulty VIEW, where the 2 columns were not defined in the VIEW but being used in the TRIGGER. After correcting the VIEW, the error is different: ALTER TABLE "main"."middle_earth_admin" RENAME COLUMN "admin_type" TO "admin_level"; The lookupName parameter 'zCol' contains the new column name 'admin_level', but is searching for the old column name admin_type, which is not being found. -I-> lookupName -200a- looking_for[NEW.admin_type] pParse->eTriggerOp[116] pTriggerTab->zName[middle_earth_admin_general] -I-> lookupName -201a- looking_for[NEW.admin_type] op[116 !=TK_DELETE[117]] pTriggerTab->zName[middle_earth_admin_general] -I-> lookupName -202a loop - pCol->zName[admin_type]==zCol[admin_level] iCol[3] Error: near line 14: error in trigger vw_ins_middle_earth_admin_general after rename: no such column: NEW.admin_type > > > Mark Johnson > mj10...@googlemail.com > > > > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
