Home
last modified time | relevance | path

Searched refs:alias1 (Results 1 – 25 of 2173) sorted by relevance

12345678910>>...87

/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/
H A Dexplain_for_connection_small_json_innodb.result40 …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 Dbug29175494.result27 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)
48alias1.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 Dexplain_for_connection_rqg_trad.result3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co…
5alias1.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…
44alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie…
55alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR…
64alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 …
86alias1 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 Dexplain_for_connection_rqg_trad.result3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co…
5alias1.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…
44alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie…
55alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR…
64alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 …
86alias1 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 Dexplain_for_connection_rqg_trad.result3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co…
5alias1.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…
44alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie…
55alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR…
64alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 …
86alias1 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 Dexplain_for_connection_rqg_trad.result3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co…
5alias1.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…
44alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie…
55alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR…
64alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 …
86alias1 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 Dexplain_for_connection_rqg_trad.result3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co…
5alias1.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…
44alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie…
55alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR…
64alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 …
86alias1 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 Dexplain_for_connection_rqg_trad.result3 …AS field2 FROM a1 AS alias1 LEFT JOIN aa1 AS alias2 ON alias1.pk = alias2.pk WHERE ( alias1.co…
5alias1.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…
44alias1.col_int_key AS field1 , alias2.col_datetime_key AS field2 , alias1.col_varchar_nokey AS fie…
55alias1.col_int_key AS field1 , alias1.col_date_key AS field2 , alias1.col_varchar_key AS field3 FR…
64alias1.col_datetime_key AS field1 , alias2.col_int_key AS field2 FROM ( c AS alias1 , d AS alias2 …
86alias1 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 Dswiftdescr.c35 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 DQueryBuilderTest.php86 $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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.result26 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 Dsubselect_index_next_same_bug_157.test42 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 Dsubselect_index_next_same_bug_157.test42 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 Dsubselect_index_next_same_bug_157.test42 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 …]

12345678910>>...87