@@ -101,7 +101,7 @@ SELECT count(*) FROM test.insert_into_select_copy;
101101DROP TABLE test .insert_into_select_copy ,test .insert_into_select CASCADE;
102102
103103
104- /* test special case: ONLY statement with not-ONLY for partitioned table*/
104+ /* Test special case: ONLY statement with not-ONLY for partitioned table*/
105105CREATE TABLE test .from_only_test(valINT NOT NULL );
106106INSERT INTO test .from_only_test SELECT generate_series(1 ,20 );
107107SELECT pathman .create_range_partitions (' test.from_only_test' ' val' 1 ,2 );
@@ -469,6 +469,16 @@ SELECT drop_partitions('test.range_rel', TRUE);
469469SELECT create_partitions_from_range(' test.range_rel' ' dt' ' 2015-01-01' date ,' 2015-12-01' date ,' 1 month'
470470EXPLAIN (COSTS OFF)SELECT * FROM test .range_rel WHERE dt= ' 2015-12-15'
471471
472+ /* Test NOT operator*/
473+ CREATE TABLE bool_test (aINT NOT NULL , bBOOLEAN );
474+ SELECT create_hash_partitions(' bool_test' ' a' 3 );
475+ INSERT INTO bool_testSELECT g, (g %4 )= 0 FROM generate_series(1 ,100 )AS g;
476+ SELECT count (* )FROM bool_test;
477+ SELECT count (* )FROM bool_testWHERE (b= trueAND b= false);
478+ SELECT count (* )FROM bool_testWHERE b= false;/* 75 values*/
479+ SELECT count (* )FROM bool_testWHERE b= true;/* 25 values*/
480+ DROP TABLE bool_test CASCADE;
481+
472482/* Test foreign keys*/
473483CREATE TABLE test .messages(idSERIAL PRIMARY KEY , msgTEXT );
474484CREATE TABLE test .replies(idSERIAL PRIMARY KEY , message_idINTEGER REFERENCES test .messages (id), msgTEXT );