Bug 2075456

Summary:	getTables with null value for tableNamePattern throws Syntax error
Product:	[Fedora] Fedora	Reporter:	Christoph Roeper <cr>
Component:	mariadb-java-client	Assignee:	Michal Schorm <mschorm>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	35	CC:	hhorak, jjanco, mkulik, mschorm, odubaj, zmiklank
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2022-05-09 07:17:24 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.