[MDEV-16551] Data corrupted for Table, version - 10.2 Created: 2018-06-22  Updated: 2018-06-22  Resolved: 2018-06-22

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: 10.2.14
Fix Version/s: 10.2.16, 10.3.8

Type: Bug Priority: Minor
Reporter: SAURAV GUPTA Assignee: Alice Sherepa
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Windows

Attachments: File bug_script.sql    
Issue Links:
Duplicate
is duplicated by MDEV-15338 Assertion `!table || (!table->read_se... Closed

 Description   

Hello Team,

We will be upgrading from existing "10.0.20" to "10.2.14-MariaDB-log" on Production running on linux.

But before this I was testing "10.2.14-MariaDB-log" on my local machine on Windows and I came across a use case which includes adding 2 columns (With new feature of default value as SQL expressions) and 1 check constraint including those two new columns, on a table consists of only 1 dummy record.

And soon after that when I dropped those 2 columns along with constraint, I mistakenly misspelled constraint name, which results in the 1 record of table become corrupt.

So please find attached the exact commands which caused by 1 record of my table become corrupt and kindly confirm the bug.

 Comments   
Comment by Alice Sherepa [ 2018-06-22 ]

Thanks for the report!
I reproduced it on MariaDB 10.2.14, it looks like it is the same problem as MDEV-15338, that was fixed by commit 2dff8fe.

Generated at Thu Feb 08 08:29:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.