MariaDB [test_db]> CREATE TABLE `test_db`.`just_testing` ( 

  `name` varchar(16) not null

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

MariaDB [test_db]> insert into `test_db`.`just_testing`(name) values ('TestSpiderRegex');

MariaDB [test_db]> select `name` from `test_db`.`just_testing` where `NAME` REGEXP '(Test|Spider|Regex)';

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

| name            |

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

| TestSpiderRegex |

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

1 row in set (0.000 sec)

~MariaDB [test_db]> create database spider_test_db;

MariaDB [test_db]> CREATE TABLE `spider_test_db`.`just_testing` (

  `name` varchar(16) NOT NULL

) ENGINE=SPIDER DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='wrapper "mysql", srv "dataNode", database "test_db", table "just_testing"';

MariaDB [spider_test_db]> select * from `spider_test_db`.`just_testing`;

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

| name            |

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

| TestSpiderRegex |

+-----------------+~

~MariaDB [spider_test_db]> select `name` from `spider_test_db`.`just_testing` where `NAME` REGEXP '(Test|Spider|Regex)';

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 'regexp(t0.`name` , '(Test|Spider|Regex)'))' at line 1~