/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
H A D | explain_for_connection_small_json_innodb.result | 40 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co… 51 … "attached_condition": "((`test`.`alias1`.`col_int` = 8) or (`test`.`alias1`.`pk` <= `te… 54 QUERY: SELECT alias1.pk AS field1 FROM h2 AS alias1 LEFT JOIN aa3 AS alias2 ON alias1.pk = alia… 65 - "attached_condition": "(`test`.`alias1`.`pk` <> 9)" 68 QUERY: SELECT alias1.pk AS field1 FROM e1 AS alias1 RIGHT JOIN cc2 AS alias2 ON alias1.col_in… 91 - "attached_condition": "(`test`.`alias2`.`col_int` = `test`.`alias1`.`col_int`)" 94 …S field3 FROM t1 AS alias1 RIGHT JOIN t2 AS alias2 ON alias1.col_varchar_key = alias2.col_varch…
|
H A D | bug29175494.result | 27 SELECT alias1.col_varchar_key, alias1.col_varchar_key 29 t1 AS alias1 32 WHERE alias1.col_varchar >= 'Z' ); 38 …s_not_null, <is_not_null_test>(alias1.col_varchar_key), true) and <if>(outer_field_is_not_null, <i… 42 … -> Remove duplicate (alias2, alias1) rows using temporary table (weedout) (cost=0.93 rows=0) 48 …alias1.col_varchar >= 'Z') and <if>(outer_field_is_not_null, ((<cache>(t1.col_varchar_key) = alias… 50 … -> Index lookup on alias1 using k2 (col_varchar_key=<cache>(t1.col_varchar_key) or NULL) 51 -> Table scan on alias1 55 SELECT alias1.col_varchar_key, alias1.col_varchar_key 57 t1 AS alias1 [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/r/ |
H A D | explain_for_connection_rqg_trad.result | 3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co… 5 … alias1.pk AS field1 FROM f1 AS alias1 LEFT JOIN a2 AS alias2 ON alias1.col_varchar_1024_latin… 7 QUERY: SELECT alias1.pk AS field1 FROM h2 AS alias1 LEFT JOIN aa3 AS alias2 ON alias1.pk = alia… 9 QUERY: SELECT alias1.pk AS field1 FROM e1 AS alias1 RIGHT JOIN cc2 AS alias2 ON alias1.col_in… 14 1 SIMPLE alias1 NULL ref col_int_key col_int_key 5 const 1 100.00 NULL 17 …S field3 FROM t1 AS alias1 RIGHT JOIN t2 AS alias2 ON alias1.col_varchar_key = alias2.col_varch… 44 …alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie… 55 …alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR… 64 …alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 … 86 …alias1 WHERE ( ( alias1.pk > 54 AND alias1.pk < ( 54 + 151 ) OR ( alias1.col_int_key IN (240) OR … [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/r/ |
H A D | explain_for_connection_rqg_trad.result | 3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co… 5 … alias1.pk AS field1 FROM f1 AS alias1 LEFT JOIN a2 AS alias2 ON alias1.col_varchar_1024_latin… 7 QUERY: SELECT alias1.pk AS field1 FROM h2 AS alias1 LEFT JOIN aa3 AS alias2 ON alias1.pk = alia… 9 QUERY: SELECT alias1.pk AS field1 FROM e1 AS alias1 RIGHT JOIN cc2 AS alias2 ON alias1.col_in… 14 1 SIMPLE alias1 NULL ref col_int_key col_int_key 5 const 1 100.00 NULL 17 …S field3 FROM t1 AS alias1 RIGHT JOIN t2 AS alias2 ON alias1.col_varchar_key = alias2.col_varch… 44 …alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie… 55 …alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR… 64 …alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 … 86 …alias1 WHERE ( ( alias1.pk > 54 AND alias1.pk < ( 54 + 151 ) OR ( alias1.col_int_key IN (240) OR … [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/r/ |
H A D | explain_for_connection_rqg_trad.result | 3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co… 5 … alias1.pk AS field1 FROM f1 AS alias1 LEFT JOIN a2 AS alias2 ON alias1.col_varchar_1024_latin… 7 QUERY: SELECT alias1.pk AS field1 FROM h2 AS alias1 LEFT JOIN aa3 AS alias2 ON alias1.pk = alia… 9 QUERY: SELECT alias1.pk AS field1 FROM e1 AS alias1 RIGHT JOIN cc2 AS alias2 ON alias1.col_in… 14 1 SIMPLE alias1 NULL ref col_int_key col_int_key 5 const 1 100.00 NULL 17 …S field3 FROM t1 AS alias1 RIGHT JOIN t2 AS alias2 ON alias1.col_varchar_key = alias2.col_varch… 44 …alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie… 55 …alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR… 64 …alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 … 86 …alias1 WHERE ( ( alias1.pk > 54 AND alias1.pk < ( 54 + 151 ) OR ( alias1.col_int_key IN (240) OR … [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/r/ |
H A D | explain_for_connection_rqg_trad.result | 3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co… 5 … alias1.pk AS field1 FROM f1 AS alias1 LEFT JOIN a2 AS alias2 ON alias1.col_varchar_1024_latin… 7 QUERY: SELECT alias1.pk AS field1 FROM h2 AS alias1 LEFT JOIN aa3 AS alias2 ON alias1.pk = alia… 9 QUERY: SELECT alias1.pk AS field1 FROM e1 AS alias1 RIGHT JOIN cc2 AS alias2 ON alias1.col_in… 14 1 SIMPLE alias1 NULL ref col_int_key col_int_key 5 const 1 100.00 NULL 17 …S field3 FROM t1 AS alias1 RIGHT JOIN t2 AS alias2 ON alias1.col_varchar_key = alias2.col_varch… 44 …alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie… 55 …alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR… 64 …alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 … 86 …alias1 WHERE ( ( alias1.pk > 54 AND alias1.pk < ( 54 + 151 ) OR ( alias1.col_int_key IN (240) OR … [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/r/ |
H A D | explain_for_connection_rqg_trad.result | 3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co… 5 … alias1.pk AS field1 FROM f1 AS alias1 LEFT JOIN a2 AS alias2 ON alias1.col_varchar_1024_latin… 7 QUERY: SELECT alias1.pk AS field1 FROM h2 AS alias1 LEFT JOIN aa3 AS alias2 ON alias1.pk = alia… 9 QUERY: SELECT alias1.pk AS field1 FROM e1 AS alias1 RIGHT JOIN cc2 AS alias2 ON alias1.col_in… 14 1 SIMPLE alias1 NULL ref col_int_key col_int_key 5 const 1 100.00 NULL 17 …S field3 FROM t1 AS alias1 RIGHT JOIN t2 AS alias2 ON alias1.col_varchar_key = alias2.col_varch… 44 …alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie… 55 …alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR… 64 …alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 … 86 …alias1 WHERE ( ( alias1.pk > 54 AND alias1.pk < ( 54 + 151 ) OR ( alias1.col_int_key IN (240) OR … [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/r/ |
H A D | explain_for_connection_rqg_trad.result | 3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co… 5 … alias1.pk AS field1 FROM f1 AS alias1 LEFT JOIN a2 AS alias2 ON alias1.col_varchar_1024_latin… 7 QUERY: SELECT alias1.pk AS field1 FROM h2 AS alias1 LEFT JOIN aa3 AS alias2 ON alias1.pk = alia… 9 QUERY: SELECT alias1.pk AS field1 FROM e1 AS alias1 RIGHT JOIN cc2 AS alias2 ON alias1.col_in… 14 1 SIMPLE alias1 NULL ref col_int_key col_int_key 5 const 1 100.00 NULL 17 …S field3 FROM t1 AS alias1 RIGHT JOIN t2 AS alias2 ON alias1.col_varchar_key = alias2.col_varch… 44 …alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie… 55 …alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR… 64 …alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 … 86 …alias1 WHERE ( ( alias1.pk > 54 AND alias1.pk < ( 54 + 151 ) OR ( alias1.col_int_key IN (240) OR … [all …]
|
/dports/finance/aqbanking/aqbanking-6.2.10/src/libs/aqbanking/backendsupport/ |
H A D | swiftdescr.c | 35 p_struct->alias1=NULL; in GWEN_LIST_FUNCTIONS() 96 if (p_struct->alias1) { in AB_SwiftDescr_dup() 98 p_struct->alias1=NULL; in AB_SwiftDescr_dup() 99 p_struct->alias1=NULL; in AB_SwiftDescr_dup() 101 if (p_src->alias1) { in AB_SwiftDescr_dup() 102 p_struct->alias1=strdup(p_src->alias1); in AB_SwiftDescr_dup() 142 if (p_struct->alias1) { in AB_SwiftDescr_copy() 147 if (p_src->alias1) { in AB_SwiftDescr_copy() 148 p_struct->alias1=strdup(p_src->alias1); in AB_SwiftDescr_copy() 236 if (p_struct->alias1) { in AB_SwiftDescr_SetAlias1() [all …]
|
/dports/www/elgg/elgg-3.3.23/vendor/elgg/elgg/engine/tests/phpunit/unit/Elgg/Database/ |
H A D | QueryBuilderTest.php | 86 $this->assertEquals($alias1, $alias2); 87 $this->assertEquals($alias1, $alias4); 88 $this->assertNotEquals($alias1, $alias3); 91 $expected->join('f', $this->qb->prefix('entities'), $alias1, "$alias1.guid = f.entity_guid") 139 $this->assertEquals($alias1, $alias2); 140 $this->assertEquals($alias1, $alias4); 200 $this->assertEquals($alias1, $alias2); 201 $this->assertEquals($alias1, $alias4); 261 $this->assertEquals($alias1, $alias2); 262 $this->assertEquals($alias1, $alias4); [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/tokudb.bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/tokudb.bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/tokudb.bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/storage/tokudb/mysql-test/tokudb_bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/storage/tokudb/mysql-test/tokudb_bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/tokudb/mysql-test/tokudb_bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/storage/tokudb/mysql-test/tokudb_bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/storage/tokudb/mysql-test/tokudb_bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/tokudb/mysql-test/tokudb_bugs/r/ |
H A D | subselect_index_next_same_bug_157.result | 26 alias1.col_varchar_key, alias2.col_varchar_key 28 (CC AS alias1 30 ON (alias2.pk = alias1.pk)) 39 alias1.col_varchar_key, alias2.col_varchar_key 41 (CC AS alias1 43 ON (alias2.pk = alias1.pk)) 53 alias1.col_varchar_key, alias2.col_varchar_key 55 (CC AS alias1 57 ON (alias2.pk = alias1.pk)) 68 (CC AS alias1 [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/t/ |
H A D | subselect_index_next_same_bug_157.test | 42 alias1.col_varchar_key, alias2.col_varchar_key 44 (CC AS alias1 46 ON (alias2.pk = alias1.pk)) 54 alias1.col_varchar_key, alias2.col_varchar_key 56 (CC AS alias1 58 ON (alias2.pk = alias1.pk)) 68 alias1.col_varchar_key, alias2.col_varchar_key 70 (CC AS alias1 72 ON (alias2.pk = alias1.pk)) 82 (CC AS alias1 [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/t/ |
H A D | subselect_index_next_same_bug_157.test | 42 alias1.col_varchar_key, alias2.col_varchar_key 44 (CC AS alias1 46 ON (alias2.pk = alias1.pk)) 54 alias1.col_varchar_key, alias2.col_varchar_key 56 (CC AS alias1 58 ON (alias2.pk = alias1.pk)) 68 alias1.col_varchar_key, alias2.col_varchar_key 70 (CC AS alias1 72 ON (alias2.pk = alias1.pk)) 82 (CC AS alias1 [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/tokudb.bugs/t/ |
H A D | subselect_index_next_same_bug_157.test | 42 alias1.col_varchar_key, alias2.col_varchar_key 44 (CC AS alias1 46 ON (alias2.pk = alias1.pk)) 54 alias1.col_varchar_key, alias2.col_varchar_key 56 (CC AS alias1 58 ON (alias2.pk = alias1.pk)) 68 alias1.col_varchar_key, alias2.col_varchar_key 70 (CC AS alias1 72 ON (alias2.pk = alias1.pk)) 82 (CC AS alias1 [all …]
|