mariadb-columnstore-engine/mysql-test/columnstore/bugfixes/mcol-4407.test

--source ../include/have_columnstore.inc

-- disable_warnings
DROP DATABASE IF EXISTS mcol_4407;
-- enable_warnings

CREATE DATABASE mcol_4407;
USE mcol_4407;

-- disable_warnings
DROP TABLE IF EXISTS `sictable`;
-- enable_warnings

/* Bug when HWM > scan_threshold - 1 */
set max_recursive_iterations=6282;

CREATE TABLE `sictable`
  (
     `serialno`    VARCHAR(20)    NOT NULL
  )
    ENGINE=Columnstore
    DEFAULT CHARSET=utf8
  ;

INSERT INTO `sictable`  (
with recursive series as (
select 1 as id union all
select id +1 as id from series
where id < 6281)
select lpad(id,11,'0') from series);

SELECT  `serialno`
FROM  `sictable`
WHERE  `serialno` = '00000000029' AND  `serialno` = '00000006256';

SELECT  `serialno`
FROM  `sictable`
WHERE  `serialno` = '00000000029' AND  `serialno` = '00000000029';

/* Default value */
set max_recursive_iterations=1000;

DROP TABLE `sictable`;
DROP DATABASE mcol_4407;