Home
last modified time | relevance | path

Searched refs:col_1 (Results 1 – 25 of 571) sorted by relevance

12345678910>>...23

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dundistribute_table_cascade.sql18 …CREATE TABLE local_table (col_1 INT REFERENCES reference_table(col_1), FOREIGN KEY (col_1) REFEREN… field
30 CREATE TABLE reference_table_1 (col_1 INT UNIQUE, col_2 INT UNIQUE, UNIQUE (col_2, col_1)); field
55 …distributed_table_3 ADD CONSTRAINT fkey_1 FOREIGN KEY (col_1) REFERENCES distributed_table_2(col_1…
56 …distributed_table_2 ADD CONSTRAINT fkey_2 FOREIGN KEY (col_1) REFERENCES distributed_table_3(col_1…
57 …distributed_table_2 ADD CONSTRAINT fkey_3 FOREIGN KEY (col_1) REFERENCES distributed_table_1(col_1…
58 … distributed_table_1 ADD CONSTRAINT fkey_4 FOREIGN KEY (col_1) REFERENCES reference_table_1(col_1);
61 …E reference_table_2 ADD CONSTRAINT fkey_7 FOREIGN KEY (col_1) REFERENCES citus_local_table_2(col_1…
62 …distributed_table_1 ADD CONSTRAINT fkey_8 FOREIGN KEY (col_1) REFERENCES distributed_table_3(col_1…
63 …istributed_table_2 ADD CONSTRAINT fkey_11 FOREIGN KEY (col_1) REFERENCES distributed_table_2(col_1…
163 CREATE TABLE partitioned_table_1 (col_1 INT UNIQUE, col_2 INT) PARTITION BY RANGE (col_1); field
[all …]
H A Dfkeys_between_local_ref.sql204 col_1 INT UNIQUE REFERENCES local_table_1(col_1), field
206 FOREIGN KEY (col_1) REFERENCES reference_table_1(col_1),
228 col_1 INT UNIQUE REFERENCES distributed_table(col_1), field
229 FOREIGN KEY (col_1) REFERENCES reference_table_1(col_1));
235 col_1 INT UNIQUE REFERENCES reference_table_1(col_1), field
236 FOREIGN KEY (col_1) REFERENCES local_table_1(col_1));
260 FOREIGN KEY (col_1) REFERENCES local_table_5(col_1));
288 col_1 INT UNIQUE REFERENCES local_table_1(col_1), field
332 col_1 INT UNIQUE REFERENCES local_table_6(col_1), field
334 FOREIGN KEY (col_1) REFERENCES local_table_5(col_1),
[all …]
H A Dcreate_ref_dist_from_citus_local.sql18 …citus_local_table_2 ADD CONSTRAINT fkey_1 FOREIGN KEY (col_1) REFERENCES citus_local_table_1(col_1…
19 …citus_local_table_3 ADD CONSTRAINT fkey_2 FOREIGN KEY (col_1) REFERENCES citus_local_table_1(col_1…
20 …citus_local_table_1 ADD CONSTRAINT fkey_3 FOREIGN KEY (col_1) REFERENCES citus_local_table_3(col_1…
21 …citus_local_table_1 ADD CONSTRAINT fkey_4 FOREIGN KEY (col_1) REFERENCES citus_local_table_4(col_1…
22 …citus_local_table_4 ADD CONSTRAINT fkey_5 FOREIGN KEY (col_1) REFERENCES citus_local_table_3(col_1…
23 …citus_local_table_4 ADD CONSTRAINT fkey_6 FOREIGN KEY (col_1) REFERENCES citus_local_table_4(col_1…
33 … citus_local_table_4 ADD CONSTRAINT fkey_7 FOREIGN KEY (col_1) REFERENCES reference_table_1(col_1);
34 …E reference_table_2 ADD CONSTRAINT fkey_8 FOREIGN KEY (col_1) REFERENCES citus_local_table_2(col_1…
37 CREATE TABLE partitioned_dist_table_1 (col_1 INT UNIQUE, col_2 INT) PARTITION BY RANGE (col_1); field
42 …tioned_dist_table_1 ADD CONSTRAINT fkey_9 FOREIGN KEY (col_1) REFERENCES distributed_table_1(col_1…
[all …]
H A Dmulti_insert_select_conflict.sql59 col_1, col_2
74 col_1, col_2
89 col_1, col_2
154 col_1, col_2
163 WHERE cte.col_1 = source_table_1.col_1 ON CONFLICT DO NOTHING;
179 col_1
190 col_1
203 col_1
213 col_1
235 col_1, col_2
[all …]
H A Dcreate_citus_local_table_cascade.sql14 CREATE TABLE local_table_1 (col_1 INT UNIQUE); field
15 CREATE TABLE local_table_2 (col_1 INT UNIQUE); field
16 CREATE TABLE local_table_3 (col_1 INT UNIQUE); field
26 ALTER TABLE local_table_2 ADD CONSTRAINT fkey_1 FOREIGN KEY (col_1) REFERENCES local_table_1(col_1);
27 ALTER TABLE local_table_3 ADD CONSTRAINT fkey_2 FOREIGN KEY (col_1) REFERENCES local_table_1(col_1);
28 ALTER TABLE local_table_1 ADD CONSTRAINT fkey_3 FOREIGN KEY (col_1) REFERENCES local_table_3(col_1);
29 ALTER TABLE local_table_1 ADD CONSTRAINT fkey_4 FOREIGN KEY (col_1) REFERENCES local_table_4(col_1);
30 ALTER TABLE local_table_4 ADD CONSTRAINT fkey_5 FOREIGN KEY (col_1) REFERENCES local_table_3(col_1);
31 ALTER TABLE local_table_4 ADD CONSTRAINT fkey_6 FOREIGN KEY (col_1) REFERENCES local_table_4(col_1);
78 …CREATE TABLE partitioned_table (col_1 INT REFERENCES local_table_1 (col_1)) PARTITION BY RANGE (co… field
[all …]
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/innodb_zip/r/
H A Dinnodb_wl6347_comp_indx_stat.result23 CREATE INDEX idx1 ON tab5(col_1(10));
45 SET @col_1 = repeat('a', 100);
401 SET @col_1 = repeat('a', 100);
757 SET @col_1 = repeat('a', 100);
1079 SET @col_1 = repeat('a', 100);
1401 SET @col_1 = repeat('a', 100);
1728 SET @col_1 = repeat('a', 100);
2086 SET @col_1 = repeat('a', 100);
2444 SET @col_1 = repeat('a', 100);
2768 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/innodb_zip/r/
H A Dinnodb_wl6347_comp_indx_stat.result23 CREATE INDEX idx1 ON tab5(col_1(10));
45 SET @col_1 = repeat('a', 100);
401 SET @col_1 = repeat('a', 100);
757 SET @col_1 = repeat('a', 100);
1079 SET @col_1 = repeat('a', 100);
1401 SET @col_1 = repeat('a', 100);
1728 SET @col_1 = repeat('a', 100);
2086 SET @col_1 = repeat('a', 100);
2444 SET @col_1 = repeat('a', 100);
2768 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/innodb_zip/r/
H A Dinnodb_wl6347_comp_indx_stat.result23 CREATE INDEX idx1 ON tab5(col_1(10));
45 SET @col_1 = repeat('a', 100);
401 SET @col_1 = repeat('a', 100);
757 SET @col_1 = repeat('a', 100);
1079 SET @col_1 = repeat('a', 100);
1401 SET @col_1 = repeat('a', 100);
1728 SET @col_1 = repeat('a', 100);
2086 SET @col_1 = repeat('a', 100);
2444 SET @col_1 = repeat('a', 100);
2768 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/innodb_zip/r/
H A Dinnodb_wl6347_comp_indx_stat.result23 CREATE INDEX idx1 ON tab5(col_1(10));
45 SET @col_1 = repeat('a', 100);
401 SET @col_1 = repeat('a', 100);
757 SET @col_1 = repeat('a', 100);
1079 SET @col_1 = repeat('a', 100);
1401 SET @col_1 = repeat('a', 100);
1728 SET @col_1 = repeat('a', 100);
2086 SET @col_1 = repeat('a', 100);
2444 SET @col_1 = repeat('a', 100);
2768 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/innodb_zip/r/
H A Dinnodb_wl6347_comp_indx_stat.result23 CREATE INDEX idx1 ON tab5(col_1(10));
45 SET @col_1 = repeat('a', 100);
401 SET @col_1 = repeat('a', 100);
757 SET @col_1 = repeat('a', 100);
1079 SET @col_1 = repeat('a', 100);
1401 SET @col_1 = repeat('a', 100);
1728 SET @col_1 = repeat('a', 100);
2086 SET @col_1 = repeat('a', 100);
2444 SET @col_1 = repeat('a', 100);
2768 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/
H A Dmulti_insert_select_conflict.out74 col_1 | col_2
86 col_1, col_2
105 col_1, col_2
122 col_1 | col_2
135 col_1, col_2
161 col_1 | col_2
313 col_1
326 col_1
348 col_1
361 col_1
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/innodb_zip/r/
H A Dindex_level_comp_stat.result23 KEY idx1(col_1(10)),
369 KEY idx1(col_1(10)),
715 KEY idx1(col_1(10)),
1028 KEY idx1(col_1(10)),
1341 KEY idx1(col_1(10)),
1665 KEY idx1(col_1(10)),
2013 KEY idx1(col_1(10)),
2361 KEY idx1(col_1(10)),
2676 KEY idx1(col_1(10)),
2991 KEY idx1(col_1(10)),
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
H A Dwl6344_compress_level.result5 CREATE TABLE tab5 (col_1 CHAR (255) ,
20 SET @col_1 = repeat('a', 100);
32 INSERT INTO tab5(col_1,col_2,col_3,col_4,col_5,col_6,col_7,col_8,col_9,col_10)
33 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,@col_7,@col_8,@col_9,@col_10);
34 INSERT INTO tab5(col_1,col_2,col_3,col_4,col_5,col_6,col_7,col_8,col_9,col_10)
35 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,@col_7,@col_8,@col_9,@col_10);
36 INSERT INTO tab5(col_1,col_2,col_3,col_4,col_5,col_6,col_7,col_8,col_9,col_10)
38 INSERT INTO tab5(col_1,col_2,col_3,col_4,col_5,col_6,col_7,col_8,col_9,col_10)
40 INSERT INTO tab5(col_1,col_2,col_3,col_4,col_5,col_6,col_7,col_8,col_9,col_10)
42 INSERT INTO tab5(col_1,col_2,col_3,col_4,col_5,col_6,col_7,col_8,col_9,col_10)
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
396 SET @col_1 = repeat('a', 100);
742 SET @col_1 = repeat('a', 100);
1055 SET @col_1 = repeat('a', 100);
1368 SET @col_1 = repeat('a', 100);
1693 SET @col_1 = repeat('a', 100);
2041 SET @col_1 = repeat('a', 100);
2389 SET @col_1 = repeat('a', 100);
2704 SET @col_1 = repeat('a', 100);
3019 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
395 SET @col_1 = repeat('a', 100);
740 SET @col_1 = repeat('a', 100);
1053 SET @col_1 = repeat('a', 100);
1366 SET @col_1 = repeat('a', 100);
1691 SET @col_1 = repeat('a', 100);
2038 SET @col_1 = repeat('a', 100);
2385 SET @col_1 = repeat('a', 100);
2700 SET @col_1 = repeat('a', 100);
3015 SET @col_1 = repeat('a', 100);
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/innodb_zip/r/
H A Dwl6347_comp_indx_stat.result50 SET @col_1 = repeat('a', 100);
395 SET @col_1 = repeat('a', 100);
740 SET @col_1 = repeat('a', 100);
1053 SET @col_1 = repeat('a', 100);
1366 SET @col_1 = repeat('a', 100);
1691 SET @col_1 = repeat('a', 100);
2038 SET @col_1 = repeat('a', 100);
2385 SET @col_1 = repeat('a', 100);
2700 SET @col_1 = repeat('a', 100);
3015 SET @col_1 = repeat('a', 100);
[all …]

12345678910>>...23