/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
H A D | ref_citus_local_fkeys.sql | 30 INSERT INTO reference_table VALUES (11); 32 DELETE FROM reference_table WHERE r1=11; 43 INSERT INTO reference_table VALUES (12); 45 UPDATE reference_table SET r1=13 WHERE r1=12; 56 INSERT INTO reference_table VALUES (2); 63 INSERT INTO reference_table VALUES (1); 72 DROP TABLE reference_table; 75 DROP TABLE reference_table CASCADE; 93 CREATE TABLE reference_table(r1 int); table 96 INSERT INTO reference_table VALUES (3); [all …]
|
H A D | citus_local_tables_queries.sql | 286 SELECT reference_table.* FROM reference_table 290 SELECT reference_table.* FROM reference_table 294 SELECT reference_table.* FROM reference_table, postgres_local_table 300 SELECT reference_table.* FROM reference_table 304 SELECT reference_table.* FROM reference_table, postgres_local_table 308 SELECT reference_table.* FROM reference_table 316 SELECT reference_table.* FROM reference_table 383 FROM reference_table 531 SELECT reference_table.* FROM reference_table; 535 SELECT reference_table.* FROM reference_table, postgres_local_table; [all …]
|
H A D | citus_local_tables_queries_mx.sql | 288 SELECT reference_table.* FROM reference_table 292 SELECT reference_table.* FROM reference_table 296 SELECT reference_table.* FROM reference_table, postgres_local_table 302 SELECT reference_table.* FROM reference_table 306 SELECT reference_table.* FROM reference_table, postgres_local_table 310 SELECT reference_table.* FROM reference_table 318 SELECT reference_table.* FROM reference_table 385 FROM reference_table 532 SELECT reference_table.* FROM reference_table; 536 SELECT reference_table.* FROM reference_table, postgres_local_table; [all …]
|
H A D | sqlancer_failures.sql | 76 LEFT JOIN reference_table b ON (true) 77 RIGHT JOIN reference_table c ON (true); 84 LEFT JOIN reference_table b ON (true) 138 LEFT JOIN reference_table b ON (true) 181 LEFT JOIN reference_table b ON (true) 184 (reference_table d JOIN reference_table e ON(true)) ON (true); 191 LEFT JOIN reference_table b ON (true) 194 (reference_table d JOIN reference_table e ON(true)) ON (true); 216 LEFT JOIN reference_table b ON (true) 219 (reference_table d JOIN reference_table e ON(true)) ON (true); [all …]
|
H A D | foreign_key_restriction_enforcement.sql | 41 SELECT count(*) FROM reference_table; 52 SELECT count(*) FROM reference_table; 69 SELECT count(*) FROM reference_table; 80 SELECT count(*) FROM reference_table; 97 SELECT count(*) FROM reference_table; 108 SELECT count(*) FROM reference_table; 120 SELECT count(*) FROM reference_table; 139 SELECT count(*) FROM reference_table; 473 TRUNCATE reference_table CASCADE; 484 TRUNCATE reference_table CASCADE; [all …]
|
H A D | multi_follower_dml.sql | 33 SELECT * FROM reference_table; 41 SELECT * FROM reference_table; 45 DELETE FROM reference_table WHERE a = 1; 49 SELECT * FROM reference_table; 81 SELECT * FROM reference_table ORDER BY a; 107 SELECT * FROM reference_table ORDER BY a; 110 DELETE FROM reference_table; 115 TRUNCATE reference_table; 133 SELECT * FROM reference_table ORDER BY a; 150 SELECT * FROM reference_table ORDER BY a; [all …]
|
H A D | auto_undist_citus_local.sql | 14 CREATE TABLE reference_table(r1 int primary key); table 35 DROP TABLE citus_local_table, reference_table; 44 ALTER TABLE reference_table DROP COLUMN r1 CASCADE; 46 DROP TABLE citus_local_table, reference_table; 58 DROP TABLE citus_local_table, reference_table; 70 DROP TABLE citus_local_table, reference_table; 72 CREATE TABLE reference_table(r1 int, r2 int); table 82 DROP TABLE citus_local_table, reference_table; 93 DROP TABLE citus_local_table, reference_table; 99 DROP TABLE reference_table CASCADE; [all …]
|
H A D | citus_table_triggers.sql | 28 CREATE TABLE reference_table (value int); table 37 AFTER INSERT ON reference_table 52 AFTER INSERT ON reference_table 74 ALTER TRIGGER update_value_ref ON reference_table DEPENDS ON EXTENSION seg; 75 DROP TRIGGER update_value_ref ON reference_table; 76 ALTER TABLE reference_table DISABLE TRIGGER ALL; 77 ALTER TABLE reference_table DISABLE TRIGGER USER; 78 ALTER TABLE reference_table DISABLE TRIGGER update_value_ref; 79 ALTER TABLE reference_table ENABLE TRIGGER ALL; 80 ALTER TABLE reference_table ENABLE TRIGGER USER; [all …]
|
H A D | mx_regular_user.sql | 200 CREATE TABLE reference_table(id int PRIMARY KEY, value_1 int); table 205 ALTER TABLE reference_table ADD CONSTRAINT fkey_to_local FOREIGN KEY(id) REFERENCES local_table_in_… 208 INSERT INTO reference_table SELECT i, i FROM generate_series(0, 100) i; 214 DELETE FROM reference_table WHERE id > 50; 226 TRUNCATE local_table_in_the_metadata, reference_table, on_delete_fkey_table; 228 SELECT count(*) FROM reference_table; 235 TRUNCATE reference_table CASCADE; 240 SELECT count(*) FROM local_table_in_the_metadata JOIN reference_table USING(id) JOIN on_delete_fkey… 311 SELECT count(*) FROM local_table_in_the_metadata JOIN reference_table USING(id) JOIN on_delete_fkey… 316 SELECT count(*) FROM local_table_in_the_metadata JOIN reference_table USING(id) JOIN on_delete_fkey… [all …]
|
H A D | multi_row_router_insert.sql | 18 CREATE TABLE reference_table(column1 INT DEFAULT 1111, column2 INT DEFAULT 2222); table 21 INSERT INTO reference_table VALUES (5), (6); 23 INSERT INTO reference_table VALUES (DEFAULT), (7); 24 INSERT INTO reference_table (column2) VALUES (8), (9); 26 PREPARE prepared_statement(int) AS INSERT INTO reference_table (column2) VALUES ($1), ($1 * 500); 34 SELECT * FROM reference_table ORDER BY 1,2;
|
H A D | failure_truncate.sql | 134 CREATE TABLE reference_table(i int UNIQUE); table 142 TRUNCATE reference_table CASCADE; 146 SELECT count(*) FROM reference_table; 151 TRUNCATE reference_table CASCADE; 155 SELECT count(*) FROM reference_table; 160 TRUNCATE reference_table CASCADE; 164 SELECT count(*) FROM reference_table; 169 TRUNCATE reference_table CASCADE; 173 SELECT count(*) FROM reference_table; 179 TRUNCATE reference_table CASCADE; [all …]
|
H A D | multi_insert_select.sql | 263 reference_table 352 reference_table 923 reference_table; 933 reference_table 961 reference_table 1171 reference_table 1285 reference_table 1318 reference_table 1349 reference_table 1378 reference_table [all …]
|
H A D | local_table_join.sql | 5 CREATE TABLE reference_table (key int, value text, value_2 jsonb); table 30 INSERT INTO reference_table SELECT i, i::varchar(256) FROM generate_series(1, 100) i; 60 SELECT count(*) FROM postgres_table JOIN reference_table USING(key); 65 SELECT count(*) FROM postgres_table JOIN reference_table USING(key); 71 SELECT count(*) FROM postgres_table JOIN reference_table USING(key); 81 SELECT count(*) FROM reference_table JOIN postgres_table USING(key); 86 SELECT count(*) FROM reference_table JOIN local_partitioned_table USING(key); 92 SELECT count(*) FROM reference_table JOIN mv1 USING(key); 96 SELECT count(*) FROM reference_table JOIN mv2 USING(key); 117 SELECT count(*) FROM reference_table JOIN mv1 USING(key); [all …]
|
H A D | local_shard_execution.sql | 8 CREATE TABLE reference_table (key int PRIMARY KEY); table 18 INSERT INTO reference_table VALUES (1); 256 COPY reference_table FROM STDIN; 347 INSERT INTO reference_table VALUES (701); 351 DELETE FROM reference_table WHERE key = 701; 517 INSERT INTO reference_table VALUES (2); 654 INSERT INTO reference_table VALUES (11); 727 TRUNCATE reference_table CASCADE; 743 DELETE FROM reference_table; 868 TRUNCATE reference_table CASCADE; [all …]
|
H A D | local_shard_copy.sql | 13 CREATE TABLE reference_table (key int PRIMARY KEY); table 20 INSERT INTO reference_table SELECT * FROM generate_series(1, 10); 312 TRUNCATE TABLE reference_table; 315 SELECT count(*) FROM reference_table, local_table WHERE reference_table.key = local_table.key; 321 COPY reference_table FROM STDIN; 333 COPY reference_table FROM STDIN; 348 SELECT COUNT(*) FROM reference_table;
|
H A D | with_dml.sql | 11 CREATE TABLE with_dml.reference_table (id text, name text); table 16 INSERT INTO reference_table SELECT i::text, 'user_' || i FROM generate_series (0, 100) i; 24 DELETE FROM reference_table WHERE id IN (SELECT tenant_id FROM ids_to_delete); 30 UPDATE reference_table SET name = 'new_' || name WHERE id IN (SELECT tenant_id FROM ids_to_update); 41 DELETE FROM reference_table WHERE id IN (SELECT * FROM ids_deleted_3 UNION SELECT * FROM ids_delete… 150 SELECT id FROM reference_table 152 DELETE FROM reference_table WHERE id = ANY(SELECT id FROM ids_to_delete);
|
H A D | citus_local_table_triggers.sql | 53 CREATE TABLE reference_table(value int); table 57 INSERT INTO reference_table VALUES (100); 70 SELECT * FROM reference_table; 261 CREATE TABLE reference_table(value int); table 266 INSERT INTO reference_table VALUES (100); 282 SELECT * FROM reference_table; 301 SELECT * FROM reference_table;
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/ |
H A D | auto_undist_citus_local.out | 34 reference_table | n | t 54 reference_table | n | t 62 reference_table | n | t 78 reference_table | n | t 86 reference_table | n | t 102 reference_table | n | t 110 reference_table | n | t 134 reference_table | n | t 159 reference_table | n | t 183 reference_table | n | t [all …]
|
H A D | citus_local_tables_queries_mx.out | 534 SELECT reference_table.* FROM reference_table 537 SELECT reference_table.* FROM reference_table 540 SELECT reference_table.* FROM reference_table, postgres_local_table 549 SELECT reference_table.* FROM reference_table 552 SELECT reference_table.* FROM reference_table, postgres_local_table 555 SELECT reference_table.* FROM reference_table 565 SELECT reference_table.* FROM reference_table 626 FROM reference_table 824 SELECT reference_table.* FROM reference_table; 838 SELECT reference_table.* FROM reference_table, postgres_local_table; [all …]
|
H A D | citus_local_tables_queries.out | 607 SELECT reference_table.* FROM reference_table 611 SELECT reference_table.* FROM reference_table 616 SELECT reference_table.* FROM reference_table, postgres_local_table 627 SELECT reference_table.* FROM reference_table 631 SELECT reference_table.* FROM reference_table, postgres_local_table 635 SELECT reference_table.* FROM reference_table 646 SELECT reference_table.* FROM reference_table 718 FROM reference_table 941 SELECT reference_table.* FROM reference_table; 955 SELECT reference_table.* FROM reference_table, postgres_local_table; [all …]
|
H A D | ref_citus_local_fkeys.out | 25 CREATE TABLE reference_table(r1 int primary key); 39 INSERT INTO reference_table VALUES (11); 43 DELETE FROM reference_table WHERE r1=11; 62 INSERT INTO reference_table VALUES (12); 87 INSERT INTO reference_table VALUES (2); 96 INSERT INTO reference_table VALUES (1); 110 DROP TABLE reference_table; 114 DROP TABLE reference_table CASCADE; 147 CREATE TABLE reference_table(r1 int); 154 INSERT INTO reference_table VALUES (3); [all …]
|
H A D | sqlancer_failures.out | 176 LEFT JOIN reference_table b ON (true) 177 RIGHT JOIN reference_table c ON (true); 186 LEFT JOIN reference_table b ON (true) 266 LEFT JOIN reference_table b ON (true) 312 LEFT JOIN reference_table b ON (true) 315 (reference_table d JOIN reference_table e ON(true)) ON (true); 323 LEFT JOIN reference_table b ON (true) 326 (reference_table d JOIN reference_table e ON(true)) ON (true); 350 LEFT JOIN reference_table b ON (true) 353 (reference_table d JOIN reference_table e ON(true)) ON (true); [all …]
|
H A D | multi_follower_dml.out | 56 SELECT * FROM reference_table; 79 SELECT * FROM reference_table; 90 DELETE FROM reference_table WHERE a = 1; 99 SELECT * FROM reference_table; 142 SELECT * FROM reference_table ORDER BY a; 181 SELECT * FROM reference_table ORDER BY a; 194 DELETE FROM reference_table; 201 TRUNCATE reference_table; 231 SELECT * FROM reference_table ORDER BY a; 265 SELECT * FROM reference_table ORDER BY a; [all …]
|
H A D | foreign_key_restriction_enforcement.out | 49 SELECT count(*) FROM reference_table; 78 SELECT count(*) FROM reference_table; 143 SELECT count(*) FROM reference_table; 162 SELECT count(*) FROM reference_table; 187 SELECT count(*) FROM reference_table; 210 SELECT count(*) FROM reference_table; 234 SELECT count(*) FROM reference_table; 264 SELECT count(*) FROM reference_table; 800 TRUNCATE reference_table CASCADE; 824 TRUNCATE reference_table CASCADE; [all …]
|
/dports/databases/py-south/South-1.0.2/south/tests/ |
H A D | db_mysql.py | 55 reference_table = 'test_cr_foreign' 57 self._create_foreign_tables(main_table, reference_table) 61 self.assertEquals((reference_table, 'id'), references) 63 db.delete_table(reference_table) 68 reference_table = 'test_rr_foreign' 70 self._create_foreign_tables(main_table, reference_table) 72 inverse = db._lookup_reverse_constraint(reference_table, 'id') 77 db.delete_table(reference_table)
|