Commitfbcf580

Mikhail Samoylov

authored and

committed

Tests for BUG PGPRO-818

This simple tests for btree index and hash index creating and changing column size

1 parentf32fa55 commitfbcf580Copy full SHA for fbcf580

File tree

+27

-0

lines changed

+27

-0

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3098,3 +3098,15 @@ Table "public.test_add_column"`
`3098`	`3098`	`c4 \| integer \|`
`3099`	`3099`
`3100`	`3100`	`DROP TABLE test_add_column;`
	`3101`	`+`
	`3102`	`+CREATE TABLE test (test_column CHARACTER VARYING(128));`
	`3103`	`+CREATE INDEX test_index ON test USING btree(upper(test_column));`
	`3104`	`+ALTER TABLE test ALTER COLUMN test_column TYPE VARCHAR(2048);`
	`3105`	`+DROP TABLE test;`
	`3106`	`+`
	`3107`	`+CREATE TABLE test (test_column CHARACTER VARYING(128));`
	`3108`	`+CREATE INDEX test_index ON test USING HASH(upper(test_column));`
	`3109`	`+WARNING: hash indexes are not WAL-logged and their use is discouraged`
	`3110`	`+ALTER TABLE test ALTER COLUMN test_column TYPE VARCHAR(2048);`
	`3111`	`+WARNING: hash indexes are not WAL-logged and their use is discouraged`
	`3112`	`+DROP TABLE test;`

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1950,3 +1950,18 @@ ALTER TABLE test_add_column`
`1950`	`1950`	`ADD COLUMN c4integer;`
`1951`	`1951`	`\d test_add_column`
`1952`	`1952`	`DROPTABLE test_add_column;`
	`1953`	`+`
	`1954`	`+-- test CHANGE COLUMN SIZE WITH BTREE INDEX`
	`1955`	`+CREATETABLEtest (test_columnCHARACTER VARYING(128));`
	`1956`	`+CREATEINDEXtest_indexON test USING btree(upper(test_column);`
	`1957`	`+ALTERTABLE test ALTER COLUMN test_column TYPEVARCHAR(2048);`
	`1958`	`+DROPTABLE test;`
	`1959`	`+`
	`1960`	`+-- test CHANGE COLUMN SIZE WITH HASH INDEX`
	`1961`	`+CREATETABLEtest (test_columnCHARACTER VARYING(128));`
	`1962`	`+CREATEINDEXtest_indexON test USING HASH(upper(test_column));`
	`1963`	`+ALTERTABLE test ALTER COLUMN test_column TYPEVARCHAR(2048);`
	`1964`	`+DROPTABLE test;`
	`1965`	`+`
	`1966`	`+`
	`1967`	`+`

Comments

(0)