--source ../include/have_columnstore.inc

SET default_storage_engine=ColumnStore;

--disable_warnings
DROP DATABASE IF EXISTS func_bit_mcs;
--enable_warnings
CREATE DATABASE func_bit_mcs;
USE func_bit_mcs;


--echo #
--echo # MCOL-4666 Empty set when using BIT OR and BIT AND functions in WHERE
--echo #

CREATE TABLE t1 (a BLOB);
INSERT INTO t1 VALUES ('1');
--error ER_INTERNAL_ERROR
SELECT a|1 FROM t1;
DROP TABLE t1;



#
# Clean up
#

DROP DATABASE func_bit_mcs;
USE test;