oak-online-alter-table: type mediumint not properly classed as integer

What steps will reproduce the problem?
test@localhost> create table test_mi (id mediumint unsigned not null 
auto_increment primary key, stuff varchar(20) not null) engine innodb;
Query OK, 0 rows affected (0.04 sec)

test@localhost> insert into test_mi (stuff) values ("hello, world"), ("hello 
again");
Query OK, 1 row affected (0.00 sec)

3. oak-online-alter-table -d test -S /tmp/mysql.sock -t test_mi -a 'add column 
morestuff2 varchar(20)'

What is the expected output? What do you see instead?
-- Connecting to MySQL
-- Table test.test_mi is of engine innodb
-- Checking for UNIQUE columns on test.test_mi, by which to chunk
-- Possible UNIQUE KEY column names in test.test_mi:
-- - id
-- Table test.__oak_test_mi has been created
-- Table test.__oak_test_mi has been altered
-- Checking for UNIQUE columns on test.__oak_test_mi, by which to chunk
-- Possible UNIQUE KEY column names in test.__oak_test_mi:
-- - id
-- Checking for UNIQUE columns on test.test_mi, by which to chunk
-- - Found following possible unique keys:
-- - id (mediumint)
-- Chosen unique key is 'id'
-- Shared columns: stuff, id
-- Created AD trigger
-- Created AU trigger
-- Created AI trigger
-- Attempting to lock tables

-- Tables locked WRITE
-- id (min, max) values: ([1L], [2L])
-- Tables unlocked
<type 'exceptions.Exception'> sequence item 0: expected string, long found
-- ERROR: Errors found. Initiating cleanup
-- Tables unlocked
-- Table test.__oak_test_mi was found and dropped
-- Dropped custom trigger test_mi_AD_oak
-- Dropped custom trigger test_mi_AU_oak
-- Dropped custom trigger test_mi_AI_oak
-- ERROR: sequence item 0: expected string, long found

Adding mediumint to the list of integer types checked in 
get_shared_unique_key_columns makes it work.

What version of the product are you using? On what operating system?
  - seen with v180, mysql 5.1.55, on rhel linux 4.8

Please provide any additional information below.

Original issue reported on code.google.com by megcroc...@gmail.com on 6 Apr 2011 at 10:38

shlomi-noach / openarkkit

oak-online-alter-table: type mediumint not properly classed as integer #11