| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
| H A D | join_cache_bka.result | 1311 genreid int NOT NULL default '0',
1315 CREATE INDEX t10_genreid ON t10(genreid);
1319 genreid int NOT NULL default '0',
1323 PRIMARY KEY (genreid)
1331 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1342 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1357 1 SIMPLE t11 NULL eq_ref PRIMARY PRIMARY 4 test.t10.genreid 1 100.00 Using join buffer (Batched Key…
1360 …genreid` AS `genreid`,`test`.`t11`.`priority` AS `genrePriority`,`test`.`t10`.`subgenreid` AS `sub…
1363 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1374 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/r/ |
| 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_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 …
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/r/ |
| 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_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_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 …
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/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_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_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 …
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/r/ |
| 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_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 …
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/r/ |
| 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_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_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 …
|
| /dports/databases/p5-DBIx-Class/DBIx-Class-0.082842/t/ |
| H A D | 74mssql.t | 74 …DENTITY PRIMARY KEY, artist INT, title VARCHAR(100), year VARCHAR(100), genreid INT NULL, single_…
|
| H A D | 73oracle.t | 440 genreid => undef,
601 …{q} NUMBER(12), ${q}title${q} VARCHAR(255), ${q}year${q} VARCHAR(4), ${q}genreid${q} NUMBER(12), $…
|
| H A D | 73oracle_hq.t | 314 …cdid NUMBER(12), artist NUMBER(12), title VARCHAR(255), year VARCHAR(4), genreid NUMBER(12), singl…
|
| H A D | 751msaccess.t | 105 genreid INTEGER NULL,
|
| /dports/audio/xmcd/xmcd-3.3.2/cdda_d/ |
| H A D | wr_gen.c | 605 gen_genre_cddb2id3(char *genreid) in gen_genre_cddb2id3() argument
611 if ((gp = cdinfo_genre(genreid)) == NULL) in gen_genre_cddb2id3()
|
| /dports/audio/gtkpod/gtkpod-1.0.0/src/ |
| H A D | mp3file.c | 1473 int num, genreid; in handle_genre_variations() local
1474 num = sscanf (genre, "(%d)", &genreid); in handle_genre_variations()
1486 id3_ucs4_t const *ucs4_genre = id3_genre_index (genreid); in handle_genre_variations()
|
| /dports/multimedia/kodi/xbmc-19.3-Matrix/xbmc/interfaces/json-rpc/ |
| H A D | AudioLibrary.cpp | 1308 for (const auto& genreid : genreids) in GetAdditionalSongDetails() local
1309 genreidObj.push_back(genreid); in GetAdditionalSongDetails()
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
| H A D | join_cache.test | 1186 genreid int NOT NULL default '0',
1190 CREATE INDEX t10_genreid ON t10(genreid);
1195 genreid int NOT NULL default '0',
1199 PRIMARY KEY (genreid)
1210 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1221 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1229 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1240 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
| H A D | join_cache.test | 1186 genreid int NOT NULL default '0',
1190 CREATE INDEX t10_genreid ON t10(genreid);
1195 genreid int NOT NULL default '0',
1199 PRIMARY KEY (genreid)
1210 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1221 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
1229 t11.name AS genreName, t11.genreid, t11.priority AS genrePriority,
1240 t10.genreid = t11.genreid AND t3.metaid = t2.metaid AND
|