/dports/databases/p5-DBIx-Class/DBIx-Class-0.082842/t/ |
H A D | 51threads.t | 54 … UNIQUE, title VARCHAR(100) NOT NULL UNIQUE, year VARCHAR(100) NOT NULL, genreid INTEGER, single_t…
|
H A D | 76select.t | 105 …'(SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track, artist.name FROM cd m…
|
/dports/databases/p5-DBIx-Class/DBIx-Class-0.082842/t/debug/ |
H A D | core.t | 111 …my $sql_trace = 'SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd…
|
/dports/audio/py-mutagen/mutagen-1.42.0/mutagen/id3/ |
H A D | _frames.py | 585 genreid, dummy, genrename = genre_re.match(value).groups() 587 if genreid: 588 for gid in genreid[1:-1].split(")("):
|
/dports/databases/p5-DBIx-Class/DBIx-Class-0.082842/t/prefetch/ |
H A D | incomplete.t | 17 …# SELECT me.name, cds.title, cds.cdid, cds.artist, cds.title, cds.year, cds.genreid, cds.single_…
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/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/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/r/ |
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 …]
|
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 …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/r/ |
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 …]
|
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 …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/r/ |
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_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 …]
|
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_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 …]
|