# -------------------------------------------------------------- #
# Test case migrated from regression test suite: MCOL-812.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
--disable_warnings
DROP TABLE IF EXISTS test.mcol812a;
DROP TABLE IF EXISTS test.mcol812b;
--enable_warnings
# -------------------------------------------------------------- #
# Enable cross engine join
# Configure user and password in Columnstore.xml file
# -------------------------------------------------------------- #
--exec /usr/bin/mcsSetConfig CrossEngineSupport User 'cejuser'
--exec /usr/bin/mcsSetConfig CrossEngineSupport Password 'Vagrant1!0000001'
# -------------------------------------------------------------- #
# Create corresponding in the server
# -------------------------------------------------------------- #

CREATE USER IF NOT EXISTS'cejuser'@'localhost' IDENTIFIED BY 'Vagrant1!0000001';

GRANT ALL PRIVILEGES ON *.* TO 'cejuser'@'localhost';
FLUSH PRIVILEGES;
#
CREATE TABLE test.mcol812a (
  `a` int(11) DEFAULT NULL,
  `b` varchar(10) DEFAULT NULL
) ENGINE=InnoDB; 
CREATE TABLE test.mcol812b (
  `a` int(11) DEFAULT NULL
) ENGINE=Columnstore;

insert into test.mcol812a values (1, '\'');
insert into test.mcol812a values (1, '\\');
insert into test.mcol812b values (1);

select * from test.mcol812b join test.mcol812a on test.mcol812b.a = test.mcol812a.a where test.mcol812a.b='\'';
select * from test.mcol812b join test.mcol812a on test.mcol812b.a = test.mcol812a.a where test.mcol812a.b='\\';

--disable_warnings
DROP TABLE test.mcol812a;
DROP TABLE test.mcol812b;
--enable_warnings
#
DROP USER 'cejuser'@'localhost';