/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
H A D | multi_mx_reference_table.sql | 44 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 D | multi_reference_table.sql | 67 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 D | window_functions.sql | 211 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 D | multi_subquery_union.sql | 122 …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 D | multi_subquery_in_where_reference_clause.sql | 10 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 D | multi_shard_update_delete.sql | 264 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 D | subquery_in_where.sql | 212 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 D | multi_orderby_limit_pushdown.sql | 40 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 D | subquery_executors.sql | 17 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 D | subquery_in_targetlist.sql | 5 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 D | non_colocated_subquery_joins.sql | 44 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 D | multi_subquery_window_functions.sql | 65 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 D | subquery_view.sql | 90 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 D | multi_mx_reference_table.out | 73 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 D | subquery_executors.out | 13 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 D | multi_reference_table.out | 152 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 D | window_functions_1.out | 363 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 D | window_functions.out | 363 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 D | enum_flags_test.cpp | 39 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 D | field_comparator.h | 178 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 D | field_comparator.h | 178 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 D | field_comparator.h | 178 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 D | field_comparator.h | 178 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 D | field_comparator.h | 178 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 D | field_comparator.h | 178 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 …]
|