Commitd586756

committed

NOT operator fixed

1 parent0457402 commitd586756Copy full SHA for d586756

File tree

+45

-1

lines changed

+45

-1

lines changed

Lines changed: 35 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1428,6 +1428,41 @@ EXPLAIN (COSTS OFF) SELECT * FROM messages;`
`1428`	`1428`	`-> Seq Scan on messages_2`
`1429`	`1429`	`(3 rows)`
`1430`	`1430`
	`1431`	`+/* Testing NOT operator */`
	`1432`	`+CREATE TABLE bool_test(a serial, b BOOLEAN);`
	`1433`	`+SELECT create_hash_partitions('bool_test', 'a', 3);`
	`1434`	`+ create_hash_partitions`
	`1435`	`+------------------------`
	`1436`	`+ 3`
	`1437`	`+(1 row)`
	`1438`	`+`
	`1439`	`+INSERT INTO bool_test SELECT g, (g % 2) = 0 FROM GENERATE_SERIES(1, 100) AS g;`
	`1440`	`+SELECT count(*) FROM bool_test;`
	`1441`	`+ count`
	`1442`	`+-------`
	`1443`	`+ 100`
	`1444`	`+(1 row)`
	`1445`	`+`
	`1446`	`+SELECT count(*) FROM bool_test WHERE (b = true AND b = false);`
	`1447`	`+ count`
	`1448`	`+-------`
	`1449`	`+ 0`
	`1450`	`+(1 row)`
	`1451`	`+`
	`1452`	`+SELECT count(*) FROM bool_test WHERE b = false;`
	`1453`	`+ count`
	`1454`	`+-------`
	`1455`	`+ 50`
	`1456`	`+(1 row)`
	`1457`	`+`
	`1458`	`+SELECT count(*) FROM bool_test WHERE b = false;`
	`1459`	`+ count`
	`1460`	`+-------`
	`1461`	`+ 50`
	`1462`	`+(1 row)`
	`1463`	`+`
	`1464`	`+DROP TABLE bool_test CASCADE;`
	`1465`	`+NOTICE: drop cascades to 3 other objects`
`1431`	`1466`	`DROP SCHEMA test CASCADE;`
`1432`	`1467`	`NOTICE: drop cascades to 13 other objects`
`1433`	`1468`	`DROP EXTENSION pg_pathman CASCADE;`

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -387,6 +387,15 @@ ALTER TABLE replies DROP CONSTRAINT replies_message_id_fkey;`
`387`	`387`	`SELECT create_range_partitions('messages','id',1,100,2);`
`388`	`388`	`EXPLAIN (COSTS OFF)SELECT*FROM messages;`
`389`	`389`
	`390`	`+/* Testing NOT operator*/`
	`391`	`+CREATETABLEbool_test(aserial, bBOOLEAN);`
	`392`	`+SELECT create_hash_partitions('bool_test','a',3);`
	`393`	`+INSERT INTO bool_testSELECT g, (g %2)=0FROM GENERATE_SERIES(1,100)AS g;`
	`394`	`+SELECTcount(*)FROM bool_test;`
	`395`	`+SELECTcount(*)FROM bool_testWHERE (b= trueAND b= false);`
	`396`	`+SELECTcount(*)FROM bool_testWHERE b= false;`
	`397`	`+SELECTcount(*)FROM bool_testWHERE b= false;`
	`398`	`+DROPTABLE bool_test CASCADE;`
`390`	`399`
`391`	`400`	`DROPSCHEMA test CASCADE;`
`392`	`401`	`DROP EXTENSION pg_pathman CASCADE;`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1533,7 +1533,7 @@ handle_boolexpr(const BoolExpr expr, WalkerContext context)`
`1533`	`1533`	`default:`
`1534`	`1534`	`result->rangeset=list_make1_irange(make_irange(0,`
`1535`	`1535`	`PrelLastChild(prel),`
`1536`		`-false));`
	`1536`	`+true));`
`1537`	`1537`	`break;`
`1538`	`1538`	`}`
`1539`	`1539`	`}`

Comments

(0)