| spider_example | CREATE TABLE `spider_example` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(50) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 |

MariaDB [test]> select * from spider_example;

+----+------+

| id | name |

+----+------+

|  1 | beam |

|  2 | beam |

+----+------+

2 rows in set (0.003 sec)

MariaDB [test]> select id,

    -> CASE

    -> when name='ram' then "wrong.."

    -> when name='beam' then "correct.."

    -> END

    -> from spider_example;

+----+---------------------------------------------------------------------------+

| id | CASE

when name='ram' then "wrong.."

when name='beam' then "correct.."

END |

+----+---------------------------------------------------------------------------+

|  1 | correct..                                                                 |

|  2 | correct..                                                                 |

+----+---------------------------------------------------------------------------+

2 rows in set (0.000 sec)

MariaDB [test]> select @@version;

+----------------+

| @@version      |

+----------------+

| 10.5.8-MariaDB |

+----------------+

1 row in set (0.000 sec)

| spider_example | CREATE TABLE `spider_example` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(50) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=SPIDER DEFAULT CHARSET=latin1 COMMENT='wrapper "mysql", srv "dataNode1", table "spider_example"' |

MariaDB [test]> select id,

    -> CASE

    -> when name='ram' then "wrong.."

    -> when name='beam' then "correct.."

    -> END

    -> from spider_example;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'case (t0.`name` = 'beam')  _utf8'wrong..'  _utf8'correct..') `CASE

when name=...' at line 1

MariaDB [test]>