lib/sqlite/sqlite3.c

2133 ** the table has a column of type [INTEGER PRIMARY KEY] then that column
4029 ** <tr><td>  NULL    <td> INTEGER   <td> Result is 0
4033 ** <tr><td> INTEGER  <td>  FLOAT    <td> Convert from integer to float
4034 ** <tr><td> INTEGER  <td>   TEXT    <td> ASCII rendering of the integer
4035 ** <tr><td> INTEGER  <td>   BLOB    <td> Same as INTEGER->TEXT
4036 ** <tr><td>  FLOAT   <td> INTEGER   <td> Convert from float to integer
4039 ** <tr><td>  TEXT    <td> INTEGER   <td> Use atoi()
4042 ** <tr><td>  BLOB    <td> INTEGER   <td> Convert to TEXT then use atoi()
5164 ** [INTEGER PRIMARY KEY] column has been explicitly declared, then the output
5166 ** explicitly declared [INTEGER PRIMARY KEY] column, then the output
5170 **     data type: "INTEGER"
9901 ** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
9903 ** that the datatype of the PRIMARY KEY must be INTEGER for this field to
9904 ** be set.  An INTEGER PRIMARY KEY is used as the rowid for each row of
9905 ** the table.  If a table has no INTEGER PRIMARY KEY, then a random rowid
9907 ** the table has any PRIMARY KEY, INTEGER or otherwise.
9984 **       a INTEGER PRIMARY KEY,
9985 **       b INTEGER CONSTRAINT fk1 REFERENCES ex2(x)
57670 ** manifest type INTEGER.
63324 ** into a numeric representation.  Use either INTEGER or REAL whichever
71998             /* Substitute the rowid (column -1) for the INTEGER PRIMARY KEY */
74418 ** to be unique - either because it is an INTEGER PRIMARY KEY or it
74423 ** be used unless <column> is an INTEGER PRIMARY KEY or an index can
74650       ** if either column has NUMERIC or INTEGER affinity. If neither
80262 ** If the PRIMARY KEY is on a single column whose datatype is INTEGER,
80265 ** INTEGER PRIMARY KEY column.  Table.iPKey is set to -1 if there is
80266 ** no INTEGER PRIMARY KEY.
80268 ** If the key is not an INTEGER PRIMARY KEY, then create a unique
80269 ** index for the key.  No index is created for INTEGER PRIMARY KEYs.
80307   if( zType && sqlite3StrICmp(zType, "INTEGER")==0
80316        "INTEGER PRIMARY KEY");
85792 **     CREATE TABLE t1(a, b INTEGER PRIMARY KEY, c);
85807 ** If successful, zero is returned. If the parent key is an INTEGER PRIMARY
85859   ** maps to the INTEGER PRIMARY KEY of table pParent. If so, leave *ppIdx
85869     **   1) There is an INTEGER PRIMARY KEY column and the FK is implicitly
85871     **   2) The FK is explicitly mapped to a column declared as INTEGER
86007       /* If pIdx is NULL, then the parent key is the INTEGER PRIMARY KEY
86016       ** will have INTEGER affinity applied to it, which may not be correct.  */
86927 **  'd'            INTEGER
86976 **  'd'            INTEGER
87331   int keyColumn = -1;   /* Column that is the INTEGER PRIMARY KEY */
87584   ** If the table has an INTEGER PRIMARY KEY column and that column
87692     /* build the NEW.* reference row.  Note that if there is an INTEGER
87758   ** except when the table has an INTEGER PRIMARY KEY column, in which
87813         /* The value of the INTEGER PRIMARY KEY column is always a NULL.
88111   /* If we have an INTEGER PRIMARY KEY, make sure the primary key
88589     return 0;   /* Both tables must have the same INTEGER PRIMARY KEY */
88650     /* If tables do not have an INTEGER PRIMARY KEY and there
93334 ** declaration type for a ROWID field is INTEGER. Exactly when an expression
93390         **   CREATE TABLE t1(col INTEGER);
93395         ** though it should really be "INTEGER".
93428           zType = "INTEGER";
101691   ** as "x>NULL" if x is not an INTEGER PRIMARY KEY.  So construct a
104082       zMsg = sqlite3MAppendf(db, zMsg, "%s USING INTEGER PRIMARY KEY", zMsg);
106479   "VALUES",        "INTEGER",       "FLOAT",         "BLOB",
106708  /* 191 */ "term ::= INTEGER|FLOAT|BLOB",
106784  /* 267 */ "number ::= INTEGER|FLOAT",
107741       case 267: /* number ::= INTEGER|FLOAT */ yytestcase(yyruleno==267);
108142       case 191: /* term ::= INTEGER|FLOAT|BLOB */ yytestcase(yyruleno==191);
112744     zDataType = "INTEGER";
114802   zContentCols = sqlite3_mprintf("docid INTEGER PRIMARY KEY");
114817       "CREATE TABLE %Q.'%q_segments'(blockid INTEGER PRIMARY KEY, block BLOB);",
114822         "level INTEGER,"
114823         "idx INTEGER,"
114824         "start_block INTEGER,"
114825         "leaves_end_block INTEGER,"
114826         "end_block INTEGER,"
114834         "CREATE TABLE %Q.'%q_docsize'(docid INTEGER PRIMARY KEY, size BLOB);",
114840         "CREATE TABLE %Q.'%q_stat'(id INTEGER PRIMARY KEY, value BLOB);",
119597 **   distance_opt ::= / INTEGER.
123209 **   CREATE TABLE %_segments(blockid INTEGER PRIMARY KEY, block BLOB)
127056 **   CREATE TABLE %_node(nodeno INTEGER PRIMARY KEY, data BLOB)
127057 **   CREATE TABLE %_parent(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)
127058 **   CREATE TABLE %_rowid(rowid INTEGER PRIMARY KEY, nodeno INTEGER)
129939 "CREATE TABLE \"%w\".\"%w_node\"(nodeno INTEGER PRIMARY KEY, data BLOB);"
129940 "CREATE TABLE \"%w\".\"%w_rowid\"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);"
129941 "CREATE TABLE \"%w\".\"%w_parent\"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER);"