Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.8, 10.1(EOL)
-
openbsd, windows
-
10.1.10, 10.1.11
Description
I have 4 rows in col1, yet maria 10.1 says on
select nullif(count(`lame`.`col1`),0) from lame |
that I have 7.
maria 10.0 and mysql gives 4 here.
changing to ifnull instead of nullif works fine.
To recreate this simple bug just use that line on anything you have or to recreate my testdb see below
CREATE TABLE IF NOT EXISTS `lame` ( |
`col1` varchar(50) DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
|
/*!40000 ALTER TABLE `lame` DISABLE KEYS */; |
INSERT INTO `lame` (`col1`) VALUES |
('hello'), |
('hello\r\n'), |
('hello'), |
('hello'); |