The SQL statement of MariaDB vector MariaDBSchema Validator needs to be enclosed in quotation marks #3492
Description
Bug description
Execution without quotation marks will not yield results
Environment
spring ai 1.0.0
spring-ai-mariadb-store 1.0.0
Steps to reproduce
schemaValidation(true)
String sql = String.format(
"SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '%s' AND TABLE_NAME = '%s'",
(schemaName == null) ? "SCHEMA()" : schemaName, tableName);