Based on ticket https://www.sqlite.org/src/tktview?name=43ddc85a63
--- During work for spatialite, I have also run into this problem using version 3.25.3. Today I updated to 3.26.0 and saw that changes were made that (possibly) makes it easier to pinpoint the problem. With 3.25.3 lookupName was always being called with pTriggerTab->aCol == NULL -I-> lookupName -200b- looking_for[NEW.id_rowid] pTriggerTab->zName[middle_earth_general] *aCol[(nil)] nCol[0] -I-> lookupName -250b- pTriggerTab->zName[middle_earth_general] zTab[NEW] op[116] aCol->zName[NULL] nCol[0] -I-> lookupName -251b- pTriggerTab->zName[middle_earth_general] zTab[NEW] [op != 117] aCol->zName[NULL] -I-> lookupName -299- sqlite3SelectAddTypeInfo cnt[0] rc[1] error[no such column: NEW.id_rowid] -I-> sqlite3SelectPrep -103- sqlite3ResolveSelectNames rc[1] error[no such column: NEW.id_rowid] With 3.26.0 lookupName is being called 2 times, first with NULL and then again pTriggerTab->aCol != NULL. -I-> lookupName -200b- looking_for[(null).id_rowid] pParse->eTriggerOp[116] pTriggerTab->zName[middle_earth_general] *aCol[(nil)] nCol[-1] -I-> lookupName -200a- looking_for[NEW.id_rowid] pParse->eTriggerOp[116] pTriggerTab->zName[middle_earth_general] aCol->zName[id_rowid] nCol[17] However, the column count is not correct. In my case 2 columns are missing: which should be 19. -I-> lookupName -201a- looking_for[NEW.id_belongs_to] op[116 !=TK_DELETE[117]] pTriggerTab->zName[middle_earth_general] aCol->zName[id_rowid] nCol[17] -I-> lookupName -202a loop - iCol[0] pCol->zName[id_belongs_to]==zCol[id_rowid] -I-> lookupName -202a loop - iCol[1] pCol->zName[id_belongs_to]==zCol[id_admin] -I-> lookupName -202a loop - iCol[2] pCol->zName[id_belongs_to]==zCol[name] -I-> lookupName -202a loop - iCol[3] pCol->zName[id_belongs_to]==zCol[admin_type] * missing id_belongs_to -I-> lookupName -202a loop - iCol[4] pCol->zName[id_belongs_to]==zCol[belongs_to_01] * missing id_belongs_to_02 -I-> lookupName -202a loop - iCol[5] pCol->zName[id_belongs_to]==zCol[belongs_to_02] -I-> lookupName -202a loop - iCol[6] pCol->zName[id_belongs_to]==zCol[valid_since] -I-> lookupName -202a loop - iCol[7] pCol->zName[id_belongs_to]==zCol[valid_until] -I-> lookupName -202a loop - iCol[8] pCol->zName[id_belongs_to]==zCol[map_x] -I-> lookupName -202a loop - iCol[9] pCol->zName[id_belongs_to]==zCol[map_y] -I-> lookupName -202a loop - iCol[10] pCol->zName[id_belongs_to]==zCol[srid] -I-> lookupName -202a loop - iCol[11] pCol->zName[id_belongs_to]==zCol[order_selected] -I-> lookupName -202a loop - iCol[12] pCol->zName[id_belongs_to]==zCol[rule_type] -I-> lookupName -202a loop - iCol[13] pCol->zName[id_belongs_to]==zCol[rule_text] -I-> lookupName -202a loop - iCol[14] pCol->zName[id_belongs_to]==zCol[notes] -I-> lookupName -202a loop - iCol[15] pCol->zName[id_belongs_to]==zCol[text] -I-> lookupName -202a loop - iCol[16] pCol->zName[id_belongs_to]==zCol[eur_point] resulting in the error: error in trigger vw_ins_middle_earth_general: no such column: NEW.id_belongs_to. Mark Johnson mj10...@googlemail.com _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
