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