1--echo # 2--echo # MDEV-24760 SELECT..CASE statement syntax error at Spider Engine table 3--echo # 4 5--disable_query_log 6--disable_result_log 7--source ../t/test_init.inc 8--enable_query_log 9--enable_result_log 10 11--connection child2_1 12CREATE DATABASE auto_test_remote; 13USE auto_test_remote; 14 15DROP TABLE IF EXISTS tbl_a; 16eval CREATE TABLE tbl_a ( 17 id int NOT NULL AUTO_INCREMENT, 18 name varchar(255) DEFAULT NULL, 19 PRIMARY KEY (id) 20) $CHILD2_1_ENGINE $CHILD2_1_CHARSET; 21 22INSERT INTO tbl_a (name) VALUES ('Alice'), ('Bob'); 23 24--connection master_1 25CREATE DATABASE auto_test_local; 26USE auto_test_local; 27 28eval CREATE TABLE tbl_a ( 29 id int NOT NULL AUTO_INCREMENT, 30 name varchar(255) DEFAULT NULL, 31 PRIMARY KEY (id) 32) $MASTER_1_ENGINE $MASTER_1_CHARSET COMMENT='table "tbl_a"' 33PARTITION BY HASH(id) ( 34 PARTITION pt1 COMMENT='srv "s_2_1"' 35); 36 37SELECT id, CASE WHEN name='Alice' THEN "A" WHEN name='Bob' THEN "B" END FROM tbl_a; 38SELECT id, CASE name WHEN 'Alice' THEN "A" WHEN 'Bob' THEN "B" END FROM tbl_a; 39 40DROP DATABASE auto_test_local; 41 42--connection child2_1 43DROP DATABASE auto_test_remote; 44 45--disable_query_log 46--disable_result_log 47--source ../t/test_deinit.inc 48--enable_query_log 49--enable_result_log 50