Home
last modified time | relevance | path

Searched refs:local_table (Results 1 – 25 of 281) sorted by relevance

12345678910>>...12

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dreplicate_reference_tables_to_coordinator.sql63 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 Drecursive_relation_planning_restriction_pushdown.sql42 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 Dwith_executors.sql17 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 Drecursive_view_local_table.sql4 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 Drecursive_dml_queries_mx.sql104 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 Dreplicate_reference_tables_to_coordinator.out127 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 Dwith_executors.out18 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 Drecursive_relation_planning_restriction_pushdown.out42 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 Drecursive_view_local_table.out3 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 Disolation_dump_local_wait_edges.out23 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 Dhistory_meta.py58 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 Dhistory_meta.py58 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 Dhistory_meta.py49 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 Dhistory_meta.py58 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 Dhistory_meta.py48 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 Dlwp_objmgr.c24 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 Disolation_dump_local_wait_edges.spec3 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 Ds_table.c609 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 DnsRouteMgr.cpp51 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 Dv0_05.pm36 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 Dv0_040.pm16 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 Ds_table.c685 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 Doslinuxtbl.c160 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 Doslinuxtbl.c160 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 Doslinuxtbl.c160 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 …]

12345678910>>...12