Adding upstream version 1:10.5.12.upstream/1%10.5.12upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 424 insertions, 0 deletions

diff --git a/mysql-test/suite/engines/funcs/t/general_null.test b/mysql-test/suite/engines/funcs/t/general_null.test
new file mode 100644
index 00000000..0c3b8287
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/t/general_null.test
@@ -0,0 +1,424 @@
+--disable_warnings
+DROP TABLE IF EXISTS t3;
+--enable_warnings
+CREATE TABLE t3(c1 TINYINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MAX(c1) AS value FROM t3;
+SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 SMALLINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MAX(c1) AS value FROM t3;
+SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 MEDIUMINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MAX(c1) AS value FROM t3;
+SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MAX(c1) AS value FROM t3;
+SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INTEGER NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MAX(c1) AS value FROM t3;
+SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 BIGINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MAX(c1) AS value FROM t3;
+SELECT MAX(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MAX(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 TINYINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MIN(c1) AS value FROM t3;
+SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 SMALLINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MIN(c1) AS value FROM t3;
+SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 MEDIUMINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MIN(c1) AS value FROM t3;
+SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MIN(c1) AS value FROM t3;
+SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INTEGER NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MIN(c1) AS value FROM t3;
+SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 BIGINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT MIN(c1) AS value FROM t3;
+SELECT MIN(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT MIN(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 TINYINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT AVG(c1) AS value FROM t3;
+SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 SMALLINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT AVG(c1) AS value FROM t3;
+SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 MEDIUMINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT AVG(c1) AS value FROM t3;
+SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT AVG(c1) AS value FROM t3;
+SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INTEGER NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT AVG(c1) AS value FROM t3;
+SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 BIGINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT AVG(c1) AS value FROM t3;
+SELECT AVG(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT AVG(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 TINYINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT SUM(c1) AS value FROM t3;
+SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 SMALLINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT SUM(c1) AS value FROM t3;
+SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 MEDIUMINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT SUM(c1) AS value FROM t3;
+SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT SUM(c1) AS value FROM t3;
+SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INTEGER NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT SUM(c1) AS value FROM t3;
+SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 BIGINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT SUM(c1) AS value FROM t3;
+SELECT SUM(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT SUM(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 TINYINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT COUNT(c1) AS value FROM t3;
+SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 SMALLINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT COUNT(c1) AS value FROM t3;
+SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 MEDIUMINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT COUNT(c1) AS value FROM t3;
+SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT COUNT(c1) AS value FROM t3;
+SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 INTEGER NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT COUNT(c1) AS value FROM t3;
+SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+CREATE TABLE t3(c1 BIGINT NULL);
+INSERT INTO t3 (c1) VALUES(0);
+INSERT INTO t3 (c1) VALUES(1);
+INSERT INTO t3 (c1) VALUES(16);
+INSERT INTO t3 (c1) VALUES(-4);
+INSERT INTO t3 (c1) VALUES(-9);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+INSERT INTO t3 (c1) VALUES(NULL);
+SELECT COUNT(c1) AS value FROM t3;
+SELECT COUNT(c1) AS postive_value FROM t3 WHERE c1 > 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 < 0;
+SELECT COUNT(c1) AS negative_value FROM t3 WHERE c1 = 2;
+DROP TABLE t3;
+