Home
last modified time | relevance | path

Searched refs:reference_table (Results 1 – 25 of 920) sorted by relevance

12345678910>>...37

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dref_citus_local_fkeys.sql30 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 Dcitus_local_tables_queries.sql286 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 Dcitus_local_tables_queries_mx.sql288 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 Dsqlancer_failures.sql76 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 Dforeign_key_restriction_enforcement.sql41 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 Dmulti_follower_dml.sql33 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 Dauto_undist_citus_local.sql14 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 Dcitus_table_triggers.sql28 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 Dmx_regular_user.sql200 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 Dmulti_row_router_insert.sql18 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 Dfailure_truncate.sql134 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 Dmulti_insert_select.sql263 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 Dlocal_table_join.sql5 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 Dlocal_shard_execution.sql8 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 Dlocal_shard_copy.sql13 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 Dwith_dml.sql11 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 Dcitus_local_table_triggers.sql53 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 Dauto_undist_citus_local.out34 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 Dcitus_local_tables_queries_mx.out534 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 Dcitus_local_tables_queries.out607 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 Dref_citus_local_fkeys.out25 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 Dsqlancer_failures.out176 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 Dmulti_follower_dml.out56 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 Dforeign_key_restriction_enforcement.out49 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 Ddb_mysql.py55 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)

12345678910>>...37