diff options
| author | Tomas Vondra | 2025-06-17 12:14:36 +0000 |
|---|---|---|
| committer | Tomas Vondra | 2025-06-17 12:14:54 +0000 |
| commit | c89d6b889ce958dcab27b0342eca36634c0fefaf (patch) | |
| tree | dcf57e665821d4071f334ecdd66142544ef1dd28 /contrib/amcheck/sql | |
| parent | 6f55fb741147c49dc20dd2e4597363b2cc04acb4 (diff) | |
amcheck: Test gin_index_check on a multicolumn index
Adds a regression test with gin_index_check() on a multicolumn index,
to verify it's handled correctly and improve test coverage for code
introduced by 14ffaece0fb5.
Author: Arseniy Mukhin <[email protected]>
Reviewed-by: Andrey M. Borodin <[email protected]>
Discussion: https://postgr.es/m/CAE7r3MJ611B9TE=YqBBncewp7-k64VWs+sjk7XF6fJUX77uFBA@mail.gmail.com
Diffstat (limited to 'contrib/amcheck/sql')
| -rw-r--r-- | contrib/amcheck/sql/check_gin.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/contrib/amcheck/sql/check_gin.sql b/contrib/amcheck/sql/check_gin.sql index 66f42c34311..11caed3d6a8 100644 --- a/contrib/amcheck/sql/check_gin.sql +++ b/contrib/amcheck/sql/check_gin.sql @@ -50,3 +50,13 @@ SELECT gin_index_check('gin_check_jsonb_idx'); -- cleanup DROP TABLE gin_check_jsonb; + +-- Test GIN multicolumn index +CREATE TABLE "gin_check_multicolumn"(a text[], b text[]); +INSERT INTO gin_check_multicolumn (a,b) values ('{a,c,e}','{b,d,f}'); +CREATE INDEX "gin_check_multicolumn_idx" on gin_check_multicolumn USING GIN(a,b); + +SELECT gin_index_check('gin_check_multicolumn_idx'); + +-- cleanup +DROP TABLE gin_check_multicolumn; |