Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
3.1.2
-
None
-
Windows 11
MariaDB Connector 3.1.2
MySQL Connector 8.0.32
MariaDB 10.11
Description
Hey there,
I use different connectors(MySQL / MariaDB Connector) to connect to the same MariaDB. My connection URL is like "jdbc:mariadb://localhost:3366/test?useUnicode=true&characterEncoding=utf8&sessionVariables=storage_engine=InnoDB,sql_mode=''&connectionTimeZone=UTC" and "jdbc:mysql://localhost:3366/test?useUnicode=true&characterEncoding=utf8&sessionVariables=storage_engine=InnoDB,sql_mode=''&connectionTimeZone=UTC"
and the setup SQL file:
DROP DATABASE IF EXISTS database0;
|
CREATE DATABASE database0;
|
I execute this file using Statement.executeQuery() for both connectors.
But the MySQL Connector and MariaDB Connector seem to have different results when executing the SQL file.
That is, MySQL Connector returns 'java.sql.SQLException: Statement.executeQuery() cannot issue statements that do not produce result sets.' but MariaDB Connector can successfully execute these SQLs and returns an empty result.
I also classify this as a bug because MariaDB claims MySQL compatibility at the driver level.