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
8424 #define SQLITE_CountRows 0x00001000 /* Count rows changed by INSERT, */
8847 ** is returned. REPLACE means that preexisting database rows that caused
8951 unsigned *aiRowEst; /* Result of ANALYZE: Est. rows selected by each column */
9659 u8 isMultiWrite; /* True if statement may affect/insert multiple rows */
9804 * target -> A token holding the quoted name of the table to update rows of.
38227 ** row or one of the rows being modified.
38240 int isClearTable /* True if all rows are being deleted */
48419 ** to 6.6 percent. The test case is inserting 1000 rows into a table
48496 /* When the number of output rows reaches nRow, that means the
48498 ** nRow is the sum of the number of rows in the main program, plus
48499 ** the sum of the number of rows in all trigger subprograms encountered
50201 ** This function compares the two table rows or index records
53520 ** not return the number of rows modified. And do not RELEASE the statement
53529 ** DML statements invoke this opcode to return the number of rows
56339 ** multiple rows.
56953 ** count is incremented by the number of rows in the table being cleared.
56955 ** also incremented by the number of rows in the table being cleared.
65120 /* The sqlite_stat[12] table already exists. Delete all rows. */
65237 ** The total number of rows in the table.
65330 ** rows of the table the index will select. If D is the count of distinct
65331 ** values and K is the total number of rows, then the integer is computed
69310 ** number of rows in the table that match any particular value of the
69312 ** of rows that match any particular combiniation of the first 2 columns
69969 ** inserting multiple rows in a table, or inserting a row and index entries.)
70707 ** set of rows in the view that are to be added to the ephemeral table.
70958 /* Initialize the counter of the number of rows deleted, if
70959 ** we are counting rows.
70987 int iRowSet = ++pParse->nMem; /* Register for rowset of rows to delete */
71053 /* Return the number of rows that were deleted. If this routine is
71060 sqlite3VdbeSetColName(v, 0, COLNAME_NAME, "rows deleted", SQLITE_STATIC);
71175 ** handle rows (possibly in other tables) that refer via a foreign key
72848 ** search the child table for rows that correspond to the new
72860 ** the child table for rows that correspond to the deleted row
72873 ** resolution is considered to delete rows before the new row is inserted.
73228 ** The code generated by this function scans through the rows in the child
74371 ** loop over the rows in the SELECT
74411 ** C: loop over rows of intermediate table
74730 /* Initialize the count of rows to be inserted
74758 ** C: loop over rows of intermediate table
74972 /* Update the count of rows that are inserted
75015 ** Return the number of rows inserted. If this routine is
75022 sqlite3VdbeSetColName(v, 0, COLNAME_NAME, "rows inserted", SQLITE_STATIC);
79521 ** after the t1 loop and rows with t1.x!=5 will never appear in
80589 ** "LIMIT -1" always shows all rows. There is some
80592 ** no rows.
81298 KeyInfo *pKeyMerge; /* Comparison information for merging rows */
81388 ** for the logic that removes duplicate result rows when the
83015 int groupBySort; /* Rows come from source in GROUP BY order */
83101 /* Begin a loop that will extract all source rows in GROUP BY order.
83110 /* The optimizer is able to deliver rows in group by order so
83117 /* Rows are coming out in undetermined order. We have to push
83547 int nRow; /* Number of rows in the result */
83636 int *pnRow, /* Write the number of rows in the result here */
84149 Token *pTableName, /* The table from which rows are deleted */
84930 int regRowCount = 0; /* A count of rows changed */
84935 int regRowSet = 0; /* Rowset of rows to be updated */
85135 /* Initialize the count of updated rows
85312 ** handle rows (possibly in other tables) that refer via a foreign key
85351 ** Return the number of rows that were changed. If this routine is
85358 sqlite3VdbeSetColName(v, 0, COLNAME_NAME, "rows updated", SQLITE_STATIC);
85422 ** all updated rows.
86759 ** rows. Indices are selected and used to speed the search when doing
86938 double nRow; /* Estimated number of output rows */
88807 ** This function is used to estimate the number of rows that will be visited
88837 ** approximately 1/100th (1%) of the rows selected by the nEq equality
88930 ** * The estimated number of rows that will be retrieved. (The
89002 /* The aiRowEstPk[0] is an estimate of the total number of rows in the
89004 ** available. If not available, assume the table 1 million rows in size.
89025 double nRow; /* Estimated number of rows in result set */
89032 ** cost and number of rows returned.
89054 ** the sub-select is assumed to return 25 rows for the purposes of
89142 ** naturally scan rows in the required order, set the appropriate flags
89144 ** will scan rows in a different order, set the bSort variable. */
89179 ** Estimate the number of rows of output. For an IN operator,
89180 ** do not let the estimate exceed half the rows in the table.
89190 ** rows plus log2(table-size) times the number of binary searches.
89194 /* Adjust the number of rows and the cost downward to reflect rows
89247 ** SQLite outputs rows in in the absence of an ORDER BY clause. */
89654 ** we reference multiple rows using a "rowid IN (...)"
90258 ** Terms of the WHERE clause are also used to limit which rows actually
100571 ** statement loops through all rows of the %_content table. For a
103846 ** this file contains code to insert, update and delete rows from FTS3
104134 ** all rows in the %_segdir table, from oldest to newest. If successful,
105590 sqlite3_stmt *pDelete; /* SQL statement to delete rows */
107309 ** number of hits for each phrase in each column across all rows
