Re: Regarding "[Warning] InnoDB: Cannot add field"
Hi Peter,
Thanks for your offer to help! I've generated the testcase by using the 'show create table' and renaming the columns; and I'm able to reproduce it locally on my Mac running MySQL 5.7.24. The testcase is as followed:
CREATE TABLE `testcase` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`phnareacode` varchar(32) DEFAULT NULL COMMENT '_extra',
`devid` bigint(20) unsigned DEFAULT NULL COMMENT '_extra',
`second_id` int(10) unsigned NOT NULL COMMENT '_extra',
`col_0` text COMMENT 'Hdc3f6e8e',
`col_1` text COMMENT 'Hb1323afb',
`col_2` text COMMENT 'Hd6268999',
`col_3` text COMMENT 'Hfa9ee91d',
`col_4` text COMMENT 'Hd419f97c',
`col_5` text COMMENT 'Hca94a9fe',
`col_6` text COMMENT 'Heaa3acee',
`col_7` text COMMENT 'Hc54c38ca',
`col_8` text COMMENT 'He90b45dc',
`col_9` text COMMENT 'H1c58555e',
`col_10` text COMMENT 'Hd8f3d3a4',
`col_11` text COMMENT 'H16170316',
`col_12` text COMMENT 'Hb1d4bff2',
`col_13` text COMMENT 'H9df15211',
`col_14` text COMMENT 'H05f2ab65',
`col_15` text COMMENT 'H05f2aa67',
`col_16` text COMMENT 'H9bb91386',
`col_17` text COMMENT 'H161436e0',
`col_18` text COMMENT 'He1426c85',
`col_19` text COMMENT 'H925ea16d',
`col_20` text COMMENT 'H0cb85a11',
`col_21` text COMMENT 'H06b6c036',
`col_22` text,
`col_23` text COMMENT 'H99ec42ed',
`col_24` text,
`col_25` text COMMENT 'Hd6bcd5b9',
`col_26` text COMMENT 'Hf060cfde',
`col_27` text COMMENT 'H5be96805',
`col_28` text COMMENT 'H99e7830d',
`col_29` text COMMENT 'H99e7830e',
`col_30` text COMMENT 'H99e78310',
`col_31` text COMMENT 'Haf549749',
`col_32` text COMMENT 'Haf54974a',
`col_33` text,
`col_34` text COMMENT 'Haf54974c',
`col_35` text COMMENT 'Haf54974d',
`col_36` text COMMENT 'Haf54974e',
`col_37` text COMMENT 'Haf54974f',
`col_38` text COMMENT 'Haf549750',
`col_39` text COMMENT 'Haf549751',
`col_40` text COMMENT 'Haf549752',
`col_41` text COMMENT 'Haf549753',
`col_42` text COMMENT 'H2a00f516',
`col_43` text COMMENT 'H810c672d',
`col_44` text COMMENT 'Ha1d9fe6c',
`col_45` text,
`col_46` text COMMENT 'H2f52d487',
`col_47` text COMMENT 'H11b0a71c',
`col_48` text,
`col_49` text,
`col_50` text COMMENT 'H6f14de05',
`col_51` text COMMENT 'H60dbfdbf',
`col_52` text COMMENT 'H6a1aa754',
`col_53` text COMMENT 'H789cc474',
`col_54` text COMMENT 'H138a6a8d',
`col_55` text COMMENT 'Haead44c4',
`col_56` text COMMENT 'Hf1f3c3dc',
`col_57` text COMMENT 'H6ecc864c',
`col_58` text COMMENT 'H1b094a98',
`col_59` text COMMENT 'Hdbb60bad',
`col_60` text COMMENT 'Hce5e7cfd',
`col_61` text COMMENT 'H2f1c312d',
`col_62` text COMMENT 'Hd3a1f844',
`col_63` text COMMENT 'Hf4063821',
`col_64` text COMMENT 'H1aef0a15',
`col_65` text COMMENT 'Hec8f3cb9',
`col_66` text COMMENT 'Hd91bac87',
`col_67` text COMMENT 'H3ad4a3f0',
`col_68` text COMMENT 'Hf10abdb1',
`col_69` text COMMENT 'Hb09f6e9d',
`col_70` text COMMENT 'Hbc1c43f9',
`col_71` text COMMENT 'H67366cd2',
`col_72` text COMMENT 'H14ed768c',
`col_73` text COMMENT 'H4cb05c45',
`col_74` text COMMENT 'H89f2c4e2',
`col_75` text COMMENT 'H88c87cbc',
`col_76` text COMMENT 'H60e22de2',
`col_77` text COMMENT 'H8e4a604f',
`col_78` text COMMENT 'Hc5828415',
`col_79` text COMMENT 'H3731ee5b',
`col_80` text COMMENT 'H31209873',
`col_81` text COMMENT 'Hd278f374',
`col_82` text COMMENT 'H841b5319',
`col_83` text COMMENT 'Hff014055',
`col_84` text COMMENT 'H62e6d336',
`col_85` text COMMENT 'H6440df47',
`col_86` text COMMENT 'H025879eb',
`col_87` text COMMENT 'H94c5c9fe',
`col_88` text COMMENT 'Hde1e8a5e',
`col_89` text COMMENT 'H033bc4ad',
`col_90` text COMMENT 'H4d8cef4f',
`col_91` text COMMENT 'H90178c17',
`col_92` text COMMENT 'H7964dce8',
`col_93` text COMMENT 'H11b5e691',
`col_94` text COMMENT 'Hf3002cdf',
`col_95` text COMMENT 'Hf7a25dea',
`col_96` text COMMENT 'Hb90e89c7',
`col_97` text COMMENT 'H52b9fcc2',
`col_98` text COMMENT 'H2fc3d11d',
`col_99` text COMMENT 'H81090940',
`col_100` text COMMENT 'H4ea717a3',
`col_101` text COMMENT 'H3557e702',
`col_102` text COMMENT 'H0d7ec62f',
`col_103` text COMMENT 'H835d020b',
`col_104` text COMMENT 'Ha78c01f4',
`col_105` text COMMENT 'Ha238aef4',
`col_106` text COMMENT 'H7a400825',
`col_107` text COMMENT 'Hb12d553a',
`col_108` text COMMENT 'H53b33668',
`col_109` text COMMENT 'H15bdaea3',
`col_110` text COMMENT 'Hb62eb488',
`col_111` text COMMENT 'H68ce7441',
`col_112` text COMMENT 'Hd8620cd1',
`col_113` text COMMENT 'H1f4efac7',
`col_114` text COMMENT 'Had3b9abc',
`col_115` text COMMENT 'H51d3dcc2',
`col_116` text COMMENT 'H14162fcd',
`col_117` text COMMENT 'H657b464a',
`col_118` text COMMENT 'He4853c1b',
`col_119` text COMMENT 'H5234759c',
`col_120` text COMMENT 'H1015ffe9',
`col_121` text COMMENT 'H29a3920e',
`col_122` text COMMENT 'H26f0f43e',
`col_123` text COMMENT 'Hd73dbd9c',
`col_124` text COMMENT 'H489f5f33',
`col_125` text COMMENT 'H66f55942',
`col_126` text COMMENT 'H076fe1bb',
`col_127` text COMMENT 'H4801f7d5',
`col_128` text COMMENT 'Hbdddb9ec',
`col_129` text COMMENT 'H28c5a6f4',
`col_130` text COMMENT 'H02ac6c00',
`col_131` text COMMENT 'H4e5e7472',
`col_132` text COMMENT 'H209b2538',
`col_133` text COMMENT 'Hd3f55611',
`col_134` text COMMENT 'Haf54974b',
`col_135` text COMMENT 'H466721e0',
`col_136` text COMMENT 'H3ceea0a9',
`col_137` text COMMENT 'H1b859eeb',
`col_138` text COMMENT 'Hb969a708',
`col_139` text COMMENT 'H6ab8bbc9',
`col_140` text COMMENT 'H26938cb8',
`col_141` text COMMENT 'H966ff9f0',
`col_142` text COMMENT 'Hbb44b4f6',
`col_143` text COMMENT 'H77231f65',
`col_144` text COMMENT 'H7927e90e',
`col_155` text COMMENT 'Hd3fe1d4b',
`col_156` text COMMENT 'H3f6d6e63',
`col_157` text COMMENT 'H3b0d1c59',
`col_158` text COMMENT 'Heb53e3d0',
`col_159` text COMMENT 'H2718c45e',
`col_160` text COMMENT 'H48dacce2',
`col_161` text COMMENT 'H6f6562b4',
`col_162` text COMMENT 'Hb9488464',
`col_163` text COMMENT 'H570ff5cb',
`col_164` text COMMENT 'H63a81ab6',
`col_165` text COMMENT 'H31207bd9',
`col_166` text COMMENT 'Hfb2edff0',
`col_167` text COMMENT 'H22daf7d5',
`col_168` text COMMENT 'H45784aec',
`col_169` text COMMENT 'Hcf942b1a',
`col_170` text COMMENT 'H1624c00b',
`col_171` text COMMENT 'Hd9aac66b',
`col_172` text COMMENT 'Hea5e6b7e',
`col_173` text COMMENT 'Hcf4ddc48',
`col_174` text COMMENT 'H1cd92c1b',
`col_175` text COMMENT 'Hd40366db',
`col_176` text COMMENT 'Hdbab6836',
`col_177` text COMMENT 'H38a10f7b',
`col_178` text COMMENT 'H4783dd61',
`col_179` text COMMENT 'H735bc0fa',
`col_180` text COMMENT 'Hd5bb87f4',
`col_181` text COMMENT 'H1926454b',
`col_182` text COMMENT 'H654b2e9a',
`col_183` text COMMENT 'H4fe56448',
`col_184` text COMMENT 'H17157ace',
`col_185` text COMMENT 'Hf72c4933',
`col_186` text COMMENT 'H763c0287',
`col_187` text COMMENT 'Hf53d795a',
`col_188` text COMMENT 'Hb8890491',
`col_189` text COMMENT 'Ha777b373',
`col_190` text COMMENT 'Hca122daf',
`col_191` text COMMENT 'Hd4fee60d',
`col_192` text COMMENT 'Hc63e1572',
`col_193` text COMMENT 'H1947b03a',
`col_194` text COMMENT 'Hb4fd25ee',
`col_195` text COMMENT 'H61576dd5',
`col_196` text COMMENT 'H86674480',
`col_197` text COMMENT 'Hbf2a654d',
`col_198` text COMMENT 'Hf36a40a5',
`col_199` text COMMENT 'H2f3b2748',
`col_200` text COMMENT 'Hfbd6e27f',
`col_201` text COMMENT 'H760d6735',
`col_202` text COMMENT 'Haa745b4a',
`col_203` text COMMENT 'H8e535397',
`col_204` text COMMENT 'Hd52dd24c',
`col_205` text COMMENT 'H41e3f6a0',
`col_206` text COMMENT 'H6b04ce5f',
`col_207` text COMMENT 'He3a0ab84',
`col_208` text COMMENT 'H5202892b',
`col_209` text COMMENT 'H3556ec50',
`col_210` text COMMENT 'H640df15b',
`col_211` text COMMENT 'H35137791',
`col_212` text COMMENT 'H4b1374a7',
`col_213` text COMMENT 'H02f8a8e3',
`col_214` text COMMENT 'Hd10d05fb',
`col_215` text COMMENT 'Hb7e5ae47',
`col_216` text COMMENT 'H74371f79',
`col_217` text COMMENT 'He5c27df2',
`col_218` text COMMENT 'He74bf708',
`col_219` text COMMENT 'Hebdf8f9c',
`col_220` text COMMENT 'H9d0a64a3',
`col_221` text COMMENT 'H1915acdc',
`col_222` text COMMENT 'Hf19ffbf3',
`col_223` text COMMENT 'Hf8c9c745',
`col_224` text COMMENT 'H2addb30f',
`col_225` text COMMENT 'H8fef7715',
`col_226` text COMMENT 'H0974b151',
`col_227` text COMMENT 'H548c78da',
`col_228` text COMMENT 'H88243ace',
`col_229` text COMMENT 'H0e3e7102',
`col_230` text COMMENT 'H25137b51',
`col_231` text COMMENT 'H92246d4d',
`col_232` text COMMENT 'Hef742307',
`col_233` text COMMENT 'H7e9dd2b1',
PRIMARY KEY (`id`),
KEY `devid` (`devid`)
) ENGINE=InnoDB AUTO_INCREMENT=3408248 DEFAULT CHARSET=utf8;