Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitadc5fdf

Browse files
author
Alexander Korotkov
committed
Forgotten regression tests output for filters handling in indexes.
1 parent8362a5e commitadc5fdf

File tree

1 file changed

+73
-5
lines changed

1 file changed

+73
-5
lines changed

‎expected/jsquery.out‎

Lines changed: 73 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -2172,6 +2172,22 @@ SELECT gin_debug_query_path_value('$ = true');
21722172

21732173
(1 row)
21742174

2175+
SELECT gin_debug_query_path_value('$ . ? (review_votes > 10) . review_rating < 7');
2176+
gin_debug_query_path_value
2177+
--------------------------------
2178+
AND +
2179+
review_rating < 7 , entry 0 +
2180+
review_votes > 10 , entry 1 +
2181+
2182+
(1 row)
2183+
2184+
SELECT gin_debug_query_path_value('similar_product_ids . ? (# = "B0002W4TL2") . $');
2185+
gin_debug_query_path_value
2186+
-------------------------------------------------
2187+
similar_product_ids.# = "B0002W4TL2" , entry 0 +
2188+
2189+
(1 row)
2190+
21752191
SELECT gin_debug_query_value_path('NOT NOT NOT x(y(NOT (a=1) and NOT (b=2)) OR NOT NOT (c=3)) and z = 5');
21762192
gin_debug_query_value_path
21772193
----------------------------
@@ -2376,19 +2392,35 @@ SELECT gin_debug_query_value_path('*.@# ($ = 4 or $ = 2)');
23762392
(1 row)
23772393

23782394
SELECT gin_debug_query_value_path('tags.#.term. ? ( # = "NYC").x > 0');
2379-
gin_debug_query_value_path
2380-
------------------------------
2381-
tags.#.term.x > 0 , entry 0 +
2395+
gin_debug_query_value_path
2396+
----------------------------------
2397+
tags.#.term.# = "NYC" , entry 0 +
23822398

23832399
(1 row)
23842400

2385-
SELECTgin_debug_query_path_value('$ = true');
2386-
gin_debug_query_path_value
2401+
SELECTgin_debug_query_value_path('$ = true');
2402+
gin_debug_query_value_path
23872403
----------------------------
23882404
$ = true , entry 0 +
23892405

23902406
(1 row)
23912407

2408+
SELECT gin_debug_query_value_path('$ . ? (review_votes > 10) . review_rating < 7');
2409+
gin_debug_query_value_path
2410+
--------------------------------
2411+
AND +
2412+
review_rating < 7 , entry 0 +
2413+
review_votes > 10 , entry 1 +
2414+
2415+
(1 row)
2416+
2417+
SELECT gin_debug_query_value_path('similar_product_ids . ? (# = "B0002W4TL2") . $');
2418+
gin_debug_query_value_path
2419+
-------------------------------------------------
2420+
similar_product_ids.# = "B0002W4TL2" , entry 0 +
2421+
2422+
(1 row)
2423+
23922424
---table and index
23932425
select count(*) from test_jsquery where (v->>'review_helpful_votes')::int4 > 0;
23942426
count
@@ -2656,6 +2688,18 @@ select count(*) from test_jsquery where v @@ 'similar_product_ids.#';
26562688
1001
26572689
(1 row)
26582690

2691+
select count(*) from test_jsquery where v @@ '$ . ? (review_votes > 10) . review_rating < 7';
2692+
count
2693+
-------
2694+
79
2695+
(1 row)
2696+
2697+
select count(*) from test_jsquery where v @@ 'similar_product_ids . ? (# = "B0002W4TL2") . $';
2698+
count
2699+
-------
2700+
3
2701+
(1 row)
2702+
26592703
select v from test_jsquery where v @@ 'array <@ [2,3]' order by v;
26602704
v
26612705
-------------------
@@ -2922,6 +2966,18 @@ select count(*) from test_jsquery where v @@ 'similar_product_ids.#';
29222966
1001
29232967
(1 row)
29242968

2969+
select count(*) from test_jsquery where v @@ '$ . ? (review_votes > 10) . review_rating < 7';
2970+
count
2971+
-------
2972+
79
2973+
(1 row)
2974+
2975+
select count(*) from test_jsquery where v @@ 'similar_product_ids . ? (# = "B0002W4TL2") . $';
2976+
count
2977+
-------
2978+
3
2979+
(1 row)
2980+
29252981
explain (costs off) select v from test_jsquery where v @@ 'array <@ [2,3]' order by v;
29262982
QUERY PLAN
29272983
---------------------------------------------------------------
@@ -3233,6 +3289,18 @@ select count(*) from test_jsquery where v @@ 'similar_product_ids.#';
32333289
950
32343290
(1 row)
32353291

3292+
select count(*) from test_jsquery where v @@ '$ . ? (review_votes > 10) . review_rating < 7';
3293+
count
3294+
-------
3295+
79
3296+
(1 row)
3297+
3298+
select count(*) from test_jsquery where v @@ 'similar_product_ids . ? (# = "B0002W4TL2") . $';
3299+
count
3300+
-------
3301+
3
3302+
(1 row)
3303+
32363304
explain (costs off) select v from test_jsquery where v @@ 'array <@ [2,3]' order by v;
32373305
QUERY PLAN
32383306
---------------------------------------------------------------

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp