diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2015-06-04 15:24:22 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2015-06-04 15:24:22 -0400 |
| commit | 1676e4381f48f7bf211f0965ad23abe10a683818 (patch) | |
| tree | e0d4827e3d0fffde5f1e319fba9a21bc31fdd312 | |
| parent | 79454c696bd3346a9f00f5e940398fb01a337fad (diff) | |
| download | postgresql-1676e4381f48f7bf211f0965ad23abe10a683818.tar.gz postgresql-1676e4381f48f7bf211f0965ad23abe10a683818.zip | |
Fix brin regression test so it actually tests cidr.
The problem noted in my previous commit was simpler than I thought:
we weren't getting an index plan because the column wasn't indexed.
| -rw-r--r-- | src/test/regress/expected/brin.out | 30 | ||||
| -rw-r--r-- | src/test/regress/sql/brin.sql | 2 |
2 files changed, 4 insertions, 28 deletions
diff --git a/src/test/regress/expected/brin.out b/src/test/regress/expected/brin.out index 272db274aaf..0937b63667c 100644 --- a/src/test/regress/expected/brin.out +++ b/src/test/regress/expected/brin.out @@ -77,6 +77,8 @@ CREATE INDEX brinidx ON brintest USING brin ( macaddrcol, inetcol inet_inclusion_ops, inetcol inet_minmax_ops, + cidrcol inet_inclusion_ops, + cidrcol inet_minmax_ops, bpcharcol, datecol, timecol, @@ -373,34 +375,6 @@ BEGIN END LOOP; END; $x$; -WARNING: did not get bitmap indexscan plan for (cidrcol,&&,inet,10/8,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,=,inet,10.2.14/24,2) -WARNING: did not get bitmap indexscan plan for (cidrcol,<,inet,255.255.255.255,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,<=,inet,255.255.255.255,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,>,inet,0.0.0.0,125) -WARNING: did not get bitmap indexscan plan for (cidrcol,>=,inet,0.0.0.0,125) -WARNING: did not get bitmap indexscan plan for (cidrcol,>>=,inet,10.2.14.231/24,2) -WARNING: did not get bitmap indexscan plan for (cidrcol,>>,inet,10.2.14.231/25,2) -WARNING: did not get bitmap indexscan plan for (cidrcol,<<=,inet,10.2.14.231/8,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,<<,inet,0/0,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,&&,inet,fe80::6e40:8ff:fea9:a673/32,25) -WARNING: did not get bitmap indexscan plan for (cidrcol,>>=,inet,fe80::6e40:8ff:fea9:8c46,1) -WARNING: did not get bitmap indexscan plan for (cidrcol,<<=,inet,fe80::6e40:8ff:fea9:a673/32,25) -WARNING: did not get bitmap indexscan plan for (cidrcol,=,inet,fe80::6e40:8ff:fea9:8c46,1) -WARNING: did not get bitmap indexscan plan for (cidrcol,&&,cidr,10/8,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,=,cidr,10.2.14/24,2) -WARNING: did not get bitmap indexscan plan for (cidrcol,<,cidr,255.255.255.255,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,<=,cidr,255.255.255.255,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,>,cidr,0.0.0.0,125) -WARNING: did not get bitmap indexscan plan for (cidrcol,>=,cidr,0.0.0.0,125) -WARNING: did not get bitmap indexscan plan for (cidrcol,>>=,cidr,10.2.14/24,2) -WARNING: did not get bitmap indexscan plan for (cidrcol,>>,cidr,10.2.14/25,2) -WARNING: did not get bitmap indexscan plan for (cidrcol,<<=,cidr,10/8,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,<<,cidr,0/0,100) -WARNING: did not get bitmap indexscan plan for (cidrcol,&&,cidr,fe80::/32,25) -WARNING: did not get bitmap indexscan plan for (cidrcol,>>=,cidr,fe80::6e40:8ff:fea9:8c46,1) -WARNING: did not get bitmap indexscan plan for (cidrcol,<<=,cidr,fe80::/32,25) -WARNING: did not get bitmap indexscan plan for (cidrcol,=,cidr,fe80::6e40:8ff:fea9:8c46,1) INSERT INTO brintest SELECT repeat(stringu1, 42)::bytea, substr(stringu1, 1, 1)::"char", diff --git a/src/test/regress/sql/brin.sql b/src/test/regress/sql/brin.sql index a4b56b40447..db78d05ff3f 100644 --- a/src/test/regress/sql/brin.sql +++ b/src/test/regress/sql/brin.sql @@ -80,6 +80,8 @@ CREATE INDEX brinidx ON brintest USING brin ( macaddrcol, inetcol inet_inclusion_ops, inetcol inet_minmax_ops, + cidrcol inet_inclusion_ops, + cidrcol inet_minmax_ops, bpcharcol, datecol, timecol, |