You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +03:00
20 lines
671 B
Plaintext
20 lines
671 B
Plaintext
--source ../include/have_columnstore.inc
|
|
--source ../include/detect_maxscale.inc
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS db4741;
|
|
--enable_warnings
|
|
CREATE DATABASE db4741;
|
|
USE db4741;
|
|
CREATE TABLE t (x VARCHAR(5) DEFAULT '') engine = columnstore;
|
|
|
|
--replace_result $MTR_SUITE_DIR MTR_SUITE_DIR
|
|
--eval 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';
|
|
|
|
--replace_result $MTR_SUITE_DIR MTR_SUITE_DIR
|
|
--eval 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';
|
|
DROP DATABASE IF EXISTS db4741;
|