diff options
Diffstat (limited to 'src/test/regress/sql/brin.sql')
| -rw-r--r-- | src/test/regress/sql/brin.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/regress/sql/brin.sql b/src/test/regress/sql/brin.sql index 929a087a25d..0d3beabb3d7 100644 --- a/src/test/regress/sql/brin.sql +++ b/src/test/regress/sql/brin.sql @@ -515,3 +515,10 @@ CREATE UNLOGGED TABLE brintest_unlogged (n numrange); CREATE INDEX brinidx_unlogged ON brintest_unlogged USING brin (n); INSERT INTO brintest_unlogged VALUES (numrange(0, 2^1000::numeric)); DROP TABLE brintest_unlogged; + +-- test that the insert optimization works if no rows end up inserted +CREATE TABLE brin_insert_optimization (a int); +INSERT INTO brin_insert_optimization VALUES (1); +CREATE INDEX ON brin_insert_optimization USING brin (a); +UPDATE brin_insert_optimization SET a = a; +DROP TABLE brin_insert_optimization; |