/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/t/ |
H A D | ta_column_to_null.test | 15 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 23 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 31 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 39 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 47 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 55 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 63 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 71 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 79 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 87 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/engines/funcs/t/ |
H A D | ta_column_to_null.test | 15 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 23 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 31 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 39 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 47 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 55 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 63 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 71 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 79 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; 87 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES; [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1511 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1544 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1546 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1554 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1623 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1625 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1680 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1691 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1709 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1494 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1526 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1528 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1535 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1586 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1641 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1649 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1667 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1494 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1526 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1528 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1535 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1586 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1641 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1649 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1667 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1496 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1528 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1530 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1537 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1590 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1643 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1654 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1672 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1494 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1526 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1528 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1535 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1586 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1641 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1649 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1667 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1496 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1528 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1530 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1537 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1590 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1643 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1654 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1672 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1496 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1528 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1530 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1537 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1590 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1643 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1654 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1672 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1496 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1528 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1530 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1537 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1590 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1643 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1654 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1672 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1496 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1528 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1530 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1537 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1590 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1643 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1654 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1672 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1494 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1526 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1528 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1535 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1586 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1641 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1649 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1667 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1493 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1525 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1527 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1534 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1595 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1597 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1650 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1658 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1676 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1493 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1525 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1527 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1534 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1595 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1597 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1650 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1658 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1676 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1493 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1525 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1527 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1534 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1595 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1597 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1650 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1658 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1676 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1493 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1525 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1527 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1534 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1595 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1597 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1650 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1658 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1676 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1493 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1525 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1527 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1534 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1595 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1597 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1650 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1658 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1676 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1496 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1528 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1530 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1537 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1590 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1643 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1654 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1672 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mysql55-client/mysql-5.5.62/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1493 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1525 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1527 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1534 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1585 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1587 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1640 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1648 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1666 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1494 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1526 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1528 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1535 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1586 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1588 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1641 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1649 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1667 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/include/ |
H A D | common-tests.inc | 1277 select t2.fld3 from t2 where fld3 LIKE 'h%le'; 1493 select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t… 1525 select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t… 1527 select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group b… 1534 select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >… 1595 select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and pe… 1597 select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t… 1650 select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1658 select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1676 …ct t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.co… [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | ta_string_to_null.result | 5 t2 8 t2 CREATE TABLE `t2` ( 17 t2 CREATE TABLE `t2` ( 29 t2 CREATE TABLE `t2` ( 38 t2 CREATE TABLE `t2` ( 50 t2 CREATE TABLE `t2` ( 59 t2 CREATE TABLE `t2` ( 71 t2 CREATE TABLE `t2` ( 80 t2 CREATE TABLE `t2` ( 92 t2 CREATE TABLE `t2` ( [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | ta_string_to_null.result | 5 t2 8 t2 CREATE TABLE `t2` ( 17 t2 CREATE TABLE `t2` ( 29 t2 CREATE TABLE `t2` ( 38 t2 CREATE TABLE `t2` ( 50 t2 CREATE TABLE `t2` ( 59 t2 CREATE TABLE `t2` ( 71 t2 CREATE TABLE `t2` ( 80 t2 CREATE TABLE `t2` ( 92 t2 CREATE TABLE `t2` ( [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | ta_string_to_null.result | 5 t2 8 t2 CREATE TABLE `t2` ( 17 t2 CREATE TABLE `t2` ( 29 t2 CREATE TABLE `t2` ( 38 t2 CREATE TABLE `t2` ( 50 t2 CREATE TABLE `t2` ( 59 t2 CREATE TABLE `t2` ( 71 t2 CREATE TABLE `t2` ( 80 t2 CREATE TABLE `t2` ( 92 t2 CREATE TABLE `t2` ( [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/engines/funcs/r/ |
H A D | ta_string_to_null.result | 5 t2 8 t2 CREATE TABLE `t2` ( 17 t2 CREATE TABLE `t2` ( 29 t2 CREATE TABLE `t2` ( 38 t2 CREATE TABLE `t2` ( 50 t2 CREATE TABLE `t2` ( 59 t2 CREATE TABLE `t2` ( 71 t2 CREATE TABLE `t2` ( 80 t2 CREATE TABLE `t2` ( 92 t2 CREATE TABLE `t2` ( [all …]
|