Lines Matching refs:rowid
2467 sqlite3_int64 iRowid; /* Current rowid */
2689 ** Return the rowid for the current row. In this implementation, the
2690 ** first row returned is assigned rowid value 1, and each subsequent
2937 sqlite3_int64 iRowid; /* The rowid */
3222 ** Return the rowid for the current row. In this implementation, the
3223 ** rowid is the same as the output value.
4032 ") WITHOUT ROWID;";
4843 ** Return the rowid for the current row.
7574 "SELECT s.rowid, s.name, l.name FROM "
7988 #define SHFLG_PreserveRowid 0x00000008 /* .dump preserves rowid values */
8969 "INSERT INTO [_shell$self](rowid,op,cmd)\n"
8993 " SELECT rowid*10,op,cmd,ans FROM [_shell$self];\n"
9836 ** The azCol[0] entry is usually NULL. However, if zTab contains a rowid
9838 ** name of the rowid column.
9885 /* The decision of whether or not a rowid really needs to be preserved
9886 ** is tricky. We never need to preserve a rowid for a WITHOUT ROWID table
9888 ** rowids on tables where the rowid is inaccessible because there are other
9889 ** columns in the table named "rowid", "_rowid_", and "oid".
9893 ** might be an alise for the ROWID. But it might also be a WITHOUT ROWID
9895 ** ROWID aliases. To distinguish these cases, check to see if
9897 ** no "pk" index if the PRIMARY KEY really is an alias for the ROWID.
9912 /* Only preserve the rowid if we can find a name to use for the
9913 ** rowid */
9914 static char *azRowid[] = { "rowid", "_rowid_", "oid" };
9923 ** name for the rowid before adding it to azCol[0]. WITHOUT ROWID
10011 /* If preserving the rowid, add a column list after the table name.
10012 ** In other words: "INSERT INTO tab(rowid,a,b,c,...) VALUES(...)"
10067 ** "ORDER BY rowid DESC" to the end.
10087 sqlite3_snprintf(len+100, zQ2, "%s ORDER BY rowid DESC", zQuery);
10780 ** work for WITHOUT ROWID tables.
10872 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
10936 " WHERE %s ORDER BY rowid DESC", zWhere);
11450 const char *zGlobIPK = "SEARCH TABLE * USING INTEGER PRIMARY KEY (rowid=?)";
12690 " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
12692 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
12694 "ORDER BY rowid",
12700 "SELECT rowid FROM sqlite_master"
12987 "CREATE TABLE \"%w\"(%s,PRIMARY KEY(%s))WITHOUT ROWID",
13481 appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0);
13511 " ORDER BY snum, rowid", 0);
13960 appendText(&sQuery, " ORDER BY tbl, idx, rowid;\n", 0);
