Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Too many columns on partitioned table makes database broken

Description

Here's the steps to reproduce the issue, if the table is unpartitioned, adding too many columns will fail and table/database remains last working state.  

However, if the table is partitioned, add column query fails but also break the table and database, any further queries for this table would fail.

For reference, if step 5b is not executed, nothing broken, otherwise database and table are broken.

 

Logs (without step 5b, everything works)

 

Logs (with step 5b, table and database are broken)**

 

Environment

Docker 20.10.1 on Ubuntu 20.04

Attachments

9

Smart Checklist

Activity

Show:

Albert Wang April 29, 2021 at 7:57 AM

Dear Percona experts, 

Thanks for helping it out, please noted that I've also reported this bug to Oracle: MySQL Bugs: #103363: Too many columns on partitioned table makes database broken

denis.subbota April 28, 2021 at 6:47 AM
Edited

Thank you for the report.

Bug is verified.

I have tried on Environment Docker:  20.10.1 on Ubuntu 20.04(installed on VirtualBoX version 6.1.18 r142142 (Qt5.6.3)) 

Also I have tested on different version of mysql.

  • mysql Ver 8.0.22-13 for Linux on x86_64 (Percona Server (GPL), Release 13, Revision 6f7822f) -  bug verified

  • mysql Ver 8.0.22 for Linux on x86_64 (MySQL Community Server - GPL)                          -  bug verified

 

  •   mysql Ver 14.14 Distrib 5.7.33-36, for Linux (x86_64) using 7.0                         - bug not verified

 

 

Details

Assignee

Reporter

Labels

Affects versions

Priority

Smart Checklist

Created March 23, 2021 at 2:18 AM
Updated March 6, 2024 at 10:40 AM