Bug #33138 procedure analyse is not aware of cluster 4 byte align types

• Submitted: 11 Dec 2007 13:20
• Modified: 8 Feb 2018 22:20
• Reporter: Monty Taylor
• Status: Won't fix
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• CPU Architecture: Any

[11 Dec 2007 13:20] Monty Taylor

Description:
running select * from table procedure analyse(); on data doesn't take storage engine in to account, and recommends possibly misleading data types on cluster. 

How to repeat:
make a table with engine=ndbcluster. make some columns. 

Suggested fix:
make procedure analyse report 4-byte alignment aware so that it doesn't bother reporting things like tinyint when it really isn't going to help.

[12 Dec 2007 8:35] Sveta Smirnova

Thank you for the report.

Verified as described.

Test case:

--source include/have_ndb.inc

create table t1(f1 int) engine=ndb;

insert into t1 values(1), (2), (4), (5), (6), (7), (9), (10), (11), (12), (14), (15), (16), (18), (19), (20), (21), (23), (24), (25), (26), (28), (29), (30), (32), (33), (34), (35), (37), (38), (39), (40), (42), (43), (44), (46), (47), (48), (49), (51), (52), (53), (54), (56), (57), (58), (60), (61), (62), (63), (65), (66), (67), (68), (70), (71), (72), (74), (75), (76), (77), (79), (80), (81), (82), (84), (85), (86), (88), (89), (90), (91), (93), (94), (95), (96), (98), (99), (100), (102), (103), (104), (105), (107), (108), (109), (110), (112), (113), (114), (116), (117), (118), (119), (121), (122), (123), (124), (126), (127);

select * from t1 procedure analyse();

[8 Feb 2018 22:20] Roy Lyseng

Posted by developer:
 
Will not be fixed since the PROCEDURE ANALYSE feature was deleted from 8.0.