My MySQL/MariaDB playground (including sample schemas, examples of new features, experimental queries, test cases, utility routines, fun scripts, etc.)
- DataMask - data masking routines.
- Debug - examples for tracing stored routines.
- Examples:
- AI - examples related to
VECTORdatatype and vector search; - Admin - examples related to administration;
- CHECK - examples with
CHECKconstraints; - Index - examples with indexes (e.g. functional, multi-valued, etc.);
- JSON - examples with
JSONdata type and functions; - Join - examples with joins (e.g. lateral, hash, etc.);
- Math - examples related to mathematics;
- Optimizer - examples related to optimization (e.g. histogram,
EXPLAINstatements, etc.); - PSM - examples with Persistent Stored Modules (i.e. stored routines);
- Performance - examples related to performance;
- SELECT - examples with
SELECTstatements; - Schema - sample schemas and operations on schemas;
- Sets - examples with SQL set operators (e.g.
EXCEPT,INTERSECTandMINUSstatements); - Spatial - examples with spatial data and functions;
- TABLE - examples with
CREATE TABLEandTABLEstatements; - Temporal - examples for application and system versioned tables;
- VALUES - examples with
VALUESstatement; - Views - examples with views;
- WITH - examples with CTEs (e.g.
WITHstatements); - Window - examples with window functions (e.g.
OVER,PARTITION BYclauses).
- AI - examples related to
- Fun - fun scripts :-)
- Misc - miscellaneous scripts;
- Scripts - utility scripts in AWK, Bash and Perl.
This is a list of all MySQL bugs that I reported over the years with their status and details. The test cases for some of them could be found in this repository as marked below.
| Bug | Submitted | Synopsis | Status | Last updated | Details |
|---|---|---|---|---|---|
| 108789 | 2022-10-15 | OverflowBitsetTest.ZeroInitialize failure on x86 | Unsupported | 2022-11-08 | The one after which I stopped building MySQL for Slackware x86 |
| 107147 | 2022-04-28 | Slow server upgrades with MySQL 8 | Not a Bug | 2022-11-08 | |
| 106721 | 2022-03-13 | Hash join test failure on x86 | Closed | 2022-04-28 | Fixed in MySQL 8.0.29, but no further information given |
| 103397 | 2021-04-21 | More meaninful message for missing include directory | Closed | 2021-06-14 | Fixed in MySQL 8.0.27 |
| 102466 | 2021-02-03 | Wrong default for performance_schema_digests_size on Statement Summary Tables | Closed | 2021-02-05 | Documentation for Statement Summary Tables updated |
| 102364 | 2021-01-25 | MySQL Workbench 8.0.23 unable to start due to wrong system python paths | Duplicate | 2021-04-15 | See bug 102284 |
| 102308 | 2021-01-20 | Compilation error for Boolean literal in sql/mysqld.cc with MySQL 8.0.23 | Closed | 2021-01-22 | Fixed in MySQL 8.0.24 |
| 101231 | 2020-10-19 | Min required Protobuf version not properly detected | Closed | 2020-11-10 | Clarified build flags with developers |
| 101230 | 2020-10-19 | Please, specify required Protobuf version in docs and release notes | Can't repeat | 2020-11-19 | |
| 98266 | 2020-01-17 | Workbench editor shows syntax error on TABLE statement | Closed | 2020-04-01 | Fixed in MySQL Workbench 8.0.21 |
| 98263 | 2020-01-17 | Workbench editor shows syntax error on VALUES statement | Closed | 2020-04-01 | Fixed in MySQL Workbench 8.0.21 |
| 97595 | 2019-11-12 | Wrong visual explain for queries using window functions in Workbench | Verified | 2019-11-20 | |
| 97492 | 2019-11-05 | Print unit for timings in EXPLAIN ANALYZE | Closed | 2019-11-06 | Documentation updated, but output still not changed |
| 97416 | 2019-10-29 | EXPLAIN ANALYZE shows syntax error in SQL editor | Closed | 2020-01-14 | Fixed in MySQL Workbench 8.0.19 |
| 97282 | 2019-10-18 | Integrate TREE explain format and EXPLAIN ANALYZE in Workbench | Verified | 2019-10-30 | |
| 97281 | 2019-10-18 | Histogram creation and removal statements with syntax errors in Workbench | Closed | 2020-01-14 | Fixed in MySQL Workbench 8.0.19 |
| 97280 | 2019-10-18 | Hash join not displayed in traditional and JSON formats | Verified | 2019-10-18 | |
| 96222 | 2019-07-16 | MySQL Workbench doesn't display the comment on a generated column | Verified | 2019-07-16 | |
| 95804 | 2019-06-14 | Synchronize Model always generates VISIBLE indexes no matter the server version | Verified | 2020-11-05 | |
| 95415 | 2019-05-19 | Table Data Import Wizard fails on UTF-8 encoded file with BOM | Verified | 2022-02-07 | |
| 95411 | 2019-05-17 | LATERAL produces wrong results (values instead of NULLs) on 8.0.16 | Duplicate | 2019-05-20 | 95411 test case, see bug 94721, fixed in MySQL 8.0.17 |
| 95192 | 2019-04-29 | CHECK constraint comparing column with default value is not enforced | Closed | 2019-10-29 | 95192 test case, fixed in MySQL 8.0.18 |
| 95189 | 2019-04-29 | CHECK constraint comparing columns is not always enforced with UPDATE queries | Closed | 2019-07-31 | 95189 test case, fixed in MySQL 8.0.17 |
| 95143 | 2019-04-26 | No support for CHECK constraints in Workbench | Verified | 2019-05-14 | |
| 94012 | 2019-01-23 | MySQL Workbench 8.0.14 doesn't support LATERAL keyword | Closed | 2019-05-18 | Fixed in MySQL Workbench 8.0.16 |
| 93835 | 2019-01-07 | Display warning when keyword is used as identifier | Verified | 2019-01-10 | |
| 92908 | 2018-10-23 | MySQL Workbench 8.0.13 doesn't support expressions as key parts | Closed | 2019-05-18 | Fixed in MySQL Workbench 8.0.16 |
| 92900 | 2018-10-23 | MySQL Workbench 8.0.13 doesn't support expressions in DEFAULT | Closed | 2019-12-25 | Fixed in MySQL Workbench 8.0.16 |
| 92898 | 2018-10-23 | Error MY-013235 Error in parsing View during upgrade with MySQL 8.0.13 | Not a Bug | 2018-10-23 | Related to removed ASC or DESC qualifiers for GROUP BY clauses in MySQL 8.0.13 |
| 91841 | 2018-07-31 | MySQL Connector/ODBC 5.3.11 does not compile on Slackware Linux | Closed | 2019-01-25 | Fixed in MySQL Connector/ODBC 5.3.12 |
| 90876 | 2018-05-15 | Shell 8.0.11 gives error 5115 on adding documents to collection in Server 5.7 | Closed | 2022-07-05 | Updated documentation for Working with Collections - Add a Document |
| 90772 | 2018-05-06 | Synchronize model makes different between single quotes escapes | Verified | 2021-04-15 | DDL error fixed in MySQL Workbench 8.0.13, see bug 92191, but synchronization difference remains |
| 90727 | 2018-05-03 | Linking errors for missing mysql_sys and mysql_strings libraries | Closed | 2018-06-01 | Fixed in MySQL Connector/C++ 1.1.12 |
| 90620 | 2018-04-25 | MySQL Workbench SQL Editor displays error on SELECT query with window functions | Closed | 2020-05-07 | Fixed in MySQL Workbench 8.0.16 |
| 90619 | 2018-04-25 | MySQL Installer for windows doesn't offer upgrade from 5.7 to 8.0 | Duplicate | 2018-04-25 | See bug 79315 |
| 89615 | 2018-02-10 | Building Shell 1.0.10 and above from source fails for undefined vio* functions | Unsupported | 2018-08-23 | |
| 89608 | 2018-02-09 | MySQL Workbench password requirements messages to match server configuration | Verified | 2018-02-13 | |
| 84951 | 2017-02-10 | Problem compiling jsonparser.cpp and jsonview.ccp on Slackware (32 bits) | Duplicate | 2017-02-12 | See bug 84886 |
| 82202 | 2016-07-12 | Cannot link to libmysqlclient.so due to undef my_malloc, my_free and others | Closed | 2018-01-31 | Fixed in MySQL Connector/ODBC 5.3.10 |
| 73770 | 2014-08-29 | Make the synchronizer display the actual differences | Verified | 2018-02-05 | |
| 73708 | 2014-08-25 | Diagrams completely mangled | Closed | 2014-12-01 | |
| 73079 | 2014-06-23 | Cell not refreshed after setting value to NULL | Closed | 2014-09-15 | Fixed in MySQL Workbench 6.2.3 |
| 73076 | 2014-06-23 | Applying modifications in a record set actually commits them | Closed | 2014-08-26 | Fixed in MySQL Workbench 6.2.2 |
| 69459 | 2013-06-13 | Crash on entering dot in a SQL string when automatic code completion is enabled | Can't repeat | 2013-12-24 | |
| 20098 | 2006-05-26 | Query browser is searching for a file that is not present (preferences.glade) | No Feedback | 2006-06-30 |
See current list can always be found at Bugs Home.