| Bug #117417 | Creating index causes partitioning failure | ||
|---|---|---|---|
| Submitted: | 8 Feb 11:39 | Modified: | 11 Feb 12:37 |
| Reporter: | Jiyuan Li | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
| Version: | 9.1.0-cluster | OS: | Ubuntu (22.04) |
| Assigned to: | MySQL Verification Team | CPU Architecture: | x86 |
[11 Feb 12:37]
MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. For details on getting support for MySQL products see http://www.mysql.com/support/ You can also check our forums (free) at http://forums.mysql.com/ Thank you for your interest in MySQL.
Description: I created a table and created an index on it, then I tried to partition the table but I got an error. How to repeat: CREATE TABLE t0(c0 DECIMAL COLUMN_FORMAT FIXED , c1 DECIMAL PRIMARY KEY NOT NULL UNIQUE COLUMN_FORMAT DEFAULT STORAGE MEMORY) ; CREATE INDEX i1 USING BTREE ON t0((CAST((CAST('Sπ' AS SIGNED)) IS NOT UNKNOWN AS SIGNED))) VISIBLE; INSERT HIGH_PRIORITY IGNORE INTO t0(c1) VALUES(NULL); alter table t0 partition by key() partitions 56;