Lines Matching refs:rowid
2473 sqlite3_int64 iRowid; /* Current rowid */
2695 ** Return the rowid for the current row. In this implementation, the
2696 ** first row returned is assigned rowid value 1, and each subsequent
2943 sqlite3_int64 iRowid; /* The rowid */
3228 ** Return the rowid for the current row. In this implementation, the
3229 ** rowid is the same as the output value.
4038 ") WITHOUT ROWID;";
4849 ** Return the rowid for the current row.
7580 "SELECT s.rowid, s.name, l.name FROM "
7994 #define SHFLG_PreserveRowid 0x00000008 /* .dump preserves rowid values */
8975 "INSERT INTO [_shell$self](rowid,op,cmd)\n"
8999 " SELECT rowid*10,op,cmd,ans FROM [_shell$self];\n"
9842 ** The azCol[0] entry is usually NULL. However, if zTab contains a rowid
9844 ** name of the rowid column.
9891 /* The decision of whether or not a rowid really needs to be preserved
9892 ** is tricky. We never need to preserve a rowid for a WITHOUT ROWID table
9894 ** rowids on tables where the rowid is inaccessible because there are other
9895 ** columns in the table named "rowid", "_rowid_", and "oid".
9899 ** might be an alise for the ROWID. But it might also be a WITHOUT ROWID
9901 ** ROWID aliases. To distinguish these cases, check to see if
9903 ** no "pk" index if the PRIMARY KEY really is an alias for the ROWID.
9918 /* Only preserve the rowid if we can find a name to use for the
9919 ** rowid */
9920 static char *azRowid[] = { "rowid", "_rowid_", "oid" };
9929 ** name for the rowid before adding it to azCol[0]. WITHOUT ROWID
10017 /* If preserving the rowid, add a column list after the table name.
10018 ** In other words: "INSERT INTO tab(rowid,a,b,c,...) VALUES(...)"
10073 ** "ORDER BY rowid DESC" to the end.
10093 sqlite3_snprintf(len+100, zQ2, "%s ORDER BY rowid DESC", zQuery);
10803 ** work for WITHOUT ROWID tables.
10895 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
10959 " WHERE %s ORDER BY rowid DESC", zWhere);
11473 const char *zGlobIPK = "SEARCH TABLE * USING INTEGER PRIMARY KEY (rowid=?)";
12713 " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
12715 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
12717 "ORDER BY rowid",
12723 "SELECT rowid FROM sqlite_master"
13010 "CREATE TABLE \"%w\"(%s,PRIMARY KEY(%s))WITHOUT ROWID",
13504 appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0);
13534 " ORDER BY snum, rowid", 0);
13983 appendText(&sQuery, " ORDER BY tbl, idx, rowid;\n", 0);
