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


Subject
Views
Written By
Posted
Re: Regarding "[Warning] InnoDB: Cannot add field"
450
August 02, 2021 01:09PM


Sorry, you can't reply to this topic. It has been closed.

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.