MySQL Forums
Forum List  »  InnoDB

Re: Regarding "[Warning] InnoDB: Cannot add field"
Posted by: Stephen Kwok
Date: August 02, 2021 01:09PM

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;

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.