Commitf15eeff

Thomas G. Lockhart

committed

Modify to reflect changes in boolean input behavior (rejects bad input

rather than assuming FALSE).

1 parentac357fb commitf15eeffCopy full SHA for f15eeff

File tree

-2

lines changed

-2

lines changed

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -98,8 +98,11 @@ QUERY: CREATE TABLE BOOLTBL2 (f1 bool);`
`98`	`98`	`QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('f'::bool);`
`99`	`99`	`QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('false'::bool);`
`100`	`100`	`QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('False'::bool);`
	`101`	`+QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('FALSE'::bool);`
`101`	`102`	`QUERY: INSERT INTO BOOLTBL2 (f1)`
`102`	`103`	`VALUES ('XXX'::bool);`
	`104`	`+WARN:Invalid input string 'XXX'`
	`105`	`+`
`103`	`106`	`QUERY: SELECT '' AS f_4, BOOLTBL2.*;`
`104`	`107`	`f_4\|f1`
`105`	`108`	`---+--`

Lines changed: 5 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`	`--`
`2`	`2`	`-- boolean.source`
`3`	`3`	`--`
`4`		`--- $Header: /cvsroot/pgsql/src/test/regress/sql/boolean.sql,v 1.3 1997/05/09 03:26:43 scrappy Exp $`
	`4`	`+-- $Header: /cvsroot/pgsql/src/test/regress/sql/boolean.sql,v 1.4 1997/10/25 06:02:33 thomas Exp $`
`5`	`5`	`--`
`6`	`6`
`7`	`7`	`--`
`@@ -70,7 +70,10 @@ INSERT INTO BOOLTBL2 (f1) VALUES ('false'::bool);`
`70`	`70`
`71`	`71`	`INSERT INTO BOOLTBL2 (f1)VALUES ('False'::bool);`
`72`	`72`
`73`		`--- this evaluates to a false value`
	`73`	`+INSERT INTO BOOLTBL2 (f1)VALUES ('FALSE'::bool);`
	`74`	`+`
	`75`	`+-- this is now an invalid expression`
	`76`	`+-- pre-v6.3 this evaluated to false - thomas 1997-10-23`
`74`	`77`	`INSERT INTO BOOLTBL2 (f1)`
`75`	`78`	`VALUES ('XXX'::bool);`
`76`	`79`

Comments

(0)