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

Commitceca992

Browse files
committed
Fix regression tests about opclass rename.
1 parent007383f commitceca992

File tree

2 files changed

+4
-4
lines changed

2 files changed

+4
-4
lines changed

‎expected/jsquery.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1099,7 +1099,7 @@ select count(*) from test_jsquery where v @@ 'product_group = false';
10991099
1
11001100
(1 row)
11011101

1102-
create index t_idx on test_jsquery using gin (vjsonb_bloom_value_ops);
1102+
create index t_idx on test_jsquery using gin (vjsonb_value_path_ops);
11031103
set enable_seqscan = off;
11041104
explain (costs off) select count(*) from test_jsquery where v @@ 'review_helpful_votes > 0';
11051105
QUERY PLAN
@@ -1209,7 +1209,7 @@ select count(*) from test_jsquery where v @@ 'product_group = false';
12091209
(1 row)
12101210

12111211
drop index t_idx;
1212-
create index t_idx on test_jsquery using gin (vjsonb_hash_value_ops);
1212+
create index t_idx on test_jsquery using gin (vjsonb_path_value_ops);
12131213
set enable_seqscan = off;
12141214
explain (costs off) select count(*) from test_jsquery where v @@ 'review_helpful_votes > 0';
12151215
QUERY PLAN

‎sql/jsquery.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -223,7 +223,7 @@ select count(*) from test_jsquery where v @@ 'customer_id = null';
223223
selectcount(*)from test_jsquerywhere v @@'review_votes = true';
224224
selectcount(*)from test_jsquerywhere v @@'product_group = false';
225225

226-
createindext_idxon test_jsquery using gin (vjsonb_bloom_value_ops);
226+
createindext_idxon test_jsquery using gin (vjsonb_value_path_ops);
227227
set enable_seqscan= off;
228228

229229
explain (costs off)selectcount(*)from test_jsquerywhere v @@'review_helpful_votes > 0';
@@ -248,7 +248,7 @@ select count(*) from test_jsquery where v @@ 'product_group = false';
248248

249249
dropindex t_idx;
250250

251-
createindext_idxon test_jsquery using gin (vjsonb_hash_value_ops);
251+
createindext_idxon test_jsquery using gin (vjsonb_path_value_ops);
252252
set enable_seqscan= off;
253253

254254
explain (costs off)selectcount(*)from test_jsquerywhere v @@'review_helpful_votes > 0';

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp