You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-30 07:25:34 +03:00
14 lines
465 B
Plaintext
14 lines
465 B
Plaintext
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
|
|
DROP DATABASE IF EXISTS db4741;
|