Bug 2075456 - getTables with null value for tableNamePattern throws Syntax error
Summary: getTables with null value for tableNamePattern throws Syntax error
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Fedora
Classification: Fedora
Component: mariadb-java-client
Version: 35
Hardware: All
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Michal Schorm
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2022-04-14 09:24 UTC by Christoph Roeper
Modified: 2022-05-09 07:17 UTC (History)
6 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2022-05-09 07:17:24 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Christoph Roeper 2022-04-14 09:24:36 UTC
Description of problem:
The current mariadb-java-client 3.0.x (x <= 3) driver breaks on calling the standard JDBC method java.sql.DatabaseMetaData.getTables(...).
See also
[DatabaseMetadata#getTables with null value for tableNamePattern throws Syntax error]
https://jira.mariadb.org/browse/CONJ-921
and
[SQuirreL SQL Client]
https://sourceforge.net/p/squirrel-sql/bugs/1499/

Version-Release number of selected component (if applicable):
3.0.1 - 3.0.3

How reproducible:
Call the function java.sql.DatabaseMetaData.getTables(...) or use some client that does that. This is a known bug in the driver, see bug report.

Actual results:
java.sql.SQLSyntaxErrorException is thrown.

Expected results:
No error, metadata shall be fetched.

Additional info:
It looks like Fedora 36 is including the buggy verion 3.0.3, and the fixed version is planed for Fedora 37 in half a year. Maybe a re-schedule is advised.

rpms / mariadb-java-client
https://src.fedoraproject.org/rpms/mariadb-java-client

Comment 1 Fedora Update System 2022-04-14 10:59:30 UTC
FEDORA-2022-44fd087314 has been submitted as an update to Fedora 36. https://bodhi.fedoraproject.org/updates/FEDORA-2022-44fd087314

Comment 2 Zuzana Miklankova 2022-04-14 11:00:07 UTC
Good idea. I've added mariadb-java-client 3.0.4 build to f36.

Comment 3 Fedora Update System 2022-04-14 18:49:34 UTC
FEDORA-2022-44fd087314 has been pushed to the Fedora 36 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2022-44fd087314`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-44fd087314

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 4 Fedora Update System 2022-05-07 04:24:27 UTC
FEDORA-2022-44fd087314 has been pushed to the Fedora 36 stable repository.
If problem still persists, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.