Home
last modified time | relevance | path

Searched refs:user_id (Results 1 – 25 of 1775) sorted by relevance

12345678910>>...71

/dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/
H A Dmulti_behavioral_analytics_single_shard_queries.sql16 WHERE u.user_id = e.user_id
43 WHERE u.user_id = e.user_id AND
45 (e.user_id = 1 OR e.user_id = 2)
50 WHERE (user_id = 1 OR user_id = 2);
74 WHERE u.user_id = e.user_id
84 WHERE u.user_id = e.user_id
97 ) t2 ON (t1.user_id = t2.user_id)
122 WHERE u.user_id = e.user_id
131 WHERE u.user_id = e.user_id
143 ) t2 ON (t1.user_id = t2.user_id)
[all …]
H A Dunion_pushdown.sql44 (SELECT user_id AS user_id
56 (SELECT user_id AS user_id
68 (SELECT user_id AS user_id
74 SELECT user_id AS user_id
90 (SELECT user_id AS user_id
96 SELECT user_id AS user_id
112 (SELECT user_id AS user_id
119 SELECT user_id AS user_id
133 (SELECT user_id AS user_id
140 SELECT user_id AS user_id
[all …]
H A Dmulti_insert_select_window.sql99 users_table.user_id = events_table.user_id and
117 users_table.user_id = events_table.user_id and
136 users_table.user_id = events_table.user_id and
148 users_table.user_id = events_table.user_id and
153 ON(sub_1.user_id = sub_2.user_id)
266 user_id
277 users_table.user_id = events_table.user_id
280 user_id;
344 f3.user_id=f2.user_id
450 user_id
[all …]
H A Dmulti_behavioral_analytics_basics.sql14 WHERE u.user_id = e.user_id
43 WHERE u.user_id = e.user_id
53 WHERE u.user_id = e.user_id
66 ) t2 ON (t1.user_id = t2.user_id)
80 user_id,
133 subquery_1.user_id = subquery_2.user_id
178 WHERE user_id = u.user_id AND
409 ON users_table.user_id = temp.user_id
431 ON users_ids.user_id = temp.user_id
453 ON users_ids.user_id = temp.user_id
[all …]
H A Dmulti_subquery_in_where_clause.sql100 e1.user_id = e2.user_id
117 e1.user_id = e2.user_id
179 user_id = e1.user_id AND
189 user_id = e2.user_id AND
199 user_id = e3.user_id AND
207 user_id = e4.user_id AND
302 WHERE u.user_id = e.user_id AND
348 user_id = e1.user_id AND
358 user_id = e2.user_id AND
376 user_id = e4.user_id AND
[all …]
H A Dmulti_subquery_union.sql15 ) user_id
22 SELECT user_id, max(value_2) FROM users_table WHERE user_id = 1 GROUP BY user_id
24 SELECT user_id, max(value_2) FROM users_table WHERE user_id = 5 GROUP BY user_id
25 ) user_id
35 ) user_id
45 ) user_id
55 ) user_id
65 ) user_id
76 ) user_id
87 ) user_id
[all …]
H A Dsubquery_in_targetlist.sql121 SELECT sum(e.user_id) + (SELECT max(value_3) FROM users_table WHERE user_id = e.user_id GROUP BY us…
137 …ECT e.user_id, sum((SELECT any_value(value_3) FROM users_reference_table WHERE user_id = e.user_id…
153 SELECT (SELECT (SELECT user_id + 2) * 2 FROM users_table WHERE user_id = e.user_id GROUP BY user_id)
159 SELECT (SELECT (SELECT e.user_id + user_id) FROM users_table WHERE user_id = e.user_id GROUP BY use…
165 SELECT (SELECT (SELECT e.user_id + user_id) FROM users_reference_table WHERE user_id = e.user_id GR…
172 SELECT (SELECT (SELECT e.user_id + user_id) FROM cte_1 WHERE user_id = e.user_id GROUP BY user_id)
178 SELECT (SELECT (SELECT e.user_id + user_id) FROM (SELECT 1 AS user_id) s WHERE user_id = e.user_id …
205 SELECT (SELECT (SELECT e.user_id + user_id) FROM view_1 WHERE user_id = e.user_id GROUP BY user_id)
287 (SELECT sum(user_id) FROM users_table WHERE user_id = u1.user_id GROUP BY user_id)
342 SELECT (SELECT DISTINCT user_id FROM users_table WHERE user_id = (SELECT max(user_id) FROM users_ta…
[all …]
H A Dmulti_subquery_behavioral_analytics.sql25 WHERE u.user_id = e.user_id
49 WHERE u.user_id = e.user_id
717 ON a.user_id = b.user_id
754 user_id = e1.user_id AND user_id = 1 and
765 user_id = e2.user_id AND user_id = 1 and
776 user_id = e3.user_id AND user_id = 1 and
785 user_id = e4.user_id AND user_id = 1 and
941 ON a.user_id = b.user_id
969 ON a.user_id = b.user_id
1003 ON a.user_id = b.user_id
[all …]
H A Dwith_basics.sql21 user_id IN (SELECT user_id FROM users_table)
33 SELECT max(user_id) AS user_id FROM cte_1_1
35 SELECT user_id FROM cte_1_2 ORDER BY user_id
75 (SELECT user_id FROM cte_basic), user_id
97 user_id
125 user_id
131 user_id
140 user_id
146 user_id
613 WHERE d1.user_id = d2.user_id )) AS bar USING (user_id);
[all …]
H A Dnon_colocated_subquery_joins.sql91 foo.user_id = bar.user_id AND
107 foo.user_id = bar.user_id AND
121 foo.user_id = bar.user_id AND
136 foo.user_id = bar.user_id AND
175 foo1.user_id = foo4.user_id AND
176 foo1.user_id = foo2.user_id AND
177 foo1.user_id = foo3.user_id AND
178 foo1.user_id = foo4.user_id AND
207 foo1.user_id = foo5.user_id
467 WHERE u.user_id = e.user_id AND
[all …]
H A Dmulti_insert_select_non_pushable_queries.sql16 WHERE u.user_id != e.user_id
44 WHERE u.user_id != e.user_id
54 WHERE u.user_id = e.user_id
68 ) t2 ON (t1.user_id = t2.user_id)
86 WHERE u.user_id = e.user_id
110 ) t2 ON (t1.user_id = t2.user_id)
130 WHERE u.user_id = e.user_id
140 WHERE u.user_id = e.user_id
154 ) t2 ON (t1.user_id = (t2.user_id)/2)
334 WHERE user_id != u.user_id AND
[all …]
H A Dmulti_subquery_in_where_reference_clause.sql6 user_id
100 s = user_id AND user_id > one AND
226 user_id = e1.user_id AND
236 user_id = e2.user_id AND
246 user_id = e3.user_id AND
254 user_id = e4.user_id AND
288 user_id = e1.user_id AND
298 user_id = e2.user_id AND
308 user_id = e3.user_id AND
316 user_id = e4.user_id AND
[all …]
H A Dmulti_subquery_window_functions.sql102 users_table.user_id = events_table.user_id and
117 users_table.user_id = events_table.user_id and
133 users_table.user_id = events_table.user_id and
145 users_table.user_id = events_table.user_id and
150 ON(sub_1.user_id = sub_2.user_id)
227 user_id as user_id, time, rank() over w1
363 user_id
374 users_table.user_id = events_table.user_id
377 user_id
421 f3.user_id=f2.user_id
[all …]
H A Dmulti_subquery_complex_queries.sql68 ON (t.user_id = q.user_id)) as final_query
126 ON (t.user_id = q.user_id)) as final_query
895 ON (t2.user_id = t.user_id) WHERE t2.user_id is NULL) as second_query
970 ON (t2.user_id > t.user_id) WHERE t2.user_id is NULL) as second_query
1047 ON (t2.user_id = t.user_id) WHERE t2.user_id is NULL) as second_query
1290 user_id > 1 and user_id < 3 and user_id = filter_users_1.user_id
1344 user_id > 1 and user_id < 4 and user_id = filter_users_1.user_id
1402 user_id > 1 and user_id < 4 and user_id = filter_users_1.user_id
1460 user_id > 1 and user_id < 3 and user_id != filter_users_1.user_id
1514 user_id > 1 and user_id < 3 and user_id = filter_users_1.user_id
[all …]
H A Dmulti_insert_select.sql81 user_id
197 user_id = 9 OR user_id = 16
315 WHERE user_id IN (SELECT user_id
323 WHERE user_id IN (SELECT user_id
332 WHERE user_id IN (SELECT user_id
339 WHERE user_id IN (SELECT user_id
451 ON t1.user_id = t2.user_id
463 ON t1.user_id = t2.user_id;
511 DISTINCT ON (user_id) value_1, user_id
543 user_id
[all …]
H A Dwindow_functions.sql8 user_id, COUNT(*) OVER (PARTITION BY user_id),
57 ON (us.user_id = ev.user_id)
118 user_id, count (user_id) OVER (PARTITION BY user_id)
132 users_table.user_id = events_table.user_id
249 user_id > 2 AND user_id < 6
262 user_id > 2 AND user_id < 6
278 user_id > 2 and user_id < 6
388 DISTINCT ON (user_id) user_id, SUM(value_2) OVER (PARTITION BY user_id)
415 AVG(avg(user_id)) OVER (PARTITION BY user_id, min(user_id), AVG(value_1))
428 AVG(avg(user_id)) OVER (PARTITION BY user_id, min(user_id), AVG(value_1))
[all …]
H A Dmulti_subquery_complex_reference_clause.sql78 ON tt1.user_id = tt2.user_id) subquery_1
81 ON tt1.user_id = ref.id) subquery_2 ON subquery_1.user_id = subquery_2.user_id;
100 ON tt1.user_id = tt2.user_id) subquery_1
106 ON subquery_1.user_id = subquery_2.user_id
534 user_id > 0 and user_id < 5 AND
778 WHERE u.user_id > e.user_id
790 ) t2 ON (t1.user_id = t2.user_id)
819 ) t2 ON (t1.user_id = t2.user_id)
1161 AND u1.user_id > e1.user_id
1186 GROUP BY r.user_id, m.user_id
[all …]
H A Dwith_set_operations.sql49 ((SELECT user_id FROM events_table WHERE user_id < 3) EXCEPT (SELECT user_id FROM users_table WHERE…
61 SELECT user_id FROM events_table WHERE user_id < 2)
64 users_table.user_id = foo.user_id
82 (SELECT DISTINCT events_table.user_id FROM users_table, events_table WHERE users_table.user_id = ev…
84 (SELECT DISTINCT events_table.user_id FROM users_table, events_table WHERE users_table.user_id = ev…
112 …((SELECT DISTINCT events_table.user_id FROM users_table, events_table WHERE users_table.user_id = …
116 foo.user_id = events_table.user_id;
172 DISTINCT user_id
186 WHERE users_table.value_2 = foo.user_id AND events_table.user_id = users_table.user_id
193 DISTINCT user_id
[all …]
H A Dmulti_shard_update_delete.sql274 WHERE user_id IN (SELECT user_id
278 WHERE user_id IN (SELECT user_id
296 WHERE user_id IN (SELECT user_id
304 WHERE user_id IN (SELECT user_id
312 WHERE user_id IN (SELECT user_id
369 user_id = e1.user_id
421 WHERE utt.user_id = uct.user_id AND utt.user_id = ett.user_id);
520 WHERE user_id IN (SELECT user_id
528 WHERE user_id IN (SELECT user_id
593 WHERE users_test_table.user_id = subquery.user_id;
[all …]
H A Dsubquery_in_where.sql86 user_id
126 user_id
418 min(user_id) + 1, min(user_id) + 1
720 WHERE u.user_id = e.user_id AND
734 WHERE e1.user_id = u1.user_id
785 e1.user_id = u2.user_id) > 10;
793 u1.user_id, u2.user_id
803 e1.user_id = u2.user_id AND
804 u1.user_id = u2.user_id) > 10
814 WHERE e1.user_id = u1.user_id
[all …]
H A Dsubquery_basics.sql31 min(user_id)
44 user_id
51 users_table.user_id = events_table.user_id AND
68 users_table.user_id = events_table.user_id AND
84 users_table.user_id = events_table.user_id AND
146 users_table.user_id = events_table.user_id AND
242 WHERE baz.user_id = users_table.user_id
259 WHERE u.user_id = e.user_id AND
279 user_id
338 subquery_1.user_id = subquery_2.user_id
[all …]
H A Dsubquery_local_tables.sql17 foo.user_id
33 users_table.user_id = events_table.user_id AND
38 WHERE bar.user_id = foo.user_id
59 users_table.user_id = events_table.user_id AND
62 WHERE bar.user_id = foo.user_id
91 WHERE baz.user_id = users_table.user_id
110 WHERE u.user_id = e.user_id AND
131 user_id
135 user_id IN
138 user_id
[all …]
H A Dsubquery_and_cte.sql44 WHERE foo.user_id = cte.user_id;
63 SELECT cte1.user_id, cte1.value_1, cte2.user_id, cte2.user_id
123 WHERE foo.user_id = cte.user_id AND events_table.user_id = cte.user_id;
140 users_table.user_id = cte.user_id AND
206 WHERE foo.user_id = bar.user_id
248 WHERE foo.user_id = bar.user_id
270 users_table.user_id = cte.user_id AND
312 WHERE foo.user_id = cte.user_id;
349 WHERE foo.user_id = cte.user_id
380 WHERE foo.user_id = bar.user_id
[all …]
H A Dmulti_orderby_limit_pushdown.sql11 GROUP BY user_id
17 GROUP BY user_id
24 GROUP BY user_id
30 GROUP BY user_id
36 GROUP BY user_id
42 GROUP BY user_id
151 WHERE ut.user_id = et.user_id and et.value_2 < 5
159 WHERE ut.user_id = et.user_id and et.value_2 < 5
167 WHERE ut.user_id = et.user_id and et.value_2 < 5
174 WHERE ut.user_id = et.user_id and et.value_2 < 5
[all …]
H A Dmulti_subquery_misc.sql13 user_id,
31 WHERE user_id = u.user_id AND
61 WHERE user_id = u.user_id AND
115 ON users_table.user_id = temp.user_id
146 ON users_table.user_id = temp.user_id
173 ) t2 ON t1.user_id = t2.user_id
179 ) t3 ON t1.user_id = t3.user_id
202 ) t2 ON t1.user_id = t2.user_id
208 ) t3 ON t1.user_id = t3.user_id
229 ) t2 ON t1.user_id = t2.user_id
[all …]

12345678910>>...71