Bug #117417 Creating index causes partitioning failure

Submitted:	8 Feb 2025 11:39	Modified:	11 Feb 2025 12:37
Reporter:	Jiyuan Li	Email Updates:
Status:	Not a Bug	Impact on me:	None
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

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;

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.

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.