Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Changes to src/insert.c.

   829    829       /* Cannot have triggers on a virtual table. If it were possible,
   830    830       ** this block would have to account for hidden column.
   831    831       */
   832    832       assert( !IsVirtual(pTab) );
   833    833   
   834    834       /* Create the new column data
   835    835       */
   836         -    for(i=0; i<pTab->nCol; i++){
   837         -      if( pColumn==0 ){
   838         -        j = i;
   839         -      }else{
          836  +    for(i=j=0; i<pTab->nCol; i++){
          837  +      if( pColumn ){
   840    838           for(j=0; j<pColumn->nId; j++){
   841    839             if( pColumn->a[j].idx==i ) break;
   842    840           }
   843    841         }
   844         -      if( (!useTempTable && !pList) || (pColumn && j>=pColumn->nId) ){
          842  +      if( (!useTempTable && !pList) || (pColumn && j>=pColumn->nId)
          843  +            || (pColumn==0 && IsHiddenColumn(&pTab->aCol[i])) ){
   845    844           sqlite3ExprCode(pParse, pTab->aCol[i].pDflt, regCols+i+1);
   846    845         }else if( useTempTable ){
   847    846           sqlite3VdbeAddOp3(v, OP_Column, srcTab, j, regCols+i+1); 
   848    847         }else{
   849    848           assert( pSelect==0 ); /* Otherwise useTempTable is true */
   850    849           sqlite3ExprCodeAndCache(pParse, pList->a[j].pExpr, regCols+i+1);
   851    850         }
          851  +      if( pColumn==0 && !IsHiddenColumn(&pTab->aCol[i]) ) j++;
   852    852       }
   853    853   
   854    854       /* If this is an INSERT on a view with an INSTEAD OF INSERT trigger,
   855    855       ** do not attempt any conversions before assembling the record.
   856    856       ** If this is a real table, attempt conversions as required by the
   857    857       ** table column affinities.
   858    858       */