/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
H A D | replicate_reference_tables_to_coordinator.sql | 63 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 67 FROM local_table lt 73 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 79 PERFORM local_table.a, numbers.a FROM local_table NATURAL JOIN numbers; 89 PERFORM local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 100 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 109 SELECT local_table.a, r.a FROM local_table NATURAL JOIN s1.ref r ORDER BY 1; 121 ) SELECT count(*) FROM t1, local_table WHERE t1.a = local_table.a AND r < 0.5; 141 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 172 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers FOR SHARE; [all …]
|
H A D | recursive_relation_planning_restriction_pushdown.sql | 42 JOIN local_table USING (key); 65 JOIN local_table u2 USING (key) 71 JOIN local_table u2 USING(key) 78 JOIN local_table u2 USING(value) 84 JOIN local_table u2 USING(value) 91 JOIN local_table u2 USING(value) 97 JOIN local_table u2 USING(value) 103 JOIN local_table u2 USING(value) 109 JOIN local_table u2 USING(value) 115 JOIN local_table u2 USING(value) [all …]
|
H A D | with_executors.sql | 17 SELECT * FROM local_table 29 SELECT * FROM local_table 44 SELECT * FROM local_table WHERE id < 5 47 SELECT * FROM local_table WHERE id > 5 169 local_table AS ( 170 SELECT * FROM local_table 181 local_table 183 router_exec.user_id=local_table.id 207 local_table AS ( 208 SELECT * FROM local_table [all …]
|
H A D | recursive_view_local_table.sql | 4 CREATE TABLE local_table(a INT); table 5 INSERT INTO local_table VALUES (1),(2),(3); 11 SELECT GREATEST(val_1,val_2),val_1 + val_2 AS local_table 17 CREATE RECURSIVE VIEW recursive_defined_non_recursive_view(c) AS (SELECT 1 FROM local_table); 24 …FROM ref_table LEFT OUTER JOIN (SELECT * FROM (SELECT 1, random() FROM local_table) as s WHERE FAL… 30 SELECT ref_table.* FROM ref_table JOIN (SELECT * FROM (SELECT 1, random() FROM local_table) as s WH… 32 SELECT ref_table.* FROM ref_table JOIN (SELECT * FROM (SELECT 1, random() FROM local_table) as s WH… 34 SELECT ref_table.* FROM ref_table JOIN (SELECT * FROM (SELECT 1, random() FROM local_table) as s WH… 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… [all …]
|
H A D | recursive_dml_queries_mx.sql | 104 CREATE TABLE recursive_dml_queries_mx.local_table (id text, name text); table 105 INSERT INTO local_table SELECT i::text, 'user_' || i FROM generate_series (0, 100) i; 124 avg(local_table.id::int) as avg_tenant_id 126 local_table 150 DROP TABLE local_table;
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/ |
H A D | replicate_reference_tables_to_coordinator.out | 127 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 136 FROM local_table lt 149 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 160 PERFORM local_table.a, numbers.a FROM local_table NATURAL JOIN numbers; 172 PERFORM local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 201 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 215 SELECT local_table.a, r.a FROM local_table NATURAL JOIN s1.ref r ORDER BY 1; 236 ) SELECT count(*) FROM t1, local_table WHERE t1.a = local_table.a AND r < 0.5; 273 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers ORDER BY 1; 352 SELECT local_table.a, numbers.a FROM local_table NATURAL JOIN numbers FOR SHARE; [all …]
|
H A D | with_executors.out | 18 SELECT * FROM local_table 33 SELECT * FROM local_table 53 SELECT * FROM local_table WHERE id < 5 56 SELECT * FROM local_table WHERE id > 5 229 local_table AS ( 230 SELECT * FROM local_table 241 local_table 243 router_exec.user_id=local_table.id 271 local_table AS ( 272 SELECT * FROM local_table [all …]
|
H A D | recursive_relation_planning_restriction_pushdown.out | 42 JOIN local_table USING (key); 93 JOIN local_table u2 USING (key) 106 JOIN local_table u2 USING(key) 119 JOIN local_table u2 USING(value) 132 JOIN local_table u2 USING(value) 145 JOIN local_table u2 USING(value) 158 JOIN local_table u2 USING(value) 171 JOIN local_table u2 USING(value) 184 JOIN local_table u2 USING(value) 197 JOIN local_table u2 USING(value) [all …]
|
H A D | recursive_view_local_table.out | 3 CREATE TABLE local_table(a INT); 4 INSERT INTO local_table VALUES (1),(2),(3); 9 SELECT GREATEST(val_1,val_2),val_1 + val_2 AS local_table 14 CREATE RECURSIVE VIEW recursive_defined_non_recursive_view(c) AS (SELECT 1 FROM local_table); 75 SELECT ref_table.* FROM ref_table JOIN (SELECT * FROM (SELECT 1, random() FROM local_table) as s WH… 85 SELECT ref_table.* FROM ref_table JOIN (SELECT * FROM (SELECT 1, random() FROM local_table) as s WH… 105 SELECT ref_table.* FROM ref_table JOIN (SELECT * FROM (SELECT 1, random() FROM local_table) as s WH… 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… [all …]
|
H A D | isolation_dump_local_wait_edges.out | 23 UPDATE local_table SET y = 1 WHERE x = 1; 26 UPDATE local_table SET y = 3 WHERE x = 1; 69 UPDATE local_table SET y = 2 WHERE x = 1; 72 UPDATE local_table SET y = 3 WHERE x = 1; 124 UPDATE local_table SET y = 1 WHERE x = 1; 127 UPDATE local_table SET y = 2 WHERE x = 1; 130 UPDATE local_table SET y = 3 WHERE x = 1;
|
/dports/databases/py-sqlalchemy13/SQLAlchemy-1.3.24/examples/versioned_history/ |
H A D | history_meta.py | 58 or local_mapper.local_table is not super_mapper.local_table 64 for column in local_mapper.local_table.c: 71 column, super_mapper.local_table 128 local_mapper.local_table.name + "_history", 129 local_mapper.local_table.metadata, 131 schema=local_mapper.local_table.schema 136 for column in local_mapper.local_table.c: 165 local_mapper.local_table.append_column( 169 "version", local_mapper.local_table.c.version 216 for hist_col in hm.local_table.c: [all …]
|
/dports/databases/py-sqlalchemy14/SQLAlchemy-1.4.27/examples/versioned_history/ |
H A D | history_meta.py | 58 or local_mapper.local_table is not super_mapper.local_table 64 for column in local_mapper.local_table.c: 71 column, super_mapper.local_table 128 local_mapper.local_table.name + "_history", 129 local_mapper.local_table.metadata, 131 schema=local_mapper.local_table.schema 136 for column in local_mapper.local_table.c: 165 local_mapper.local_table.append_column( 170 "version", local_mapper.local_table.c.version 217 for hist_col in hm.local_table.c: [all …]
|
/dports/databases/py-sqlalchemy11/SQLAlchemy-1.1.18/examples/versioned_history/ |
H A D | history_meta.py | 49 local_mapper.local_table is not super_mapper.local_table: 54 for column in local_mapper.local_table.c: 107 local_mapper.local_table.name + '_history', 108 local_mapper.local_table.metadata, 110 schema=local_mapper.local_table.schema 115 for column in local_mapper.local_table.c: 118 super_history_mapper.local_table.append_column(col) 145 local_mapper.local_table.append_column( 149 "version", local_mapper.local_table.c.version) 190 for hist_col in hm.local_table.c: [all …]
|
/dports/databases/py-sqlalchemy12/SQLAlchemy-1.2.19/examples/versioned_history/ |
H A D | history_meta.py | 58 or local_mapper.local_table is not super_mapper.local_table 64 for column in local_mapper.local_table.c: 71 column, super_mapper.local_table 128 local_mapper.local_table.name + "_history", 129 local_mapper.local_table.metadata, 131 schema=local_mapper.local_table.schema 136 for column in local_mapper.local_table.c: 165 local_mapper.local_table.append_column( 169 "version", local_mapper.local_table.c.version 210 for hist_col in hm.local_table.c: [all …]
|
/dports/databases/py-sqlalchemy10/SQLAlchemy-1.0.14/examples/versioned_history/ |
H A D | history_meta.py | 48 local_mapper.local_table is not super_mapper.local_table: 53 for column in local_mapper.local_table.c: 106 local_mapper.local_table.name + '_history', 107 local_mapper.local_table.metadata, 109 schema=local_mapper.local_table.schema 114 for column in local_mapper.local_table.c: 117 super_history_mapper.local_table.append_column(col) 144 local_mapper.local_table.append_column( 148 "version", local_mapper.local_table.c.version) 185 for hist_col in hm.local_table.c: [all …]
|
/dports/games/retroarch/RetroArch-1.9.7/wii/libogc/libogc/ |
H A D | lwp_objmgr.c | 24 void **local_table; in __lwp_objmgr_initinfo() local 32 info->local_table = &null_local_table; in __lwp_objmgr_initinfo() 37 local_table = (void**)__lwp_wkspace_allocate(info->max_nodes*sizeof(lwp_obj*)); in __lwp_objmgr_initinfo() 38 if(!local_table) return; in __lwp_objmgr_initinfo() 40 info->local_table = (lwp_obj**)local_table; in __lwp_objmgr_initinfo() 42 local_table[i] = NULL; in __lwp_objmgr_initinfo() 47 __lwp_wkspace_free(local_table); in __lwp_objmgr_initinfo() 73 if((object=info->local_table[id])!=NULL) { in __lwp_objmgr_getisrdisable() 87 if((object=info->local_table[id])!=NULL) return object; in __lwp_objmgr_getnoprotection() 98 if((object=info->local_table[id])!=NULL) return object; in __lwp_objmgr_get()
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/spec/ |
H A D | isolation_dump_local_wait_edges.spec | 3 CREATE TABLE local_table (x int primary key, y int); 4 INSERT INTO local_table VALUES (1,0); 9 DROP TABLE local_table; 22 UPDATE local_table SET y = 1 WHERE x = 1; 39 UPDATE local_table SET y = 2 WHERE x = 1; 57 UPDATE local_table SET y = 3 WHERE x = 1;
|
/dports/cad/geda/geda-gaf-1.8.2/gattrib/src/ |
H A D | s_table.c | 609 TABLE **local_table; in s_table_gtksheet_to_all_tables() local 619 local_table = sheet_head->component_table; in s_table_gtksheet_to_all_tables() 626 master_col_list, local_table, in s_table_gtksheet_to_all_tables() 636 local_table = sheet_head->net_table; in s_table_gtksheet_to_all_tables() 639 master_col_list, local_table, in s_table_gtksheet_to_all_tables() 651 local_table = sheet_head->pin_table; in s_table_gtksheet_to_all_tables() 654 master_col_list, local_table, in s_table_gtksheet_to_all_tables() 729 local_table[row][col].attrib_value = NULL; in s_table_gtksheet_to_table() 736 g_free( local_table[row][col].row_name ); in s_table_gtksheet_to_table() 740 local_table[row][col].row_name = NULL; in s_table_gtksheet_to_table() [all …]
|
/dports/net/norm/norm-1.5r6/protolib/src/sim/ns/ |
H A D | nsRouteMgr.cpp | 51 ProtoRouteTable local_table; member in NsRouteMgr 80 local_table.Init(); in Open() 86 local_table.Destroy(); in Close() 96 return local_table.FindRoute(dst,prefixLen,gw,ifIndex,metric); in GetRoute() 105 return local_table.SetRoute(dst,prefixLen,gw,ifIndex,metric); in SetRoute() 113 return local_table.DeleteRoute(dst,prefixLen,&gw); in DeleteRoute()
|
/dports/databases/p5-DBIx-Class-Schema-Loader/DBIx-Class-Schema-Loader-0.07049/lib/DBIx/Class/Schema/Loader/RelBuilder/Compat/ |
H A D | v0_05.pm | 36 my $local_table = $rel->{local_table}; 45 $remote_relname = lc($local_table) . $colnames; 50 $remote_relname_uninflected = lc $local_table; 51 ($remote_relname) = $self->_inflect_plural(lc $local_table);
|
H A D | v0_040.pm | 16 my $local_table = $rel->{local_table}; 31 ($remote_relname) = $self->_inflect_plural( lc($local_table) . $colnames ); 33 ($remote_relname) = $self->_inflect_plural(lc $local_table);
|
/dports/cad/lepton-eda/lepton-eda-1.9.17/libleptonattrib/src/ |
H A D | s_table.c | 685 TABLE **local_table; in s_table_gtksheet_to_all_tables() local 695 local_table = sheet_head->component_table; in s_table_gtksheet_to_all_tables() 701 master_col_list, local_table, in s_table_gtksheet_to_all_tables() 711 local_table = sheet_head->net_table; in s_table_gtksheet_to_all_tables() 726 local_table = sheet_head->pin_table; in s_table_gtksheet_to_all_tables() 793 g_free( local_table[row][col].attrib_value ); in s_table_gtksheet_to_table() 797 local_table[row][col].attrib_value = NULL; in s_table_gtksheet_to_table() 802 g_free( local_table[row][col].row_name ); in s_table_gtksheet_to_table() 806 local_table[row][col].row_name = NULL; in s_table_gtksheet_to_table() 811 g_free( local_table[row][col].col_name ); in s_table_gtksheet_to_table() [all …]
|
/dports/multimedia/v4l_compat/linux-5.13-rc2/tools/power/acpi/os_specific/service_layers/ |
H A D | oslinuxtbl.c | 160 struct acpi_table_header *local_table = NULL; in acpi_os_get_table_by_address() local 185 local_table = calloc(1, table_length); in acpi_os_get_table_by_address() 186 if (!local_table) { in acpi_os_get_table_by_address() 195 *table = local_table; in acpi_os_get_table_by_address() 967 local_table = calloc(1, table_length); in osl_get_bios_table() 968 if (!local_table) { in osl_get_bios_table() 975 *table = local_table; in osl_get_bios_table() 1257 local_table = calloc(1, table_length); in osl_read_table_from_file() 1258 if (!local_table) { in osl_read_table_from_file() 1278 (void)ap_is_valid_checksum(local_table); in osl_read_table_from_file() [all …]
|
/dports/multimedia/libv4l/linux-5.13-rc2/tools/power/acpi/os_specific/service_layers/ |
H A D | oslinuxtbl.c | 160 struct acpi_table_header *local_table = NULL; in acpi_os_get_table_by_address() local 185 local_table = calloc(1, table_length); in acpi_os_get_table_by_address() 186 if (!local_table) { in acpi_os_get_table_by_address() 195 *table = local_table; in acpi_os_get_table_by_address() 967 local_table = calloc(1, table_length); in osl_get_bios_table() 968 if (!local_table) { in osl_get_bios_table() 975 *table = local_table; in osl_get_bios_table() 1257 local_table = calloc(1, table_length); in osl_read_table_from_file() 1258 if (!local_table) { in osl_read_table_from_file() 1278 (void)ap_is_valid_checksum(local_table); in osl_read_table_from_file() [all …]
|
/dports/multimedia/v4l-utils/linux-5.13-rc2/tools/power/acpi/os_specific/service_layers/ |
H A D | oslinuxtbl.c | 160 struct acpi_table_header *local_table = NULL; in acpi_os_get_table_by_address() local 185 local_table = calloc(1, table_length); in acpi_os_get_table_by_address() 186 if (!local_table) { in acpi_os_get_table_by_address() 195 *table = local_table; in acpi_os_get_table_by_address() 967 local_table = calloc(1, table_length); in osl_get_bios_table() 968 if (!local_table) { in osl_get_bios_table() 975 *table = local_table; in osl_get_bios_table() 1257 local_table = calloc(1, table_length); in osl_read_table_from_file() 1258 if (!local_table) { in osl_read_table_from_file() 1278 (void)ap_is_valid_checksum(local_table); in osl_read_table_from_file() [all …]
|