/dports/databases/akonadi/akonadi-21.12.3/src/server/storage/ |
H A D | dbintrospector_impl.cpp | 113 #define TABLE_CONSTRAINTS "information_schema.table_constraints" in foreignKeyConstraints() macro 119 …keyColumnUsageCondition.addColumnCondition(QStringLiteral(TABLE_CONSTRAINTS ".constraint_catalog"), in foreignKeyConstraints() 122 … keyColumnUsageCondition.addColumnCondition(QStringLiteral(TABLE_CONSTRAINTS ".constraint_schema"), in foreignKeyConstraints() 125 keyColumnUsageCondition.addColumnCondition(QStringLiteral(TABLE_CONSTRAINTS ".constraint_name"), in foreignKeyConstraints() 130 …referentialConstraintsCondition.addColumnCondition(QStringLiteral(TABLE_CONSTRAINTS ".constraint_c… in foreignKeyConstraints() 133 …referentialConstraintsCondition.addColumnCondition(QStringLiteral(TABLE_CONSTRAINTS ".constraint_s… in foreignKeyConstraints() 136 …referentialConstraintsCondition.addColumnCondition(QStringLiteral(TABLE_CONSTRAINTS ".constraint_n… in foreignKeyConstraints() 151 QueryBuilder qb(QStringLiteral(TABLE_CONSTRAINTS), QueryBuilder::Select); in foreignKeyConstraints() 152 qb.addColumn(QStringLiteral(TABLE_CONSTRAINTS ".constraint_name")); in foreignKeyConstraints() 162 …qb.addValueCondition(QStringLiteral(TABLE_CONSTRAINTS ".table_name"), Query::Equals, tableName.toL… in foreignKeyConstraints() [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 37 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; 39 TABLE_CONSTRAINTS CREATE TEMPORARY TABLE `TABLE_CONSTRAINTS` ( [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/funcs_1/r/ |
H A D | is_table_constraints_ci.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 11 CREATE PROCEDURE test.p1() SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 38 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; [all …]
|
H A D | is_table_constraints.result | 1 SHOW TABLES FROM information_schema LIKE 'TABLE_CONSTRAINTS'; 2 Tables_in_information_schema (TABLE_CONSTRAINTS) 3 TABLE_CONSTRAINTS 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.TABLE_CONSTRAINTS; 11 CREATE PROCEDURE test.p1() SELECT * FROM information_schema.TABLE_CONSTRAINTS; 15 SELECT COUNT(*) INTO counter FROM information_schema.TABLE_CONSTRAINTS; 19 SELECT * FROM information_schema.TABLE_CONSTRAINTS; 27 # Testcase 3.2.10.1: INFORMATION_SCHEMA.TABLE_CONSTRAINTS layout 29 DESCRIBE information_schema.TABLE_CONSTRAINTS; 38 SHOW CREATE TABLE information_schema.TABLE_CONSTRAINTS; [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
H A D | information_schema_all_engines.result | 64 TABLE_CONSTRAINTS 146 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 228 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 313 TABLE_CONSTRAINTS information_schema.TABLE_CONSTRAINTS 1 385 | TABLE_CONSTRAINTS | 457 | TABLE_CONSTRAINTS |
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
H A D | information_schema_all_engines.result | 65 TABLE_CONSTRAINTS 148 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 231 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 317 TABLE_CONSTRAINTS information_schema.TABLE_CONSTRAINTS 1 390 | TABLE_CONSTRAINTS | 463 | TABLE_CONSTRAINTS |
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
H A D | information_schema_all_engines.result | 64 TABLE_CONSTRAINTS 146 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 228 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 313 TABLE_CONSTRAINTS information_schema.TABLE_CONSTRAINTS 1 385 | TABLE_CONSTRAINTS | 457 | TABLE_CONSTRAINTS |
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/ |
H A D | information_schema_all_engines.result | 64 TABLE_CONSTRAINTS 146 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 228 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 313 TABLE_CONSTRAINTS information_schema.TABLE_CONSTRAINTS 1 385 | TABLE_CONSTRAINTS | 457 | TABLE_CONSTRAINTS |
|