Commit8423bf4

committed

chkpass: Add test suite

Reviewed-by: David Steele <david@pgmasters.net>

1 parent4cb89d8 commit8423bf4Copy full SHA for 8423bf4

File tree

+31

-0

lines changed

+31

-0

lines changed

Lines changed: 4 additions & 0 deletions

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -9,6 +9,8 @@ PGFILEDESC = "chkpass - encrypted password data type"`
`9`	`9`
`10`	`10`	`SHLIB_LINK =$(filter -lcrypt,$(LIBS))`
`11`	`11`
	`12`	`+REGRESS = chkpass`
	`13`	`+`
`12`	`14`	`ifdefUSE_PGXS`
`13`	`15`	`PG_CONFIG = pg_config`
`14`	`16`	`PGXS :=$(shell$(PG_CONFIG) --pgxs)`

Lines changed: 18 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,18 @@`
	`1`	`+CREATE EXTENSION chkpass;`
	`2`	`+WARNING: type input function chkpass_in should not be volatile`
	`3`	`+CREATE TABLE test (i int, p chkpass);`
	`4`	`+INSERT INTO test VALUES (1, 'hello'), (2, 'goodbye');`
	`5`	`+SELECT i, p = 'hello' AS "hello?" FROM test;`
	`6`	`+ i \| hello?`
	`7`	`+---+--------`
	`8`	`+ 1 \| t`
	`9`	`+ 2 \| f`
	`10`	`+(2 rows)`
	`11`	`+`
	`12`	`+SELECT i, p <> 'hello' AS "!hello?" FROM test;`
	`13`	`+ i \| !hello?`
	`14`	`+---+---------`
	`15`	`+ 1 \| f`
	`16`	`+ 2 \| t`
	`17`	`+(2 rows)`
	`18`	`+`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,7 @@`
	`1`	`+CREATE EXTENSION chkpass;`
	`2`	`+`
	`3`	`+CREATETABLEtest (iint, p chkpass);`
	`4`	`+INSERT INTO testVALUES (1,'hello'), (2,'goodbye');`
	`5`	`+`
	`6`	`+SELECT i, p='hello'AS"hello?"FROM test;`
	`7`	`+SELECT i, p<>'hello'AS"!hello?"FROM test;`

Comments

(0)