/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
H A D | recursive_view_local_table.sql | 19 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 D | local_shard_utility_command_execution.sql | 38 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 D | multi_mx_modifications_to_reference_tables.sql | 33 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 D | failure_ref_tables.sql | 5 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 D | multi_select_for_update.sql | 20 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 D | multi_replicate_reference_table.sql | 500 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 D | failure_create_reference_table.sql | 17 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 D | recursive_view_local_table.out | 15 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 D | multi_mx_modifications_to_reference_tables.out | 47 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 D | failure_ref_tables.out | 8 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 D | failure_create_reference_table.out | 17 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 D | isolation_ref_update_delete_upsert_vs_all_on_mx.out | 10 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 D | isolation_get_distributed_wait_queries_mx.out | 8 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 D | local_shard_utility_command_execution.out | 48 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 D | isolation_ref_select_for_update_vs_all_on_mx.out | 26 …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 D | isolation_replicate_reference_tables_to_coordinator.out | 22 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 D | minor_gc.c | 48 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 D | db_mysql.py | 81 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 D | serialize.c | 1056 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 D | serialize.c | 1056 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 D | isolation_select_for_update.spec | 19 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 D | isolation_dis2ref_foreign_keys_on_mx.spec | 5 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 D | isolation_ref_update_delete_upsert_vs_all_on_mx.spec | 5 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 D | snort_protocols.cc | 78 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 D | ref_count.c | 34 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);
|