regress/expected/citus_local_tables_queries_mx.out

38 CREATE TABLE reference_table(a int, b int);
39 SELECT create_reference_table('reference_table');
65 …TRUNCATE postgres_local_table, citus_local_table, reference_table, distributed_table, dummy_refere…
72 		INSERT INTO reference_table SELECT i, i FROM generate_series(0, 5) i;
87 SELECT count(*) FROM citus_local_table, reference_table WHERE citus_local_table.a = reference_table…
93 SELECT * FROM citus_local_table, reference_table WHERE citus_local_table.a = reference_table.a ORDE…
106 …(SELECT * FROM citus_local_table, reference_table WHERE citus_local_table.a = reference_table.a OR…
393 SELECT count(*) FROM reference_table WHERE a IN (SELECT a FROM citus_local_table);
399 SELECT count(*) FROM citus_local_table  WHERE a IN (SELECT a FROM reference_table);
416 SELECT count(*) FROM citus_local_table LEFT JOIN reference_table ON (true);
422 SELECT count(*) FROM reference_table
425   LEFT JOIN reference_table r2 ON (true);
509 SELECT * from reference_table;
510 INSERT INTO reference_table
534 SELECT reference_table.* FROM reference_table
536 INSERT INTO reference_table
537 SELECT reference_table.* FROM reference_table
539 INSERT INTO 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
568 SELECT reference_table.*
569 FROM reference_table, distributed_table;
614 UPDATE reference_table
617 WHERE citus_local_table.a = reference_table.a;
626 FROM reference_table
627 WHERE citus_local_table.a = reference_table.a;
636 DELETE FROM reference_table
638 WHERE citus_local_table.a = reference_table.a;
641 USING reference_table
642 WHERE citus_local_table.a = reference_table.a;
648 WHERE citus_local_table.a IN (SELECT a FROM reference_table);
656 WITH reference_table_cte AS (SELECT * FROM reference_table)
667 JOIN reference_table
699 JOIN reference_table
725 FROM reference_table
731                   FROM reference_table as table_4677) subquery5108
824 SELECT reference_table.* FROM reference_table;
833                ->  Seq Scan on reference_table_1510003 reference_table
838 SELECT reference_table.* FROM reference_table, postgres_local_table;
849                      ->  Seq Scan on reference_table_1510003 reference_table
857 SELECT reference_table.* FROM reference_table, distributed_table;
870                            ->  Seq Scan on reference_table_1510003 reference_table
874 TRUNCATE reference_table, citus_local_table, distributed_table;
878 ALTER TABLE reference_table ADD CONSTRAINT pkey_ref PRIMARY KEY (a);
882 …uted_table ADD CONSTRAINT fkey_dist_to_ref FOREIGN KEY(a) REFERENCES reference_table(a) ON DELETE …
883 ALTER TABLE reference_table ADD CONSTRAINT fkey_ref_to_local FOREIGN KEY(a) REFERENCES citus_local_…
887 INSERT INTO reference_table VALUES (1);
904 NOTICE:  truncate cascades to table "reference_table"
914 NOTICE:  truncate cascades to table "reference_table"
938 ALTER TABLE reference_table DROP CONSTRAINT fkey_ref_to_local;
972 TRUNCATE citus_local_table, reference_table, distributed_table;
1003 	INSERT INTO reference_table VALUES (3), (2);
1012 	SELECT * FROM reference_table ORDER BY 1,2;