Bug 1947388

Summary: DROP TABLE doesn't raise error while dropping non-existing table in MariaDB 10.5.9 when OQGraph SE is loaded to the server
Product: [Fedora] Fedora Reporter: Lukas Javorsky <ljavorsk>
Component: mariadbAssignee: Michal Schorm <mschorm>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 34CC: damien.ciabrini, hhorak, ljavorsk, mbayer, mkocka, mmuzila, mschorm, SpikeFedora
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: mariadb-10.5.15-1.fc36 mariadb-10.5.15-1.fc35 mariadb-10.5.15-1.fc34 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-05-07 04:34:48 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:
Bug Depends On: 1942526, 1944653    
Bug Blocks:    

Description Lukas Javorsky 2021-04-08 11:16:02 UTC
+++ This bug was initially created as a clone of Bug #1942526 +++

Description of problem:
The MariaDB doesn't raise an error while trying to drop a non-existing table.

This problem was detect by test "/CoreOS/mariadb55/Security/CVE-2009-4019-crash-where-comparing-subquery"

Version-Release number of selected component (if applicable): 
mariadb-10.5-*


How reproducible:
Always


Steps to Reproduce:
1. Install the mariadb-server mariadb mariadb-oqgraph-engine
2. Start the server
3. Create a database
4. Create a table
5. Drop the table
6. Drop the same table again (it will not fail, but it should)

Actual results:
Doesn't raise an error

Expected results:
Should raise error while dropping non-existing table (step 6)
Error: ERROR 1051 (42S02): Unknown table 'test.t'

Comment 1 Lukas Javorsky 2021-04-08 11:18:06 UTC
I've tested the upstream repo as well and the bug is still there.

The next move is to report this issue to the upstream and see what they have to say

Comment 2 Lukas Javorsky 2021-04-08 11:29:06 UTC
Jira bug issue submitted: https://jira.mariadb.org/browse/MDEV-25373

Comment 4 Fedora Update System 2022-04-28 15:54:41 UTC
FEDORA-2022-5cfe372ab7 has been submitted as an update to Fedora 34. https://bodhi.fedoraproject.org/updates/FEDORA-2022-5cfe372ab7

Comment 5 Fedora Update System 2022-04-28 15:54:42 UTC
FEDORA-2022-263f7cc483 has been submitted as an update to Fedora 36. https://bodhi.fedoraproject.org/updates/FEDORA-2022-263f7cc483

Comment 6 Fedora Update System 2022-04-28 15:54:43 UTC
FEDORA-2022-03350936ee has been submitted as an update to Fedora 35. https://bodhi.fedoraproject.org/updates/FEDORA-2022-03350936ee

Comment 7 Fedora Update System 2022-04-29 05:47:55 UTC
FEDORA-2022-263f7cc483 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-263f7cc483`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-263f7cc483

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

Comment 8 Fedora Update System 2022-04-29 07:41:33 UTC
FEDORA-2022-5cfe372ab7 has been pushed to the Fedora 34 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2022-5cfe372ab7`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-5cfe372ab7

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

Comment 9 Fedora Update System 2022-04-29 08:08:16 UTC
FEDORA-2022-03350936ee has been pushed to the Fedora 35 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2022-03350936ee`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-03350936ee

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

Comment 10 Fedora Update System 2022-05-07 04:34:48 UTC
FEDORA-2022-263f7cc483 has been pushed to the Fedora 36 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 11 Fedora Update System 2022-05-08 01:46:45 UTC
FEDORA-2022-03350936ee has been pushed to the Fedora 35 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 12 Fedora Update System 2022-05-08 02:02:05 UTC
FEDORA-2022-5cfe372ab7 has been pushed to the Fedora 34 stable repository.
If problem still persists, please make note of it in this bug report.