Lines Matching full:rows
812 ** is NULL, then no callback is ever invoked and result rows are
1858 ** INSERT continues to completion after deleting rows that caused
1878 ** CAPI3REF: Count The Number Of Rows Modified
1880 ** ^This function returns the number of database rows that were changed
1893 ** caused by an INSERT, DELETE, or UPDATE statement. Rows that
1932 ** CAPI3REF: Total Number Of Rows Modified
1941 ** count does not include rows of views that fire an [INSTEAD OF trigger],
2125 ** The table conceptually has a number of rows and columns. But
2127 ** numbers are obtained separately. Let N be the number of rows
2152 ** There are two column (M==2) and three rows (N==3). Thus the
2191 int *pnRow, /* Number of result rows written here */
2452 ** [truncate optimization] is disabled and all rows are deleted individually.
3843 ** last time when the xFinal callback is invoked. ^(When no rows match
4384 ** is not invoked when duplication rows are deleted because of an
4386 ** invoked when rows are deleted using the [truncate optimization].
5641 ** the number of table searches or result rows, that would tend to indicate
8429 #define SQLITE_CountRows 0x00001000 /* Count rows changed by INSERT, */
8852 ** is returned. REPLACE means that preexisting database rows that caused
8956 unsigned *aiRowEst; /* Result of ANALYZE: Est. rows selected by each column */
9664 u8 isMultiWrite; /* True if statement may affect/insert multiple rows */
9809 * target -> A token holding the quoted name of the table to update rows of.
38232 ** row or one of the rows being modified.
38245 int isClearTable /* True if all rows are being deleted */
48430 ** to 6.6 percent. The test case is inserting 1000 rows into a table
48507 /* When the number of output rows reaches nRow, that means the
48509 ** nRow is the sum of the number of rows in the main program, plus
48510 ** the sum of the number of rows in all trigger subprograms encountered
50212 ** This function compares the two table rows or index records
53531 ** not return the number of rows modified. And do not RELEASE the statement
53540 ** DML statements invoke this opcode to return the number of rows
56350 ** multiple rows.
56964 ** count is incremented by the number of rows in the table being cleared.
56966 ** also incremented by the number of rows in the table being cleared.
65131 /* The sqlite_stat[12] table already exists. Delete all rows. */
65248 ** The total number of rows in the table.
65341 ** rows of the table the index will select. If D is the count of distinct
65342 ** values and K is the total number of rows, then the integer is computed
69321 ** number of rows in the table that match any particular value of the
69323 ** of rows that match any particular combiniation of the first 2 columns
69980 ** inserting multiple rows in a table, or inserting a row and index entries.)
70718 ** set of rows in the view that are to be added to the ephemeral table.
70969 /* Initialize the counter of the number of rows deleted, if
70970 ** we are counting rows.
70998 int iRowSet = ++pParse->nMem; /* Register for rowset of rows to delete */
71064 /* Return the number of rows that were deleted. If this routine is
71071 sqlite3VdbeSetColName(v, 0, COLNAME_NAME, "rows deleted", SQLITE_STATIC);
71186 ** handle rows (possibly in other tables) that refer via a foreign key
72859 ** search the child table for rows that correspond to the new
72871 ** the child table for rows that correspond to the deleted row
72884 ** resolution is considered to delete rows before the new row is inserted.
73239 ** The code generated by this function scans through the rows in the child
74382 ** loop over the rows in the SELECT
74422 ** C: loop over rows of intermediate table
74741 /* Initialize the count of rows to be inserted
74769 ** C: loop over rows of intermediate table
74983 /* Update the count of rows that are inserted
75026 ** Return the number of rows inserted. If this routine is
75033 sqlite3VdbeSetColName(v, 0, COLNAME_NAME, "rows inserted", SQLITE_STATIC);
79532 ** after the t1 loop and rows with t1.x!=5 will never appear in
80600 ** "LIMIT -1" always shows all rows. There is some
80603 ** no rows.
81309 KeyInfo *pKeyMerge; /* Comparison information for merging rows */
81399 ** for the logic that removes duplicate result rows when the
83026 int groupBySort; /* Rows come from source in GROUP BY order */
83112 /* Begin a loop that will extract all source rows in GROUP BY order.
83121 /* The optimizer is able to deliver rows in group by order so
83128 /* Rows are coming out in undetermined order. We have to push
83558 int nRow; /* Number of rows in the result */
83647 int *pnRow, /* Write the number of rows in the result here */
84160 Token *pTableName, /* The table from which rows are deleted */
84941 int regRowCount = 0; /* A count of rows changed */
84946 int regRowSet = 0; /* Rowset of rows to be updated */
85146 /* Initialize the count of updated rows
85323 ** handle rows (possibly in other tables) that refer via a foreign key
85362 ** Return the number of rows that were changed. If this routine is
85369 sqlite3VdbeSetColName(v, 0, COLNAME_NAME, "rows updated", SQLITE_STATIC);
85433 ** all updated rows.
86770 ** rows. Indices are selected and used to speed the search when doing
86949 double nRow; /* Estimated number of output rows */
88818 ** This function is used to estimate the number of rows that will be visited
88848 ** approximately 1/100th (1%) of the rows selected by the nEq equality
88941 ** * The estimated number of rows that will be retrieved. (The
89013 /* The aiRowEstPk[0] is an estimate of the total number of rows in the
89015 ** available. If not available, assume the table 1 million rows in size.
89036 double nRow; /* Estimated number of rows in result set */
89043 ** cost and number of rows returned.
89065 ** the sub-select is assumed to return 25 rows for the purposes of
89153 ** naturally scan rows in the required order, set the appropriate flags
89155 ** will scan rows in a different order, set the bSort variable. */
89190 ** Estimate the number of rows of output. For an IN operator,
89191 ** do not let the estimate exceed half the rows in the table.
89201 ** rows plus log2(table-size) times the number of binary searches.
89205 /* Adjust the number of rows and the cost downward to reflect rows
89258 ** SQLite outputs rows in in the absence of an ORDER BY clause. */
89665 ** we reference multiple rows using a "rowid IN (...)"
90269 ** Terms of the WHERE clause are also used to limit which rows actually
100605 ** statement loops through all rows of the %_content table. For a
103886 ** this file contains code to insert, update and delete rows from FTS3
104174 ** all rows in the %_segdir table, from oldest to newest. If successful,
105630 sqlite3_stmt *pDelete; /* SQL statement to delete rows */
107349 ** number of hits for each phrase in each column across all rows
