Home
last modified time | relevance | path

Searched refs:value_3 (Results 1 – 25 of 289) sorted by relevance

12345678910>>...12

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dmulti_shard_update_delete.sql75 UPDATE users_test_table SET value_3 = 0;
81 UPDATE users_test_table SET value_3 = 1;
90 UPDATE users_test_table SET value_3 = 1;
97 UPDATE users_test_table SET value_3 = 5;
98 UPDATE users_test_table SET value_3 = 0;
104 UPDATE users_test_table SET value_3 = 5;
106 UPDATE users_test_table SET value_3 = 2;
333 SET value_3 = 1
374 SET value_3 = 5
419 WHERE ett.value_3 IN (SELECT utt.value_3
[all …]
H A Dsubquery_in_where.sql649 …value_3 IN (SELECT min(value_3) v FROM users_table WHERE user_id = e.user_id GROUP BY e.value_2 HA…
656 …value_3 IN (SELECT min(value_3) v FROM users_table WHERE user_id = e.user_id GROUP BY e.value_2 HA…
664 value_3 IN (
667 GROUP BY e.value_2 HAVING min(r.value_3) > e.value_3);
675 value_3 IN (
678 GROUP BY e.value_2 HAVING min(r.value_3) > e.value_3);
686 value_3 IN (
689 GROUP BY e.value_2 HAVING min(r.value_3) > e.value_3);
697 value_3 IN (
700 GROUP BY u.value_2 HAVING min(r.value_3) > e.value_3);
[all …]
H A Dmulti_subquery_union.sql491 user_id, value_3
494 (SELECT value_3, user_id FROM users_table)
496 (SELECT value_3, user_id FROM events_table)
515 user_id, sum(value_3)
518 (SELECT value_3, user_id FROM users_table)
520 (SELECT value_3, user_id FROM events_table)
528 user_id, value_3
531 (SELECT value_3, user_id FROM events_table where event_type IN (1, 2))
548 max(value_3)
781 user_id, value_3
[all …]
H A Dmulti_reference_table.sql74 value_1, value_3
116 value_3 = '2' OR value_1 = 3;
124 value_3 = '2' OR value_1 = 3
136 value_3::FLOAT
147 value_3 IN
157 value_3 IN
276 value_3,
281 GROUPING sets ((value_4), (value_3))
418 t1.value_2 = t2.value_3::int
499 UPDATE SET value_3 = EXCLUDED.value_3, value_2 = EXCLUDED.value_2
[all …]
H A Dmulti_subquery_complex_queries.sql1684 user_id, value_3 * 2 as value_3
1729 user_id, value_3 * 2 as value_3
1783 value_3 DESC
1797 value_3 DESC
1825 value_3 DESC
1867 value_3 DESC
1870 value_3 DESC
1882 value_3 DESC
1910 value_3 DESC
2321 value_3
[all …]
H A Dwith_executors.sql122 users_table.user_id as uid_2, users_table.value_3
128 users_table.value_3=events_table.value_3
131 uid_1, uid_2, value_2, value_3
137 value_2 = value_3
140 uid_1, uid_2, cte.value_2, cte.value_3
173 SELECT uid_1, time, value_3 FROM task_tracker JOIN real_time ON val_2=value_3
185 SELECT * FROM join_first_two JOIN join_last_two ON id = value_3 ORDER BY 1,2,3,4,5 LIMIT 10
187 SELECT DISTINCT uid_1, time, value_3 FROM cte ORDER BY 1, 2, 3 LIMIT 20;
211 SELECT uid_1, time, value_3 FROM task_tracker JOIN real_time ON val_2=value_3
223 …SELECT uid_1, value_3 as val_3 FROM join_first_two JOIN join_last_two ON id = value_3 ORDER BY 1,2…
H A Dmulti_subquery_window_functions.sql231 w1 AS (w ORDER BY value_2, value_3)
311 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (1…
313 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (2…
315 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (3…
317 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (4…
370 avg(value_3) OVER (PARTITION BY user_id)
385 user_id, rank, SUM(ABS(value_2 - value_3)) AS difference, COUNT(*) AS distinct_users
391 user_id, value_2, sum(value_3) OVER (PARTITION BY user_id, value_2) as value_3
406 user_id, sum(value_3) OVER (PARTITION BY user_id)
410 user_id, value_3
[all …]
H A Dmulti_mx_reference_table.sql4 CREATE TABLE reference_table_test (value_1 int, value_2 float, value_3 text, value_4 timestamp); field
51 value_1, value_3
93 value_3 = '2' OR value_1 = 3;
101 value_3 = '2' OR value_1 = 3
113 value_3::FLOAT
124 value_3 IN
134 value_3 IN
255 value_3,
260 GROUPING sets ((value_4), (value_3))
408 t1.value_2 = t2.value_3::int
[all …]
H A Dmulti_insert_select_window.sql273 avg(value_3) OVER (PARTITION BY user_id)
306 user_id, rank, SUM(ABS(value_2 - value_3)) AS difference, COUNT(*) AS distinct_users
312 user_id, value_2, sum(value_3) OVER (PARTITION BY user_id, value_2) as value_3
329 user_id, sum(value_3) OVER (PARTITION BY user_id)
333 user_id, value_3
437 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (1…
439 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (6…
464 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (1…
466 …(SELECT avg(value_3) over (partition by user_id), user_id FROM events_table where event_type IN (6…
685 w AS (PARTITION BY time), w1 AS (w ORDER BY value_2, value_3)
[all …]
H A Dmulti_subquery_behavioral_analytics.sql936 user_id, value_2, value_3
947 avg(b.value_3), 2, 1
964 user_id, value_2, value_3
975 sum(b.value_3) > 5
977 avg(b.value_3), 2, 1
997 user_id, value_2, value_3
1009 avg(b.value_3) DESC, 2, 1
1025 e1.value_3 DESC
1128 ORDER BY avg(b.value_3), 2, 1
1188 avg(b.value_3), 2, 1
[all …]
H A Dsubquery_complex_target_list.sql72 min(value_3) * 2, max(value_3) / 2, sum(value_3), count(value_3), avg(value_3)
108 …SELECT sum(user_id * (5.0 / (value_1 + value_2 + 0.1)) * value_3) as cnt_1 FROM users_table ORDER …
135 SELECT COALESCE(value_3, 20) AS count_pay FROM users_table ORDER BY 1 OFFSET 20 LIMIT 5
152 SELECT avg(value_3) as avg FROM users_table GROUP BY value_1, value_2
155 SELECT avg(value_3) as avg2 FROM users_table GROUP BY value_1, value_2, user_id
202 … ORDER BY (sum(value_3) - avg(value_1) - COALESCE(array_upper(ARRAY[max(user_id)],1) * 5,0)) DESC
/dports/devel/rttr/rttr-0.9.6-16-gb3a131c/src/unit_tests/misc/
H A Denum_flags_test.cpp40 value_3 = 4, enumerator
94 f1 &= enum_test_flag::value_3;
110 f2 = f1 & enum_test_flag::value_3;
123 f1 |= enum_test_flag::value_3;
138 enum_test_flags f2 = f1 | enum_test_flag::value_3;
159 f1 ^= enum_test_flag::value_3;
171 enum_test_flags f3(enum_test_flag::value_3);
183 enum_test_flags f2 = f1 ^ enum_test_flag::value_3;
195 enum_test_flags f3(enum_test_flag::value_3);
214 CHECK(f2.test_flag(enum_test_flag::value_3) == true);
[all …]
/dports/www/osrm-backend/osrm-backend-5.26.0/unit_tests/util/
H A Dbit_range.cpp16 std::uint8_t value_3 = in BOOST_AUTO_TEST_CASE() local
21 CHECK_EQUAL_RANGE(makeBitRange<std::uint8_t>(value_3), 5, 4, 3, 2, 1, 0); in BOOST_AUTO_TEST_CASE()
23 BOOST_CHECK_EQUAL(makeBitRange<std::uint8_t>(value_3).size(), 6); in BOOST_AUTO_TEST_CASE()
31 std::uint16_t value_3 = in BOOST_AUTO_TEST_CASE() local
36 CHECK_EQUAL_RANGE(makeBitRange<std::uint16_t>(value_3), 5, 4, 3, 2, 1, 0); in BOOST_AUTO_TEST_CASE()
38 BOOST_CHECK_EQUAL(makeBitRange<std::uint16_t>(value_3).size(), 6); in BOOST_AUTO_TEST_CASE()
46 std::uint32_t value_3 = in BOOST_AUTO_TEST_CASE() local
51 CHECK_EQUAL_RANGE(makeBitRange<std::uint32_t>(value_3), 5, 4, 3, 2, 1, 0); in BOOST_AUTO_TEST_CASE()
53 BOOST_CHECK_EQUAL(makeBitRange<std::uint32_t>(value_3).size(), 6); in BOOST_AUTO_TEST_CASE()
61 std::uint64_t value_3 = in BOOST_AUTO_TEST_CASE() local
[all …]
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/
H A Dwith_prepare.out488 user_id | time | value_1 | value_2 | value_3 | value_4
635 user_id | time | value_1 | value_2 | value_3 | value_4
640 user_id | time | value_1 | value_2 | value_3 | value_4
645 user_id | time | value_1 | value_2 | value_3 | value_4
650 user_id | time | value_1 | value_2 | value_3 | value_4
655 user_id | time | value_1 | value_2 | value_3 | value_4
677 user_id | time | value_1 | value_2 | value_3 | value_4
682 user_id | time | value_1 | value_2 | value_3 | value_4
687 user_id | time | value_1 | value_2 | value_3 | value_4
692 user_id | time | value_1 | value_2 | value_3 | value_4
[all …]
H A Dmulti_reference_table.out109 value_1, value_3
116 value_1 | value_3
174 value_3 = '2' OR value_1 = 3;
187 value_3 = '2' OR value_1 = 3
202 value_3::FLOAT
218 value_3 IN
233 value_3 IN
426 value_3,
806 UPDATE SET value_3 = EXCLUDED.value_3, value_2 = EXCLUDED.value_2
1359 value_3 | text | value_3
[all …]
H A Dmulti_deparse_shard_query.out15 value_3 float,
33 value_3 float,
132 INSERT INTO raw_events_1 (value_3, tenant_id)
134 raw_events_2.value_3, raw_events_1.tenant_id
148 INSERT INTO raw_events_1 (value_3, tenant_id)
150 max(raw_events_2.value_3), avg(raw_events_1.value_3)
250 SELECT value_3, value_2, tenant_id
345 INSERT INTO raw_events_2(tenant_id, value_1, value_2, value_3, value_4)
347 tenant_id, value_1, value_2, value_3, value_4
350 value_2, value_4, tenant_id, value_1, value_3
[all …]
H A Dmulti_mx_reference_table.out86 value_1, value_3
93 value_1 | value_3
151 value_3 = '2' OR value_1 = 3;
164 value_3 = '2' OR value_1 = 3
179 value_3::FLOAT
195 value_3 IN
210 value_3 IN
374 value_1 | value_2 | value_3 | value_4
405 value_3,
410 GROUPING sets ((value_4), (value_3))
[all …]
H A Dmulti_shard_update_delete.out83 UPDATE users_test_table SET value_3 = 0;
93 UPDATE users_test_table SET value_3 = 1;
106 UPDATE users_test_table SET value_3 = 1;
117 UPDATE users_test_table SET value_3 = 5;
118 UPDATE users_test_table SET value_3 = 0;
402 value_3
424 value_3
453 SET value_3 = 1
492 SET value_3 = 5
548 WHERE ett.value_3 IN (SELECT utt.value_3
[all …]
H A Dwith_executors.out169 users_table.user_id as uid_2, users_table.value_3
175 users_table.value_3=events_table.value_3
178 uid_1, uid_2, value_2, value_3
184 value_2 = value_3
187 uid_1, uid_2, cte.value_2, cte.value_3
197 uid_1 | uid_2 | value_2 | value_3
233 SELECT uid_1, time, value_3 FROM task_tracker JOIN real_time ON val_2=value_3
247 SELECT DISTINCT uid_1, time, value_3 FROM cte ORDER BY 1, 2, 3 LIMIT 20;
248 uid_1 | time | value_3
275 SELECT uid_1, time, value_3 FROM task_tracker JOIN real_time ON val_2=value_3
[all …]
H A Dsubquery_in_where.out49 id | value_1 | value_3
900 …value_3 IN (SELECT min(value_3) v FROM users_table WHERE user_id = e.user_id GROUP BY e.value_2 HA…
908 value_3 IN (
911 GROUP BY e.value_2 HAVING min(r.value_3) > e.value_3);
923 value_3 IN (
926 GROUP BY e.value_2 HAVING min(r.value_3) > e.value_3);
934 value_3 IN (
937 GROUP BY e.value_2 HAVING min(r.value_3) > e.value_3);
945 value_3 IN (
948 GROUP BY u.value_2 HAVING min(r.value_3) > e.value_3);
[all …]
H A Disolation_multi_shard_modify_vs_all.out14 SELECT * FROM users_test_table ORDER BY value_2, value_3;
16 user_id|value_1|value_2|value_3
31 SELECT * FROM users_test_table ORDER BY value_2, value_3;
33 user_id|value_1|value_2|value_3
138 user_id|value_1|value_2|value_3
173 user_id|value_1|value_2|value_3
207 user_id|value_1|value_2|value_3
243 user_id|value_1|value_2|value_3
332 user_id|value_1|value_2|value_3
373 user_id|value_1|value_2|value_3
[all …]
H A Dmulti_subquery_union.out653 user_id, value_3
656 (SELECT value_3, user_id FROM users_table)
662 user_id | value_3
693 user_id, sum(value_3)
714 user_id, value_3
731 user_id | value_3
742 max(value_3)
1093 user_id, value_3
1110 user_id | value_3
1163 user_id, value_3
[all …]
/dports/cad/opencascade/opencascade-7.6.0/tests/bugs/heal/
H A Dbug2664221 set value_3 [lindex $bug_info 1]
22 set value_3 [string trim [string range $value_3 [expr {[string first "=" $value_3] + 1}] [expr {[st…
30 if {$value_1 > $value_3} {
31 set diff_13 [expr {$value_1 - $value_3}]
33 set diff_13 [expr {$value_3 - $value_1}]
/dports/games/stendhal/stendhal-1.35/tests/games/stendhal/server/entity/mapstuff/spawner/
H A DPassiveEntityRespawnPointFactoryTest.java113 PassiveEntityRespawnPoint value_3 = PassiveEntityRespawnPointFactory in testCreateMushroom() local
115 assertNull(value_3); in testCreateMushroom()
144 PassiveEntityRespawnPoint value_3 = PassiveEntityRespawnPointFactory in testCreateResource() local
146 assertNotNull(value_3); in testCreateResource()
148 value_3.getDescription()); in testCreateResource()
206 PassiveEntityRespawnPoint value_3 = PassiveEntityRespawnPointFactory in testCreateVegetable() local
208 assertNotNull(value_3); in testCreateVegetable()
209 assertTrue(value_3 instanceof VegetableGrower); in testCreateVegetable()
303 assertNull(value_3); in testCreateJewelry()
373 assertNotNull(value_3); in testCreateMeatAndFish()
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/rapid/unittest/gunit/xplugin/
H A Dupdate_statement_builder_t.cc85 const std::string value_3 = value_ + "V_SINT v_signed_int: -3}}"; variable
394 *operation.Add() << source_third + "operation: ITEM_SET " + value_3; in TEST_F()
443 + value_3; in TEST_F()
454 + value_3; in TEST_F()
465 + value_3; in TEST_F()
475 operation << "source {} operation: ITEM_SET " + value_3; in TEST_F()
496 "operation: ITEM_SET " + value_3; in TEST_F()
508 "operation: ITEM_SET " + value_3; in TEST_F()
518 operation << source_index_0 + "operation: ITEM_SET " + value_3; in TEST_F()
529 "operation: ITEM_SET " + value_3; in TEST_F()
[all …]

12345678910>>...12