Home
last modified time | relevance | path

Searched refs:ref_table (Results 1 – 25 of 550) sorted by relevance

12345678910>>...22

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Drecursive_view_local_table.sql19 CREATE TABLE ref_table(a int, b INT); table
21 INSERT INTO ref_table VALUES (1,1);
42 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM local_table l WHERE l.a = ref_table.a…
43 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM local_table l WHERE l.a = ref_table.a…
44 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM local_table l WHERE l.a = ref_table.a…
46 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_view l WHERE l.val_1 = ref_…
47 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_view l WHERE l.val_1 = ref_…
48 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_view l WHERE l.val_1 = ref_…
50 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_defined_non_recursive_view …
51 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_defined_non_recursive_view …
[all …]
H A Dlocal_shard_utility_command_execution.sql38 INSERT INTO ref_table VALUES(1);
44 TRUNCATE ref_table CASCADE;
50 INSERT INTO ref_table VALUES(1);
64 INSERT INTO ref_table VALUES(2);
112 TRUNCATE ref_table CASCADE;
117 TRUNCATE ref_table CASCADE;
118 ANALYZE ref_table;
136 DROP TABLE ref_table;
154 DROP TABLE ref_table;
247 ALTER TABLE ref_table ADD CONSTRAINT fkey2 FOREIGN KEY(b) REFERENCES ref_table(a);
[all …]
H A Dmulti_mx_modifications_to_reference_tables.sql33 SELECT SUM(value_1) FROM ref_table;
36 SELECT SUM(value_1) FROM ref_table;
38 DELETE FROM ref_table;
39 SELECT SUM(value_1) FROM ref_table;
45 SELECT SUM(value_1) FROM ref_table;
49 SELECT * FROM ref_table FOR UPDATE;
54 SELECT SUM(value_1) FROM ref_table;
63 SELECT SUM(value_1) FROM ref_table;
70 SELECT SUM(value_1) FROM ref_table;
73 SELECT SUM(value_1) FROM ref_table;
[all …]
H A Dfailure_ref_tables.sql5 CREATE TABLE ref_table (key int, value int); table
8 \copy ref_table FROM stdin delimiter ',';
17 SELECT COUNT(*) FROM ref_table;
21 INSERT INTO ref_table VALUES (5, 6);
23 SELECT COUNT(*) FROM ref_table WHERE key=5;
27 UPDATE ref_table SET key=7 RETURNING value;
29 SELECT COUNT(*) FROM ref_table WHERE key=7;
35 DELETE FROM ref_table WHERE key=5;
36 UPDATE ref_table SET key=value;
39 SELECT COUNT(*) FROM ref_table WHERE key=value;
[all …]
H A Dmulti_select_for_update.sql20 CREATE TABLE ref_table(id int, val_1 int); table
22 INSERT INTO ref_table values(1,2),(3,4),(5,6);
77 test_table_1_rf1 as tt1 INNER JOIN ref_table as rt1 on tt1.id = rt1.id
84 test_table_1_rf1 as tt1 INNER JOIN ref_table as rt1 on tt1.id = rt1.id
91 ref_table as rt1 INNER JOIN ref_table_2 as rt2 on rt1.id = rt2.id
98 ref_table as rt1 INNER JOIN ref_table_2 as rt2 on rt1.id = rt2.id
121 DROP TABLE ref_table;
H A Dmulti_replicate_reference_table.sql500 CREATE TABLE ref_table(a int); table
515 DELETE FROM ref_table;
520 ALTER TABLE ref_table ADD COLUMN b int;
525 CREATE INDEX ref_idx ON ref_table(a);
534 SELECT count(*) FROM ref_table;
536 INSERT INTO ref_table VALUES (11);
538 UPDATE ref_table SET a = a + 1;
539 SELECT sum(a) FROM ref_table;
625 TRUNCATE ref_table;
633 FROM ref_table, dist_table
[all …]
H A Dfailure_create_reference_table.sql17 CREATE TABLE ref_table(id int); table
18 INSERT INTO ref_table VALUES(1),(2),(3);
82 DROP TABLE ref_table;
85 CREATE TABLE ref_table(id int); table
86 INSERT INTO ref_table VALUES(1),(2),(3);
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/
H A Drecursive_view_local_table.out15 CREATE TABLE ref_table(a int, b INT);
22 INSERT INTO ref_table VALUES (1,1);
151 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM local_table l WHERE l.a = ref_table.a…
154 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM local_table l WHERE l.a = ref_table.a…
159 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM local_table l WHERE l.a = ref_table.a…
164 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_view l WHERE l.val_1 = ref_…
170 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_view l WHERE l.val_1 = ref_…
175 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_view l WHERE l.val_1 = ref_…
180 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_defined_non_recursive_view …
186 SELECT ref_table.* FROM ref_table WHERE EXISTS (SELECT * FROM recursive_defined_non_recursive_view …
[all …]
H A Dmulti_mx_modifications_to_reference_tables.out47 SELECT SUM(value_1) FROM ref_table;
54 SELECT SUM(value_1) FROM ref_table;
60 DELETE FROM ref_table;
61 SELECT SUM(value_1) FROM ref_table;
68 SELECT SUM(value_1) FROM ref_table;
76 SELECT * FROM ref_table FOR UPDATE;
86 SELECT SUM(value_1) FROM ref_table;
102 SELECT SUM(value_1) FROM ref_table;
118 SELECT SUM(value_1) FROM ref_table;
125 SELECT SUM(value_1) FROM ref_table;
[all …]
H A Dfailure_ref_tables.out8 CREATE TABLE ref_table (key int, value int);
9 SELECT create_reference_table('ref_table');
15 \copy ref_table FROM stdin delimiter ',';
22 SELECT COUNT(*) FROM ref_table;
35 INSERT INTO ref_table VALUES (5, 6);
39 SELECT COUNT(*) FROM ref_table WHERE key=5;
52 UPDATE ref_table SET key=7 RETURNING value;
56 SELECT COUNT(*) FROM ref_table WHERE key=7;
70 DELETE FROM ref_table WHERE key=5;
71 UPDATE ref_table SET key=value;
[all …]
H A Dfailure_create_reference_table.out17 CREATE TABLE ref_table(id int);
18 INSERT INTO ref_table VALUES(1),(2),(3);
27 SELECT create_reference_table('ref_table');
44 SELECT create_reference_table('ref_table');
61 SELECT create_reference_table('ref_table');
76 SELECT create_reference_table('ref_table');
93 SELECT create_reference_table('ref_table');
194 DROP TABLE ref_table;
197 CREATE TABLE ref_table(id int);
198 INSERT INTO ref_table VALUES(1),(2),(3);
[all …]
H A Disolation_ref_update_delete_upsert_vs_all_on_mx.out10 ALTER TABLE ref_table ADD CONSTRAINT pri_key PRIMARY KEY (id);
53 …SELECT run_commands_on_session_level_connection_to_node('SELECT * FROM ref_table WHERE id=1 OR id=…
93 SELECT COUNT(*) FROM ref_table;
153 … run_commands_on_session_level_connection_to_node('INSERT INTO ref_table SELECT * FROM ref_table');
194 SELECT COUNT(*) FROM ref_table;
214 ALTER TABLE ref_table ADD CONSTRAINT pri_key PRIMARY KEY (id);
257 DROP TABLE ref_table;
293 SELECT COUNT(*) FROM ref_table;
295 ERROR: relation "ref_table" does not exist
349 SELECT run_commands_on_session_level_connection_to_node('TRUNCATE ref_table');
[all …]
H A Disolation_get_distributed_wait_queries_mx.out8 UPDATE ref_table SET value_1 = 15;
34 UPDATE ref_table SET value_1 = 12 WHERE user_id = 1|
35 UPDATE ref_table SET value_1 = 15;
119 UPDATE ref_table SET value_1 = 12 WHERE user_id = 1|UPDATE ref_table SET value_1 = 12 WHERE user_id…
311 UPDATE ref_table SET value_1 = 12 WHERE user_id = 1|DELETE FROM ref_table WHERE user_id = 1|localho…
407 UPDATE ref_table SET value_1 = 12 WHERE user_id = 1|INSERT INTO ref_table VALUES(8,81),(9,91)|local…
597 UPDATE ref_table SET value_1 = 12 WHERE user_id = 1|COPY ref_table FROM PROGRAM 'echo 10, 101 && ec…
850 SELECT run_commands_on_session_level_connection_to_node('SELECT * FROM ref_table FOR UPDATE');
881 UPDATE ref_table SET value_1 = 12 WHERE user_id = 1|SELECT * FROM ref_table FOR UPDATE |localhost…
957 ALTER TABLE ref_table ADD CONSTRAINT rf_p_key PRIMARY KEY(user_id);
[all …]
H A Dlocal_shard_utility_command_execution.out48 INSERT INTO ref_table VALUES(1);
54 TRUNCATE ref_table CASCADE;
87 INSERT INTO ref_table VALUES(1);
230 TRUNCATE ref_table CASCADE;
236 TRUNCATE ref_table CASCADE;
261 ANALYZE ref_table;
304 DROP TABLE ref_table;
334 DROP TABLE ref_table;
513 ALTER TABLE ref_table ADD CONSTRAINT fkey2 FOREIGN KEY(b) REFERENCES ref_table(a);
615 ref_table
[all …]
H A Disolation_ref_select_for_update_vs_all_on_mx.out26 …SELECT run_commands_on_session_level_connection_to_node('SELECT * FROM ref_table WHERE id=1 OR id=…
50 …SELECT run_commands_on_session_level_connection_to_node('SELECT * FROM ref_table WHERE id=1 OR id=…
119 …SELECT run_commands_on_session_level_connection_to_node('SELECT * FROM ref_table WHERE id=1 OR id=…
143 …SELECT run_commands_on_session_level_connection_to_node('INSERT INTO ref_table VALUES (1, 10), (2,…
184 SELECT COUNT(*) FROM ref_table;
244 …SELECT run_commands_on_session_level_connection_to_node('SELECT * FROM ref_table WHERE id=1 OR id=…
336 … run_commands_on_session_level_connection_to_node('INSERT INTO ref_table SELECT * FROM ref_table');
470 SELECT COUNT(*) FROM ref_table;
530 ALTER TABLE ref_table DROP value;
618 SELECT run_commands_on_session_level_connection_to_node('TRUNCATE ref_table');
[all …]
H A Disolation_replicate_reference_tables_to_coordinator.out22 SELECT shardid INTO refshardid FROM pg_dist_shard WHERE logicalrelid='ref_table'::regclass;
31 SELECT shardid INTO refshardid FROM pg_dist_shard WHERE logicalrelid='ref_table'::regclass;
75 update ref_table set a = a + 1;
91 update ref_table set a = a + 1;
94 update ref_table set a = a + 1;
109 UPDATE public.ref_table_1400163 ref_table SET a = (a OPERATOR(pg_catalog.+) 1)|localhost | …
110 UPDATE public.ref_table_1400163 ref_table SET a = (a OPERATOR(pg_catalog.+) 1)|localhost | …
111 UPDATE public.ref_table_1400163 ref_table SET a = (a OPERATOR(pg_catalog.+) 1)|coordinator_host| …
112 UPDATE public.ref_table_1400163 ref_table SET a = (a OPERATOR(pg_catalog.+) 1)|localhost | …
140 update ref_table set a = a + 1;
/dports/lang/mosml/mosml-ver-2.10.1/src/runtime/
H A Dminor_gc.c48 if (ref_table != NULL) stat_free ((char *) ref_table); in set_minor_heap_size()
49 ref_table = new_table; in set_minor_heap_size()
50 ref_table_ptr = ref_table; in set_minor_heap_size()
51 ref_table_threshold = ref_table + ref_table_size; in set_minor_heap_size()
53 ref_table_end = ref_table + ref_table_size + ref_table_reserve; in set_minor_heap_size()
139 ref_table_ptr = ref_table; in minor_collection()
164 asize_t cur_ptr = ref_table_ptr - ref_table; in realloc_ref_table()
171 if (sz > MAX_MALLOC_SIZE) ref_table = NULL; in realloc_ref_table()
174 ref_table = (value **) realloc ((char *) ref_table, sz); in realloc_ref_table()
177 ref_table_threshold = ref_table + ref_table_size; in realloc_ref_table()
[all …]
/dports/databases/py-south/South-1.0.2/south/tests/
H A Ddb_mysql.py81 ref_table = 'test_df_ref'
90 db.delete_table(ref_table)
94 ref_table = 'test_rf_ref'
104 db.delete_table(ref_table)
112 ref_table = 'test_rfi_ref'
117 db.rename_column(ref_table, 'id', 'rfi_id')
125 db.delete_table(ref_table)
130 ref_table = 'test_rt_ref'
144 db.delete_table(ref_table)
149 ref_table = 'test_rrt_ref'
[all …]
/dports/math/R/R-4.1.2/src/main/
H A Dserialize.c1056 HashAdd(s, ref_table); in WriteItem()
1067 HashAdd(s, ref_table); in WriteItem()
1072 HashAdd(s, ref_table); in WriteItem()
1148 HashAdd(s, ref_table); in WriteItem()
1389 SEXP ref_table; in R_Serialize() local
1772 R_assert(TYPEOF(ref_table) == LISTSXP && TYPEOF(CAR(ref_table)) == VECSXP); in ReadItem()
1792 AddReadRef(ref_table, s); in ReadItem()
1810 AddReadRef(ref_table, s); in ReadItem()
1817 AddReadRef(ref_table, s); in ReadItem()
1822 AddReadRef(ref_table, s); in ReadItem()
[all …]
/dports/math/libRmath/R-4.1.1/src/main/
H A Dserialize.c1056 HashAdd(s, ref_table); in WriteItem()
1067 HashAdd(s, ref_table); in WriteItem()
1072 HashAdd(s, ref_table); in WriteItem()
1148 HashAdd(s, ref_table); in WriteItem()
1389 SEXP ref_table; in R_Serialize() local
1772 R_assert(TYPEOF(ref_table) == LISTSXP && TYPEOF(CAR(ref_table)) == VECSXP); in ReadItem()
1792 AddReadRef(ref_table, s); in ReadItem()
1810 AddReadRef(ref_table, s); in ReadItem()
1817 AddReadRef(ref_table, s); in ReadItem()
1822 AddReadRef(ref_table, s); in ReadItem()
[all …]
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/spec/
H A Disolation_select_for_update.spec19 CREATE TABLE ref_table(id int, val_1 int);
21 INSERT INTO ref_table values(1,2),(3,4),(5,6);
28 DROP TABLE ref_table;
61 test_table_1_rf1 as tt1 INNER JOIN ref_table as rt1 on tt1.id = rt1.id
70 test_table_1_rf1 as tt1 INNER JOIN ref_table as rt1 on tt1.id = rt1.id
85 WITH foo AS (SELECT * FROM ref_table FOR UPDATE)
86 UPDATE ref_table SET val_1 = 4 FROM foo WHERE ref_table.id = foo.id AND EXISTS (SELECT * FROM foo);
98 SELECT * FROM (SELECT * FROM ref_table FOR UPDATE) foo WHERE id = 1;
125 UPDATE ref_table SET val_1 = 5 WHERE id = 1;
H A Disolation_dis2ref_foreign_keys_on_mx.spec5 CREATE TABLE ref_table(id int PRIMARY KEY, value int);
8 …CREATE TABLE dist_table(id int, value int REFERENCES ref_table(id) ON DELETE CASCADE ON UPDATE CAS…
11 INSERT INTO ref_table VALUES (1, 10), (2, 20);
17 DROP TABLE ref_table, dist_table;
119 SELECT * FROM ref_table ORDER BY id, value;
H A Disolation_ref_update_delete_upsert_vs_all_on_mx.spec5 CREATE TABLE ref_table(id integer, value integer);
13 DROP TABLE IF EXISTS ref_table CASCADE;
21 ALTER TABLE ref_table ADD CONSTRAINT pri_key PRIMARY KEY (id);
83 DROP TABLE ref_table;
106 SELECT COUNT(*) FROM ref_table;
/dports/security/snort3/snort3-3.1.19.0/src/target_based/
H A Dsnort_protocols.cc78 auto protocol_ref = ref_table.find(protocol); in add()
79 if ( protocol_ref != ref_table.end() ) in add()
84 ref_table[protocol] = snort_protocol_id; in add()
91 auto protocol_ref = ref_table.find(protocol); in find()
92 if ( protocol_ref != ref_table.end() ) in find()
124 { ref_table.clear(); } in ~ProtocolReference()
/dports/net/lambdamoo/MOO-1.8.1/
H A Dref_count.c34 static reftab_entry **ref_table;
48 ref_table = mymalloc(table_size * sizeof(reftab_entry *), M_REF_TABLE);
50 ref_table[index] = 0;
182 ll_insert_value(&(ref_table[index]), p);
191 ref_table = rehash(ref_table, new_table); /* frees old table */
207 return ll_delete_value(&(ref_table[index]), p);

12345678910>>...22