Home
last modified time | relevance | path

Searched refs:value_2 (Results 1 – 25 of 1131) sorted by relevance

12345678910>>...46

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dmulti_mx_reference_table.sql44 value_2
79 value_2 = 2 OR value_2 = 3;
86 value_2 = 2 AND value_2 = 3;
110 value_2 IN
144 value_2 <= 2 AND value_2 >= 4;
151 value_2 <= 20 AND value_2 >= 4;
158 value_2 >= 5 AND value_2 <= random();
371 t1.value_2 = t2.value_2
380 t1.value_2 = t3.value_2
389 t2.value_2 = t3.value_2
[all …]
H A Dmulti_reference_table.sql67 value_2
102 value_2 = 2 OR value_2 = 3;
109 value_2 = 2 AND value_2 = 3;
133 value_2 IN
167 value_2 <= 2 AND value_2 >= 4;
174 value_2 <= 20 AND value_2 >= 4;
181 value_2 >= 5 AND value_2 <= random();
381 t1.value_2 = t2.value_2
390 t1.value_2 = t3.value_2
399 t2.value_2 = t3.value_2
[all …]
H A Dwindow_functions.sql211 value_2
287 value_2,
305 value_2,
312 value_2 > 2 AND value_2 < 6
318 value_2,
325 value_2 > 2 AND value_2 < 6
341 value_2 > 2 and value_2 < 6
439 AVG(avg(value_1)) OVER (PARTITION BY value_2, max(value_2), MIN(value_2)),
440 AVG(avg(value_2)) OVER (PARTITION BY value_2, min(value_2), AVG(value_1))
450 AVG(avg(value_1)) OVER (PARTITION BY value_2, max(value_2), MIN(value_2)),
[all …]
H A Dmulti_subquery_union.sql122 …SELECT user_id, sum(value_2) AS counter FROM users_table where value_1 < 1 GROUP BY user_id HAVING…
137 …SELECT user_id, sum(value_2) AS counter FROM users_table where value_1 < 1 GROUP BY user_id HAVING…
152 …SELECT user_id, sum(value_2) AS counter FROM users_table where value_1 < 1 GROUP BY user_id HAVING…
171 user_id, sum(value_2) AS counter
178 user_id, sum(value_2) AS counter
190 user_id, sum(value_2) AS counter
197 user_id, sum(value_2) AS counter
673 SELECT sum(users_table.value_2), user_id
684 SELECT value_2, user_id
689 SELECT sum(users_table.value_2), user_id
[all …]
H A Dmulti_subquery_in_where_reference_clause.sql10 value_2 IN
12 value_2
31 value_2
50 value_2
67 value_2
152 value_2 IN
170 value_2 IN
188 value_2 IN
350 e1.value_2 > e2.value_2
477 value_2 >
[all …]
H A Dmulti_shard_update_delete.sql264 SET value_2 = 5
321 value_2 >
335 value_2 >
342 users_test_table.value_2 > events_test_table.value_2
348 SET value_2 = 4
351 AND value_2 >= 1
387 SET value_2 = 1
412 SET value_2 = 5
418 SET value_2 = 6
540 SET value_2 = 2
[all …]
H A Dsubquery_in_where.sql212 max(value_2)
230 value_2 DESC
238 value_2
261 value_2 DESC
269 value_2
305 value_2
348 value_2
390 value_2
436 value_2
593 value_2 IN (SELECT value_2 FROM users_table WHERE user_id = e.user_id ORDER BY value_2 LIMIT 1);
[all …]
H A Dmulti_orderby_limit_pushdown.sql40 SELECT user_id, avg(value_1) + sum(value_2)
63 SELECT user_id, sum(value_1) + sum(value_2)
69 SELECT user_id, sum(value_1) + sum(value_2)
72 ORDER BY sum(value_2) DESC
88 SELECT user_id, sum(value_1 + value_2)
100 SELECT user_id, sum(value_1 + value_2)
119 SELECT 10000 / (sum(value_1 + value_2))
149 SELECT ut.user_id, avg(ut.value_2)
157 SELECT ut.user_id, avg(ut.value_2)
165 SELECT ut.user_id, avg(et.value_2)
[all …]
H A Dsubquery_executors.sql17 SELECT value_2 FROM users_table WHERE user_id = 15 OFFSET 0
22 WHERE foo.value_2 = bar.user_id;
42 SELECT value_2 FROM users_table WHERE user_id != 15 OFFSET 0
47 WHERE foo.value_2 = bar.user_id;
57 …SELECT DISTINCT users_table.value_2 FROM users_table, events_table WHERE users_table.user_id = eve…
62 WHERE foo.value_2 = bar.user_id;
75 …SELECT DISTINCT users_table.value_2 FROM users_table, events_table WHERE users_table.user_id = eve…
80 WHERE foo.value_2 = bar.user_id AND baz.value_2 = bar.user_id AND bar.user_id = baw.user_id;
91 SELECT value_2 FROM users_table WHERE user_id = 1 OFFSET 0
96 WHERE foo.value_2 = bar.user_id;
[all …]
H A Dsubquery_in_targetlist.sql5 SELECT event_type, (SELECT 1 + 3 + e.value_2)
15 SELECT event_type, (SELECT e.value_2 FROM users_reference_table WHERE user_id = 1 AND value_1 = 1),…
129 GROUP BY e.value_2
187 SELECT (SELECT value_2 FROM view_1 WHERE user_id = e.user_id GROUP BY user_id, value_2)
193 SELECT (SELECT value_2 FROM view_1 WHERE user_id = e.user_id GROUP BY value_2)
199 SELECT (SELECT value_2 FROM view_1 WHERE user_id = e.user_id GROUP BY user_id, value_2)
212 SELECT (SELECT value_2 FROM view_2 WHERE user_id = e.user_id GROUP BY user_id, value_2)
218 SELECT (SELECT value_2 FROM view_2 WHERE user_id = e.user_id GROUP BY user_id, value_2)
224 SELECT (SELECT value_2 FROM view_1 WHERE user_id = e.user_id GROUP BY user_id, value_2)
272 …T event_type, (SELECT e.value_2 FROM users_reference_table WHERE user_id = 1 AND value_1 = 1 AND v…
[all …]
H A Dnon_colocated_subquery_joins.sql44 foo.value_2
49 foo.value_2 = bar.value_2;
474 WHERE value_2 >= 5
530 USING(value_2);
545 USING(value_2);
612 foo.value_2
617 foo.value_2 = bar.value_2
647 foo.value_2 = bar.value_2
649 foo.value_2 = baz.value_2
673 value_2 IN (SELECT value_1 FROM users_table WHERE value_2 < 1)
[all …]
H A Dmulti_subquery_window_functions.sql65 user_id, rank() OVER my_win as rnk, avg(value_2) as avg_val_2
231 w1 AS (w ORDER BY value_2, value_3)
249 WHERE users_table.value_2 + 40 = users_ref_test_table.k_no
259 DISTINCT user_id, SUM(value_2) OVER (PARTITION BY user_id)
263 user_id, value_1, value_2
276 user_id, value_1, value_2
367 value_2 > 1 AND
368 value_2 < ALL (
391 user_id, value_2, sum(value_3) OVER (PARTITION BY user_id, value_2) as value_3
414 user_id, sum(value_2) OVER (PARTITION BY user_id)
[all …]
H A Dsubquery_view.sql90 users_table.value_2
96 GROUP BY users_table.value_2
109 WHERE foo.value_2 = bar.value_3
119 users_table.value_2
125 GROUP BY users_table.value_2
137 WHERE foo.value_2 = bar.user_id
142 DISTINCT ON (users_table.value_2) users_table.value_2, time, value_3
183 WHERE value_2 >= 5
241 WHERE foo.value_2 = bar.user_id;
264 WHERE foo.value_2 = bar.user_id AND baz.value_2 = bar.user_id AND bar.user_id = baw.user_id;
[all …]
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/
H A Dmulti_mx_reference_table.out73 value_2
129 value_2 = 2 OR value_2 = 3;
141 value_2 = 2 AND value_2 = 3;
225 value_2 <= 2 AND value_2 >= 4;
235 value_2 <= 20 AND value_2 >= 4;
247 value_2 >= 5 AND value_2 <= random();
623 t1.value_2 = t2.value_2
638 t1.value_2 = t3.value_2
652 t2.value_2 = t3.value_2
714 t1.value_2 = date_part('day', t2.value_4) AND t3.value_2 = t1.value_2
[all …]
H A Dsubquery_executors.out13 SELECT value_2 FROM users_table WHERE user_id = 15 OFFSET 0
18 WHERE foo.value_2 = bar.user_id;
50 SELECT value_2 FROM users_table WHERE user_id != 15 OFFSET 0
55 WHERE foo.value_2 = bar.user_id;
69 …SELECT DISTINCT users_table.value_2 FROM users_table, events_table WHERE users_table.user_id = eve…
74 WHERE foo.value_2 = bar.user_id;
93 …SELECT DISTINCT users_table.value_2 FROM users_table, events_table WHERE users_table.user_id = eve…
98 WHERE foo.value_2 = bar.user_id AND baz.value_2 = bar.user_id AND bar.user_id = baw.user_id;
115 SELECT value_2 FROM users_table WHERE user_id = 1 OFFSET 0
120 WHERE foo.value_2 = bar.user_id;
[all …]
H A Dmulti_reference_table.out152 value_2 = 2 OR value_2 = 3;
164 value_2 = 2 AND value_2 = 3;
248 value_2 <= 2 AND value_2 >= 4;
258 value_2 <= 20 AND value_2 >= 4;
270 value_2 >= 5 AND value_2 <= random();
627 t1.value_2 = t2.value_2
642 t1.value_2 = t3.value_2
656 t2.value_2 = t3.value_2
716 t1.value_2 = date_part('day', t2.value_4) AND t3.value_2 = t1.value_2
1358 value_2 | double precision | value_2
[all …]
H A Dwindow_functions_1.out363 value_2
689 value_2,
716 value_2,
723 value_2 > 2 AND value_2 < 6
782 value_2,
789 value_2 > 2 AND value_2 < 6
858 value_2 > 2 and value_2 < 6
1057 AVG(avg(value_1)) OVER (PARTITION BY value_2, max(value_2), MIN(value_2)),
1058 AVG(avg(value_2)) OVER (PARTITION BY value_2, min(value_2), AVG(value_1))
1077 AVG(avg(value_1)) OVER (PARTITION BY value_2, max(value_2), MIN(value_2)),
[all …]
H A Dwindow_functions.out363 value_2
689 value_2,
716 value_2,
723 value_2 > 2 AND value_2 < 6
782 value_2,
789 value_2 > 2 AND value_2 < 6
858 value_2 > 2 and value_2 < 6
1057 AVG(avg(value_1)) OVER (PARTITION BY value_2, max(value_2), MIN(value_2)),
1058 AVG(avg(value_2)) OVER (PARTITION BY value_2, min(value_2), AVG(value_1))
1077 AVG(avg(value_1)) OVER (PARTITION BY value_2, max(value_2), MIN(value_2)),
[all …]
/dports/devel/rttr/rttr-0.9.6-16-gb3a131c/src/unit_tests/misc/
H A Denum_flags_test.cpp39 value_2 = 2, enumerator
86 f1 &= enum_test_flag::value_2;
89 CHECK(f1.test_flag(enum_test_flag::value_2) == true);
102 enum_test_flags f2 = f1 & enum_test_flag::value_2;
105 CHECK(f2.test_flag(enum_test_flag::value_2) == true);
126 CHECK(f1.test_flag(enum_test_flag::value_2) == true);
141 CHECK(f2.test_flag(enum_test_flag::value_2) == true);
165 f1 ^= enum_test_flag::value_2;
189 f2 = f2 ^ enum_test_flag::value_2;
213 CHECK(f2.test_flag(enum_test_flag::value_2) == false);
[all …]
/dports/lang/spidermonkey78/firefox-78.9.0/toolkit/components/protobuf/src/google/protobuf/util/
H A Dfield_comparator.h178 bool value_2) { in CompareBool() argument
179 return value_1 == value_2; in CompareBool()
185 double value_2);
196 int32 value_2) { in CompareInt32() argument
197 return value_1 == value_2; in CompareInt32()
201 int64 value_2) { in CompareInt64() argument
202 return value_1 == value_2; in CompareInt64()
207 return value_1 == value_2; in CompareString()
211 uint32 value_2) { in CompareUInt32() argument
212 return value_1 == value_2; in CompareUInt32()
[all …]
/dports/www/qt5-webengine/qtwebengine-everywhere-src-5.15.2/src/3rdparty/chromium/third_party/protobuf/src/google/protobuf/util/
H A Dfield_comparator.h178 bool value_2) { in CompareBool() argument
179 return value_1 == value_2; in CompareBool()
185 double value_2);
196 int32 value_2) { in CompareInt32() argument
197 return value_1 == value_2; in CompareInt32()
201 int64 value_2) { in CompareInt64() argument
202 return value_1 == value_2; in CompareInt64()
207 return value_1 == value_2; in CompareString()
211 uint32 value_2) { in CompareUInt32() argument
212 return value_1 == value_2; in CompareUInt32()
[all …]
/dports/www/firefox/firefox-99.0/toolkit/components/protobuf/src/google/protobuf/util/
H A Dfield_comparator.h178 bool value_2) { in CompareBool() argument
179 return value_1 == value_2; in CompareBool()
185 double value_2);
196 int32 value_2) { in CompareInt32() argument
197 return value_1 == value_2; in CompareInt32()
201 int64 value_2) { in CompareInt64() argument
202 return value_1 == value_2; in CompareInt64()
207 return value_1 == value_2; in CompareString()
211 uint32 value_2) { in CompareUInt32() argument
212 return value_1 == value_2; in CompareUInt32()
[all …]
/dports/mail/thunderbird/thunderbird-91.8.0/toolkit/components/protobuf/src/google/protobuf/util/
H A Dfield_comparator.h178 bool value_2) { in CompareBool() argument
179 return value_1 == value_2; in CompareBool()
185 double value_2);
196 int32 value_2) { in CompareInt32() argument
197 return value_1 == value_2; in CompareInt32()
201 int64 value_2) { in CompareInt64() argument
202 return value_1 == value_2; in CompareInt64()
207 return value_1 == value_2; in CompareString()
211 uint32 value_2) { in CompareUInt32() argument
212 return value_1 == value_2; in CompareUInt32()
[all …]
/dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/protobuf/src/google/protobuf/util/
H A Dfield_comparator.h178 bool value_2) { in CompareBool() argument
179 return value_1 == value_2; in CompareBool()
185 double value_2);
196 int32 value_2) { in CompareInt32() argument
197 return value_1 == value_2; in CompareInt32()
201 int64 value_2) { in CompareInt64() argument
202 return value_1 == value_2; in CompareInt64()
207 return value_1 == value_2; in CompareString()
211 uint32 value_2) { in CompareUInt32() argument
212 return value_1 == value_2; in CompareUInt32()
[all …]
/dports/www/firefox-esr/firefox-91.8.0/toolkit/components/protobuf/src/google/protobuf/util/
H A Dfield_comparator.h178 bool value_2) { in CompareBool() argument
179 return value_1 == value_2; in CompareBool()
185 double value_2);
196 int32 value_2) { in CompareInt32() argument
197 return value_1 == value_2; in CompareInt32()
201 int64 value_2) { in CompareInt64() argument
202 return value_1 == value_2; in CompareInt64()
207 return value_1 == value_2; in CompareString()
211 uint32 value_2) { in CompareUInt32() argument
212 return value_1 == value_2; in CompareUInt32()
[all …]

12345678910>>...46