On 12/26/18, Mark Johnson <mj10...@googlemail.com> wrote: > 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";
I closed the original ticket (which I neglected to do originally) with an explanation of why it is not a bug. In order for us to investigate this new problem you are having, please supply us with the VIEW, CREATE TRIGGER, and ALTER TABLE statements that are giving you trouble. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
