DROP DATABASE IF EXISTS db4741;
CREATE DATABASE db4741;
USE db4741;
CREATE TABLE t (x VARCHAR(5) DEFAULT '') engine = columnstore;
LOAD DATA LOCAL infile 'MTR_SUITE_DIR/../std_data/mcol-4741-part-1-strings-and-nulls.txt' INTO TABLE t;
SELECT COUNT(*) FROM t WHERE x='val';
COUNT(*)
2
LOAD DATA LOCAL infile 'MTR_SUITE_DIR/../std_data/mcol-4741-part-2-empty-strings.txt' INTO TABLE t;
SELECT COUNT(*) FROM t WHERE x='val';
COUNT(*)
2