| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/r/ |
| H A D | join_cache_bnl.result | 1268 genreid int NOT NULL default '0',
1272 CREATE INDEX t10_genreid ON t10(genreid);
1276 genreid int NOT NULL default '0',
1280 PRIMARY KEY (genreid)
1288 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1299 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1315 1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 NULL
1318 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1329 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1334 uniquekey affiliateXml artistName artistid genreName genreid genrePriority subgenreid subgenreName …
|
| H A D | join_cache_nojb.result | 1268 genreid int NOT NULL default '0',
1272 CREATE INDEX t10_genreid ON t10(genreid);
1276 genreid int NOT NULL default '0',
1280 PRIMARY KEY (genreid)
1288 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1299 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1314 1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 NULL
1318 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1329 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1334 uniquekey affiliateXml artistName artistid genreName genreid genrePriority subgenreid subgenreName …
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/include/ |
| H A D | join_cache.inc | 386 genreid int NOT NULL default '0',
390 CREATE INDEX t10_genreid ON t10(genreid);
395 genreid int NOT NULL default '0',
399 PRIMARY KEY (genreid)
408 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
419 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
427 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
438 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/r/ |
| H A D | join_cache_bka.result | 1291 genreid int NOT NULL default '0',
1295 CREATE INDEX t10_genreid ON t10(genreid);
1299 genreid int NOT NULL default '0',
1303 PRIMARY KEY (genreid)
1311 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1322 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1337 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 Using join buffer (Batched Key…
1340 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1343 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1354 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_bka_nixbnl.result | 1291 genreid int NOT NULL default '0',
1295 CREATE INDEX t10_genreid ON t10(genreid);
1299 genreid int NOT NULL default '0',
1303 PRIMARY KEY (genreid)
1311 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1322 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1337 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 Using join buffer (Batched Key…
1340 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1343 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1354 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_bkaunique.result | 1292 genreid int NOT NULL default '0',
1296 CREATE INDEX t10_genreid ON t10(genreid);
1300 genreid int NOT NULL default '0',
1304 PRIMARY KEY (genreid)
1312 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1323 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1338 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 Using join buffer (Batched Key…
1341 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1344 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1355 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_bnl.result | 1292 genreid int NOT NULL default '0',
1296 CREATE INDEX t10_genreid ON t10(genreid);
1300 genreid int NOT NULL default '0',
1304 PRIMARY KEY (genreid)
1312 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1323 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1338 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 NULL
1341 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1344 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1355 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_nojb.result | 1292 genreid int NOT NULL default '0',
1296 CREATE INDEX t10_genreid ON t10(genreid);
1300 genreid int NOT NULL default '0',
1304 PRIMARY KEY (genreid)
1312 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1323 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1338 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 NULL
1341 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1344 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1355 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/include/ |
| H A D | join_cache.inc | 376 genreid int NOT NULL default '0',
380 CREATE INDEX t10_genreid ON t10(genreid);
385 genreid int NOT NULL default '0',
389 PRIMARY KEY (genreid)
398 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
409 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
417 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
428 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/r/ |
| H A D | join_cache_bka.result | 1267 genreid int NOT NULL default '0',
1271 CREATE INDEX t10_genreid ON t10(genreid);
1275 genreid int NOT NULL default '0',
1279 PRIMARY KEY (genreid)
1287 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1298 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1314 1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 Using join buffer (Batched Key Access)
1317 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1328 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1333 uniquekey affiliateXml artistName artistid genreName genreid genrePriority subgenreid subgenreName …
|
| H A D | join_cache_bka_nixbnl.result | 1267 genreid int NOT NULL default '0',
1271 CREATE INDEX t10_genreid ON t10(genreid);
1275 genreid int NOT NULL default '0',
1279 PRIMARY KEY (genreid)
1287 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1298 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1313 1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 Using join buffer (Batched Key Access)
1317 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1328 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1333 uniquekey affiliateXml artistName artistid genreName genreid genrePriority subgenreid subgenreName …
|
| H A D | join_cache_bkaunique.result | 1268 genreid int NOT NULL default '0',
1272 CREATE INDEX t10_genreid ON t10(genreid);
1276 genreid int NOT NULL default '0',
1280 PRIMARY KEY (genreid)
1288 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1299 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1315 1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 Using join buffer (Batched Key Access (uni…
1318 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1329 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1334 uniquekey affiliateXml artistName artistid genreName genreid genrePriority subgenreid subgenreName …
|
| H A D | join_cache_bnl.result | 1268 genreid int NOT NULL default '0',
1272 CREATE INDEX t10_genreid ON t10(genreid);
1276 genreid int NOT NULL default '0',
1280 PRIMARY KEY (genreid)
1288 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1299 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1315 1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 NULL
1318 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1329 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1334 uniquekey affiliateXml artistName artistid genreName genreid genrePriority subgenreid subgenreName …
|
| H A D | join_cache_nojb.result | 1268 genreid int NOT NULL default '0',
1272 CREATE INDEX t10_genreid ON t10(genreid);
1276 genreid int NOT NULL default '0',
1280 PRIMARY KEY (genreid)
1288 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1299 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1314 1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 NULL
1318 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1329 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1334 uniquekey affiliateXml artistName artistid genreName genreid genrePriority subgenreid subgenreName …
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/include/ |
| H A D | join_cache.inc | 386 genreid int NOT NULL default '0',
390 CREATE INDEX t10_genreid ON t10(genreid);
395 genreid int NOT NULL default '0',
399 PRIMARY KEY (genreid)
408 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
419 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
427 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
438 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/r/ |
| H A D | join_cache_bka.result | 1291 genreid int NOT NULL default '0',
1295 CREATE INDEX t10_genreid ON t10(genreid);
1299 genreid int NOT NULL default '0',
1303 PRIMARY KEY (genreid)
1311 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1322 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1337 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 Using join buffer (Batched Key…
1340 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1343 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1354 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_bka_nixbnl.result | 1291 genreid int NOT NULL default '0',
1295 CREATE INDEX t10_genreid ON t10(genreid);
1299 genreid int NOT NULL default '0',
1303 PRIMARY KEY (genreid)
1311 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1322 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1337 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 Using join buffer (Batched Key…
1340 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1343 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1354 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_bkaunique.result | 1292 genreid int NOT NULL default '0',
1296 CREATE INDEX t10_genreid ON t10(genreid);
1300 genreid int NOT NULL default '0',
1304 PRIMARY KEY (genreid)
1312 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1323 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1338 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 Using join buffer (Batched Key…
1341 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1344 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1355 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_bnl.result | 1292 genreid int NOT NULL default '0',
1296 CREATE INDEX t10_genreid ON t10(genreid);
1300 genreid int NOT NULL default '0',
1304 PRIMARY KEY (genreid)
1312 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1323 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1338 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 NULL
1341 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1344 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1355 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| H A D | join_cache_nojb.result | 1292 genreid int NOT NULL default '0',
1296 CREATE INDEX t10_genreid ON t10(genreid);
1300 genreid int NOT NULL default '0',
1304 PRIMARY KEY (genreid)
1312 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1323 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1338 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 NULL
1341 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1344 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1355 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| /dports/databases/p5-DBD-SQLite/DBD-SQLite-1.70/t/ |
| H A D | rt_124227_index_regression.t | 16 me.genreid IS NOT NULL
18 rownum__emulation.genreid IS NULL
22 me.genreid IS NOT NULL
24 rownum__emulation.genreid IS NOT NULL
26 rownum__emulation.genreid < me.genreid
30 …( me.genreid = rownum__emulation.genreid OR ( me.genreid IS NULL AND rownum__emulation.genreid IS …
41 'CREATE TABLE cd ( cdid INTEGER PRIMARY KEY NOT NULL, genreid integer )',
42 'CREATE INDEX cd_idx_genreid ON cd (genreid)',
43 'INSERT INTO cd ( cdid, genreid ) VALUES
60 'CREATE TABLE cd ( cdid INTEGER PRIMARY KEY NOT NULL, genreid integer )',
[all …]
|
| /dports/databases/p5-DBIx-Class-ResultSet-RecursiveUpdate/DBIx-Class-ResultSet-RecursiveUpdate-0.42/t/lib/DBICTest/Schema/ |
| H A D | Genre.pm | 9 genreid => {
|
| /dports/databases/p5-DBIx-Class-ResultSet-RecursiveUpdate/DBIx-Class-ResultSet-RecursiveUpdate-0.42/t/lib/ |
| H A D | sqlite.sql | 75 genreid integer, field
80 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
195 genreid INTEGER PRIMARY KEY NOT NULL, field
|
| /dports/databases/p5-DBIx-Class-ResultSet-RecursiveUpdate/DBIx-Class-ResultSet-RecursiveUpdate-0.42/t_dbic/lib/DBICTest/Schema/ |
| H A D | Genre.pm | 9 genreid => {
|
| /dports/databases/p5-DBIx-Class-ResultSet-RecursiveUpdate/DBIx-Class-ResultSet-RecursiveUpdate-0.42/t_dbic/lib/ |
| H A D | sqlite.sql | 79 genreid INTEGER PRIMARY KEY NOT NULL, field
313 genreid integer, field
319 CREATE INDEX cd_idx_genreid ON cd (genreid);
466 SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000";
|