Home
last modified time | relevance | path

Searched refs:ROWID (Results 1 – 25 of 1263) sorted by relevance

12345678910>>...51

/dports/databases/sqlite3/sqlite-src-3350500/test/
H A Dwithout_rowid5.test12 # Requirements testing for WITHOUT ROWID tables.
29 CREATE TABLE t1w(a PRIMARY KEY,b,c) WITHOUT ROWID;
47 # KEY, cnt INTEGER ) WITHOUT ROWID;
53 ) WITHOUT ROWID;
112 # statement with the WITHOUT ROWID clause lacks a PRIMARY KEY.
124 ) WITHOUT ROWID;
128 # PRIMARY KEY" do not apply on WITHOUT ROWID tables.
144 # ROWID tables.
152 } {1 {AUTOINCREMENT not allowed on WITHOUT ROWID tables}}
155 # PRIMARY KEY in a WITHOUT ROWID table.
[all …]
H A Dwithout_rowid1.test13 # focus of this file is testing WITHOUT ROWID tables.
24 # Create and query a WITHOUT ROWID table.
27 CREATE TABLE t1(a,b,c,d, PRIMARY KEY(c,a)) WITHOUT ROWID;
161 ) WITHOUT ROWID;
225 # Name resolution issue with WITHOUT ROWID
228 CREATE TABLE t41(a PRIMARY KEY) WITHOUT ROWID;
323 ) WITHOUT ROWID;
333 # rowid table, but not in a WITHOUT ROWID table.
349 ) WITHOUT ROWID;
444 ) WITHOUT ROWID;
[all …]
H A Dcsv01.test139 'CREATE TABLE t3(a PRIMARY KEY,b TEXT,c TEXT,d TEXT) WITHOUT ROWID',
148 # The rowid column is not visible on a WITHOUT ROWID virtual table
153 # Multi-column WITHOUT ROWID virtual tables may not be writable.
164 'CREATE TABLE t3(a,b,c,d,PRIMARY KEY(a,b)) WITHOUT ROWID',
167 } {1 {bad schema: 'CREATE TABLE t3(a,b,c,d,PRIMARY KEY(a,b)) WITHOUT ROWID' - not an error}}
169 # WITHOUT ROWID tables with a single-column PRIMARY KEY may be writable.
180 'CREATE TABLE t3(a,b,c,d,PRIMARY KEY(b)) WITHOUT ROWID',
195 'CREATE TABLE t3(a,b,c,d) WITHOUT ROWID',
198 } {1 {bad schema: 'CREATE TABLE t3(a,b,c,d) WITHOUT ROWID' - PRIMARY KEY missing on table t3}}
H A Dunique2.test33 # WITHOUT ROWID support in version 3.8.2, specifically in check-in
43 1 {CREATE TABLE t1(x TEXT PRIMARY KEY, y NOT NULL) WITHOUT ROWID}
45 3 {CREATE TABLE t1(x TEXT PRIMARY KEY, y) WITHOUT ROWID}
59 5 {CREATE TABLE t1(w,x,y NOT NULL,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
61 7 {CREATE TABLE t1(w,x,y NOT NULL,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
63 9 {CREATE TABLE t1(w,x,y,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
65 11 {CREATE TABLE t1(w,x,y,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
H A Dwithout_rowid6.test12 # Verify that WITHOUT ROWID tables work correctly when the PRIMARY KEY
24 CREATE TABLE t1(a,b,c,d,e, PRIMARY KEY(a,b,c,a,b,c,d,a,b,c)) WITHOUT ROWID;
57 ) WITHOUT ROWID;
79 ) WITHOUT ROWID;
97 ) WITHOUT ROWID;
114 ) WITHOUT ROWID;
130 CREATE TABLE t6(a,b,c,PRIMARY KEY(a,rowid,b))WITHOUT ROWID;
H A Dschema6.test121 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE) WITHOUT ROWID;
124 CREATE TABLE t1(xyz INTEGER, abc, PRIMARY KEY(xyz), UNIQUE(abc))WITHOUT ROWID;
127 CREATE TABLE t1(xyz INTEGER, abc, UNIQUE(abc), PRIMARY KEY(xyz))WITHOUT ROWID;
130 CREATE TABLE t1(a INTEGER PRIMARY KEY ASC, b UNIQUE) WITHOUT ROWID;
133 CREATE TABLE t1(a INTEGER PRIMARY KEY UNIQUE, b UNIQUE) WITHOUT ROWID;
136 CREATE TABLE t1(a INTEGER UNIQUE PRIMARY KEY, b UNIQUE) WITHOUT ROWID;
140 WITHOUT ROWID;
143 CREATE TABLE t1(a INTEGER PRIMARY KEY, b) WITHOUT ROWID;
147 CREATE TABLE t1(a INTEGER PRIMARY KEY, b) WITHOUT ROWID;
159 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE) WITHOUT ROWID;
/dports/databases/sqlcipher/sqlcipher-3.4.2/test/
H A Dwithout_rowid5.test12 # Requirements testing for WITHOUT ROWID tables.
29 CREATE TABLE t1w(a PRIMARY KEY,b,c) WITHOUT ROWID;
47 # KEY, cnt INTEGER ) WITHOUT ROWID;
53 ) WITHOUT ROWID;
112 # statement with the WITHOUT ROWID clause lacks a PRIMARY KEY.
124 ) WITHOUT ROWID;
128 # PRIMARY KEY" do not apply on WITHOUT ROWID tables.
144 # ROWID tables.
152 } {1 {AUTOINCREMENT not allowed on WITHOUT ROWID tables}}
155 # PRIMARY KEY in a WITHOUT ROWID table.
[all …]
H A Dwithout_rowid1.test13 # focus of this file is testing WITHOUT ROWID tables.
20 # Create and query a WITHOUT ROWID table.
23 CREATE TABLE t1(a,b,c,d, PRIMARY KEY(c,a)) WITHOUT ROWID;
145 ) WITHOUT ROWID;
163 CREATE TABLE t1(a, b, PRIMARY KEY(a)) WITHOUT ROWID;
166 CREATE TABLE t2(a, b, PRIMARY KEY(a)) WITHOUT ROWID;
204 # Name resolution issue with WITHOUT ROWID
207 CREATE TABLE t41(a PRIMARY KEY) WITHOUT ROWID;
302 ) WITHOUT ROWID;
312 # rowid table, but not in a WITHOUT ROWID table.
[all …]
H A Dunique2.test33 # WITHOUT ROWID support in version 3.8.2, specifically in check-in
43 1 {CREATE TABLE t1(x TEXT PRIMARY KEY, y NOT NULL) WITHOUT ROWID}
45 3 {CREATE TABLE t1(x TEXT PRIMARY KEY, y) WITHOUT ROWID}
59 5 {CREATE TABLE t1(w,x,y NOT NULL,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
61 7 {CREATE TABLE t1(w,x,y NOT NULL,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
63 9 {CREATE TABLE t1(w,x,y,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
65 11 {CREATE TABLE t1(w,x,y,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
H A Dwithout_rowid6.test12 # Verify that WITHOUT ROWID tables work correctly when the PRIMARY KEY
20 CREATE TABLE t1(a,b,c,d,e, PRIMARY KEY(a,b,c,a,b,c,d,a,b,c)) WITHOUT ROWID;
50 ) WITHOUT ROWID;
69 ) WITHOUT ROWID;
87 ) WITHOUT ROWID;
104 ) WITHOUT ROWID;
117 CREATE TABLE t6(a,b,c,PRIMARY KEY(a,rowid,b))WITHOUT ROWID;
/dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/sqlite/src/test/
H A Dwithout_rowid5.test12 # Requirements testing for WITHOUT ROWID tables.
29 CREATE TABLE t1w(a PRIMARY KEY,b,c) WITHOUT ROWID;
47 # KEY, cnt INTEGER ) WITHOUT ROWID;
53 ) WITHOUT ROWID;
112 # statement with the WITHOUT ROWID clause lacks a PRIMARY KEY.
124 ) WITHOUT ROWID;
128 # PRIMARY KEY" do not apply on WITHOUT ROWID tables.
144 # ROWID tables.
152 } {1 {AUTOINCREMENT not allowed on WITHOUT ROWID tables}}
155 # PRIMARY KEY in a WITHOUT ROWID table.
[all …]
H A Dwithout_rowid1.test13 # focus of this file is testing WITHOUT ROWID tables.
24 # Create and query a WITHOUT ROWID table.
27 CREATE TABLE t1(a,b,c,d, PRIMARY KEY(c,a)) WITHOUT ROWID;
161 ) WITHOUT ROWID;
225 # Name resolution issue with WITHOUT ROWID
228 CREATE TABLE t41(a PRIMARY KEY) WITHOUT ROWID;
323 ) WITHOUT ROWID;
333 # rowid table, but not in a WITHOUT ROWID table.
349 ) WITHOUT ROWID;
444 ) WITHOUT ROWID;
[all …]
H A Dcsv01.test139 'CREATE TABLE t3(a PRIMARY KEY,b TEXT,c TEXT,d TEXT) WITHOUT ROWID',
148 # The rowid column is not visible on a WITHOUT ROWID virtual table
153 # Multi-column WITHOUT ROWID virtual tables may not be writable.
164 'CREATE TABLE t3(a,b,c,d,PRIMARY KEY(a,b)) WITHOUT ROWID',
167 } {1 {bad schema: 'CREATE TABLE t3(a,b,c,d,PRIMARY KEY(a,b)) WITHOUT ROWID' - not an error}}
169 # WITHOUT ROWID tables with a single-column PRIMARY KEY may be writable.
180 'CREATE TABLE t3(a,b,c,d,PRIMARY KEY(b)) WITHOUT ROWID',
195 'CREATE TABLE t3(a,b,c,d) WITHOUT ROWID',
198 } {1 {bad schema: 'CREATE TABLE t3(a,b,c,d) WITHOUT ROWID' - PRIMARY KEY missing on table t3}}
H A Dunique2.test33 # WITHOUT ROWID support in version 3.8.2, specifically in check-in
43 1 {CREATE TABLE t1(x TEXT PRIMARY KEY, y NOT NULL) WITHOUT ROWID}
45 3 {CREATE TABLE t1(x TEXT PRIMARY KEY, y) WITHOUT ROWID}
59 5 {CREATE TABLE t1(w,x,y NOT NULL,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
61 7 {CREATE TABLE t1(w,x,y NOT NULL,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
63 9 {CREATE TABLE t1(w,x,y,z NOT NULL,PRIMARY KEY(w,x)) WITHOUT ROWID}
65 11 {CREATE TABLE t1(w,x,y,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
H A Dwithout_rowid6.test12 # Verify that WITHOUT ROWID tables work correctly when the PRIMARY KEY
24 CREATE TABLE t1(a,b,c,d,e, PRIMARY KEY(a,b,c,a,b,c,d,a,b,c)) WITHOUT ROWID;
57 ) WITHOUT ROWID;
79 ) WITHOUT ROWID;
97 ) WITHOUT ROWID;
114 ) WITHOUT ROWID;
130 CREATE TABLE t6(a,b,c,PRIMARY KEY(a,rowid,b))WITHOUT ROWID;
H A Dschema6.test121 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE) WITHOUT ROWID;
124 CREATE TABLE t1(xyz INTEGER, abc, PRIMARY KEY(xyz), UNIQUE(abc))WITHOUT ROWID;
127 CREATE TABLE t1(xyz INTEGER, abc, UNIQUE(abc), PRIMARY KEY(xyz))WITHOUT ROWID;
130 CREATE TABLE t1(a INTEGER PRIMARY KEY ASC, b UNIQUE) WITHOUT ROWID;
133 CREATE TABLE t1(a INTEGER PRIMARY KEY UNIQUE, b UNIQUE) WITHOUT ROWID;
136 CREATE TABLE t1(a INTEGER UNIQUE PRIMARY KEY, b UNIQUE) WITHOUT ROWID;
140 WITHOUT ROWID;
143 CREATE TABLE t1(a INTEGER PRIMARY KEY, b) WITHOUT ROWID;
147 CREATE TABLE t1(a INTEGER PRIMARY KEY, b) WITHOUT ROWID;
159 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE) WITHOUT ROWID;
/dports/audio/strawberry/strawberry-1.0.0/data/schema/
H A Dschema-11.sql149 INSERT INTO songs (ROWID, title, album, artist, albumartist, track, disc, year, originalyear, genre…
150 SELECT ROWID, title, album, artist, albumartist, track, disc, year, originalyear, genre, compilatio…
157 INSERT INTO songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsperfor…
158 SELECT ROWID, title, album, artist, albumartist, composer, performer, grouping, genre, comment
161 INSERT INTO subsonic_songs (ROWID, title, album, artist, albumartist, track, disc, year, originalye…
162 SELECT ROWID, title, album, artist, albumartist, track, disc, year, originalyear, genre, compilatio…
169 INSERT INTO subsonic_songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, …
170 SELECT ROWID, title, album, artist, albumartist, composer, performer, grouping, genre, comment
236 SELECT ROWID, playlist, type, collection_id, playlist_url, title, album, artist, albumartist, track…
243 INSERT INTO playlist_items_fts_ (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer,…
[all …]
H A Dschema-9.sql35 INSERT INTO %allsongstables_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer,…
36 SELECT ROWID, title, album, artist, albumartist, composer, performer, grouping, genre, comment FROM…
38 INSERT INTO playlist_items_fts_ (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer,…
39 SELECT ROWID, title, album, artist, albumartist, composer, performer, grouping, genre, comment FROM…
/dports/audio/clementine-player/Clementine-1.4.0rc1/data/schema/
H A Dschema-13.sql11 INSERT INTO songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsgenre,…
12 SELECT ROWID, title, album, artist, albumartist, composer, genre, comment
15 INSERT INTO magnatune_songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer,…
16 SELECT ROWID, title, album, artist, albumartist, composer, genre, comment
/dports/security/vaultwarden/vaultwarden-1.23.1/cargo-crates/diesel-1.4.8/src/sqlite/connection/
H A Ddiesel_manage_updated_at.sql10 WHERE ROWID = new.ROWID;
/dports/audio/gnome-podcasts/podcasts-c86f7bfdef7692bbf20f315a90450321f6ca9ce7/cargo-crates/diesel-1.4.8/src/sqlite/connection/
H A Ddiesel_manage_updated_at.sql10 WHERE ROWID = new.ROWID;
/dports/databases/sqlite3/sqlite-src-3350500/ext/rbu/
H A Drbu1.test153 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
156 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
164 CREATE TABLE t1(a, b, c, PRIMARY KEY(c)) WITHOUT ROWID;
354 CREATE TABLE t1(a INT PRIMARY KEY, b, c) WITHOUT ROWID;
425 CREATE TABLE t1(c, b, '(a)' PRIMARY KEY) WITHOUT ROWID;
481 CREATE TABLE t1(a PRIMARY KEY, b, c, d) WITHOUT ROWID;
567 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
572 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
578 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
584 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
[all …]
/dports/databases/sqlcipher/sqlcipher-3.4.2/ext/rbu/
H A Drbu1.test152 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
155 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
163 CREATE TABLE t1(a, b, c, PRIMARY KEY(c)) WITHOUT ROWID;
353 CREATE TABLE t1(a INT PRIMARY KEY, b, c) WITHOUT ROWID;
424 CREATE TABLE t1(c, b, '(a)' PRIMARY KEY) WITHOUT ROWID;
480 CREATE TABLE t1(a PRIMARY KEY, b, c, d) WITHOUT ROWID;
566 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
571 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
577 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
583 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
[all …]
/dports/www/qt5-webengine/qtwebengine-everywhere-src-5.15.2/src/3rdparty/chromium/third_party/sqlite/src/ext/rbu/
H A Drbu1.test153 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
156 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
164 CREATE TABLE t1(a, b, c, PRIMARY KEY(c)) WITHOUT ROWID;
354 CREATE TABLE t1(a INT PRIMARY KEY, b, c) WITHOUT ROWID;
425 CREATE TABLE t1(c, b, '(a)' PRIMARY KEY) WITHOUT ROWID;
481 CREATE TABLE t1(a PRIMARY KEY, b, c, d) WITHOUT ROWID;
567 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
572 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
578 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
584 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
[all …]
/dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/sqlite/src/ext/rbu/
H A Drbu1.test153 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
156 CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID;
164 CREATE TABLE t1(a, b, c, PRIMARY KEY(c)) WITHOUT ROWID;
354 CREATE TABLE t1(a INT PRIMARY KEY, b, c) WITHOUT ROWID;
425 CREATE TABLE t1(c, b, '(a)' PRIMARY KEY) WITHOUT ROWID;
481 CREATE TABLE t1(a PRIMARY KEY, b, c, d) WITHOUT ROWID;
567 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
572 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
578 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
584 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT ROWID;
[all …]

12345678910>>...51