Bug 1947388 - DROP TABLE doesn't raise error while dropping non-existing table in MariaDB 10.5.9 when OQGraph SE is loaded to the server
Summary: DROP TABLE doesn't raise error while dropping non-existing table in MariaDB 1...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: mariadb
Version: 34
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Michal Schorm
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On: 1942526 1944653
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-04-08 11:16 UTC by Lukas Javorsky
Modified: 2022-05-08 02:02 UTC (History)
8 users (show)

Fixed In Version: mariadb-10.5.15-1.fc36 mariadb-10.5.15-1.fc35 mariadb-10.5.15-1.fc34
Clone Of:
Environment:
Last Closed: 2022-05-07 04:34:48 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

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.


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