DROP TABLE IF EXISTS test_tab; CREATE TABLE test_tab ( `b_int_1` int(11) DEFAULT NULL, `a_str_18` mediumtext, `b_str_1` varchar(100) DEFAULT NULL, `b_dt_1` datetime DEFAULT NULL, `b_str_2` varchar(40) DEFAULT NULL, `b_dt_2` datetime DEFAULT NULL, `b_str_3` varchar(32) DEFAULT NULL, `a_str_13` mediumtext, `b_str_4` varchar(40) DEFAULT NULL, `b_str_5` varchar(40) DEFAULT NULL, `b_str_6` varchar(50) DEFAULT NULL, `a_int_16` int(11) DEFAULT NULL, `a_int_15` bigint(20) DEFAULT NULL, `a_int_14` bigint(20) DEFAULT NULL, `b_str_7` char(32) DEFAULT NULL, `a_int_13` bigint(20) DEFAULT NULL, `b_str_8` varchar(32) DEFAULT NULL, `b_str_9` varchar(255) DEFAULT NULL, `a_str_28` char(255) DEFAULT NULL, `a_str_27` varchar(255) DEFAULT NULL, `b_str_10` varchar(32) DEFAULT NULL, `a_str_26` varchar(255) DEFAULT NULL, `a_int_17` int(11) DEFAULT NULL, `a_str_6` varchar(50) DEFAULT NULL, `b_str_11` varchar(32) DEFAULT NULL, `b_str_12` varchar(255) DEFAULT NULL, `b_str_13` char(32) DEFAULT NULL, `b_str_14` varchar(32) DEFAULT NULL, `b_str_15` char(32) DEFAULT NULL, `b_str_16` char(32) DEFAULT NULL, `b_int_2` int(11) DEFAULT NULL, `b_str_17` varchar(32) DEFAULT NULL, `b_str_18` varchar(32) DEFAULT NULL, `a_str_25` varchar(40) DEFAULT NULL, `b_str_19` varchar(255) DEFAULT NULL, `a_str_23` varchar(40) DEFAULT NULL, `b_str_20` varchar(32) DEFAULT NULL, `a_str_21` varchar(255) DEFAULT NULL, `a_int_12` bigint(20) DEFAULT NULL, `a_str_20` varchar(255) DEFAULT NULL, `a_int_11` int(11) DEFAULT NULL, `a_str_39` varchar(255) DEFAULT NULL, `a_str_38` varchar(255) DEFAULT NULL, `a_str_37` varchar(255) DEFAULT NULL, `b_str_21` char(32) DEFAULT NULL, `b_str_22` varchar(100) DEFAULT NULL, `b_str_23` varchar(80) DEFAULT NULL, `b_str_24` varchar(32) DEFAULT NULL, `b_str_25` varchar(32) DEFAULT NULL, `b_str_26` char(32) NOT NULL DEFAULT '', `b_str_27` varchar(255) DEFAULT NULL, `a_str_36` varchar(255) DEFAULT NULL, `a_str_33` varchar(100) DEFAULT NULL, `a_ref_10` char(32) DEFAULT NULL, `b_str_28` char(32) DEFAULT NULL, `b_str_29` char(32) DEFAULT NULL, `a_ref_6` char(32) DEFAULT NULL, `a_ref_12` varchar(32) DEFAULT NULL, `a_ref_11` varchar(32) DEFAULT NULL, `a_str_49` varchar(40) DEFAULT NULL, `b_str_30` varchar(32) DEFAULT NULL, `a_ref_3` varchar(32) DEFAULT NULL, `a_str_48` varchar(40) DEFAULT NULL, `b_int_3` int(11) DEFAULT NULL, `a_ref_1` char(32) DEFAULT NULL, `b_str_31` varchar(32) DEFAULT NULL, `b_str_32` varchar(255) DEFAULT NULL, `b_str_33` char(32) DEFAULT NULL, `b_str_34` varchar(32) DEFAULT NULL, `b_str_35` varchar(255) DEFAULT NULL, `a_str_47` varchar(40) DEFAULT NULL, `b_str_36` varchar(255) DEFAULT NULL, `a_str_46` varchar(40) DEFAULT NULL, `b_str_37` varchar(100) DEFAULT NULL, `a_str_45` varchar(255) DEFAULT NULL, `b_str_38` varchar(32) DEFAULT NULL, `b_str_39` char(32) DEFAULT NULL, `b_str_40` varchar(32) DEFAULT NULL, `a_str_41` varchar(255) DEFAULT NULL, `b_str_41` varchar(32) DEFAULT NULL, PRIMARY KEY (`b_str_26`), UNIQUE KEY `a_str_47` (`a_str_47`), UNIQUE KEY `a_str_49` (`a_str_49`), UNIQUE KEY `a_str_33` (`a_str_33`), UNIQUE KEY `a_str_46` (`a_str_46`), UNIQUE KEY `a_str_48` (`a_str_48`), KEY `b_str_18` (`b_str_18`), KEY `a_str_26` (`a_str_26`), KEY `b_str_27` (`b_str_27`,`b_str_19`), KEY `b_str_41` (`b_str_41`), KEY `b_str_15` (`b_str_15`), KEY `a_str_20` (`a_str_20`), KEY `b_str_17` (`b_str_17`), KEY `b_str_40` (`b_str_40`), KEY `b_str_24` (`b_str_24`), KEY `b_str_10` (`b_str_10`), KEY `b_str_16` (`b_str_16`), KEY `b_str_29` (`b_str_29`), KEY `a_str_41` (`a_str_41`), KEY `b_str_7` (`b_str_7`), KEY `a_str_45` (`a_str_45`), KEY `a_str_28` (`a_str_28`), KEY `a_str_37` (`a_str_37`), KEY `b_str_6` (`b_str_6`), KEY `a_ref_6` (`a_ref_6`), KEY `b_str_34` (`b_str_34`), KEY `b_str_38` (`b_str_38`), KEY `a_ref_10` (`a_ref_10`), KEY `b_str_21` (`b_str_21`), KEY `b_str_23` (`b_str_23`,`b_str_19`), KEY `b_str_33` (`b_str_33`), KEY `a_ref_12` (`a_ref_12`), KEY `a_str_18` (`a_str_18`(255)), KEY `a_str_39` (`a_str_39`), KEY `a_str_27` (`a_str_27`), KEY `a_str_25` (`a_str_25`), KEY `b_str_9` (`b_str_9`), KEY `a_str_23` (`a_str_23`), KEY `b_str_8` (`b_str_8`), KEY `a_str_21` (`a_str_21`), KEY `b_str_3` (`b_str_3`), KEY `b_str_30` (`b_str_30`), KEY `b_str_12` (`b_str_12`), KEY `b_str_25` (`b_str_25`), KEY `b_str_13` (`b_str_13`), KEY `a_str_38` (`a_str_38`), KEY `a_str_13` (`a_str_13`(255)), KEY `a_str_36` (`a_str_36`), KEY `b_str_28` (`b_str_28`), KEY `b_str_19` (`b_str_19`), KEY `b_str_11` (`b_str_11`), KEY `a_ref_1` (`a_ref_1`), KEY `b_str_20` (`b_str_20`), KEY `b_str_14` (`b_str_14`), KEY `a_ref_3` (`a_ref_3`), KEY `b_str_39` (`b_str_39`), KEY `b_str_32` (`b_str_32`), KEY `a_str_6` (`a_str_6`), KEY `b_str_5` (`b_str_5`), KEY `b_str_31` (`b_str_31`), KEY `a_ref_11` (`a_ref_11`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; SELECT 'Inserting new row'; INSERT INTO test_tab (b_str_26, `a_str_13`, `a_str_18`) VALUES ('a', 'Sumn2HEJ27Iq3ZwVu0UkfKT2TaTiMS3sWMPowdkoGT7y3aiLhugvGW5YUUBT3cQUagrWKYVtaumzklyO1CRBK20IjHNdvLfasWZLrpPIwnhfbbEkeFfU6XUydQ1yOg3zrJbmsfjwyZaHpLIDCsp0ZAIudVY1IR6Y316L9SZOIWJC6xO1N9XOCuO08PyPBi0ouwiTVQ7MQT4KJjP9EaHCyccPUdEq6uNUiUtov2tXTtHM5sCTLCnc20LVR1x87yLszZ5bethX76U9vuRr8DTWV7VlVzD9OzfePJiLkpykh9M47wvQbGvQ4uDNRMmdxsQlwGvt9kpchuW18wWOGrXVC4mTKrO7WNwCiGPREH8HvXQzYqoq1PygoGaN2YNsyTXVBuB4pn8AlcKdTbq2UNWo7NPvDYV5Frzxco3U0PUMRkKCuM0RHRpVr98OOetgzkgE7i6NYkWL7U2ASabJyJm9w9dH5eqlofEIB037gkY4Lt2eFW4MpVrEmgcFt7bJxhQDdDx2UfgNwQyWvUkAQJJl3W9qHeDIa3Lcbh5EM0tBPeZ20EuwS3kbocUDvADIkltqu5Y0pUkoXmllxc6XakG8kuaQmlJkAl2kO2BcwhqNaf64S1r1hFUWdb8lqnYQ0dbzBisyPIX4sh118VvDwRKSdMcqTbLvuJmt0GbjJ8oA9tlWspRdzmZfEYwWAt25XRCifsaNxzDinC2UeSUccxAEApFgWst8iplqEIiacBTeK3mwgeklsaZ4Wuxd21E6AXlaWrxSLjogybnfsro8xP1tbHYZUzimHaHNkNW9rMr21X9yMdJO2jMMcA1Sbt9mWFCYCS9YD3iKz948nti9nar0qVqCSI0tloW3py07CJbhslhTzWTe85mVjiaitM0T9a5tXciyAFyuZlomsZXMKD20iWJjk5bcBBYl8slxFyS1hgBjxWTvMcOktynITygTbDj0I26FWT0o8MAhZ0Yl0NxkRjX86Srdgo8XbeDCXuur5pagDTjaRyQAjasqpEyEFqQu4jtFbMOEce7St7HPVUpi6zxuMw4SM5WC4UqH9NgFcvlKdPQicBkn4LK5fCBfXJ3rOcPb7e1Ba2tkC60ryC8oa8rcTH8tDlESJMtkMthXfCrmDw4ObBiYtzzI66twBodDOuq0m0uuuzrRkdbnj7bc7lvYOgykr6Wn4iiF5d1bpEyjMVoeXrB0D3Pb2N8HpOs4dsDGc8bHvLb4eSnzdNmel2jK7bOejZ0s5ZK5SZVibgQsBvk5yvFaLwA7OkLmovayJsTIetG2w2nwcki6whD7YhhAKxuejw7h2z0Jla4ISYtQDkFmUlqPhgQ2OoBIA9AL8qUGCOrJ9pwtQJhadNggM2dgYaw71KtYrtY4O87GobetwyD5HRD56RrFuECa0LZTmLAbTs59haH4AXUyUymvMBZhMmm0Qvp2KpmTtpU5QGiFv7Oqj1KH8jNjuM9Hl38tybRBmucLnI2s2lLK17GLDnemOSsZaJyefHWcZFILKsgJoCj68hO41SCIxcdXdeiqv96hcDrjQaIDeR6l8lVb7lr8dqvcVZJqZPs6J37Zx3tnTZVIjGAa5LDv3vSVPQ1qvMR41tgMoR2tkP6Zd8CVWxZNV2OcD0kXB4xaNyX1Zr2UMoEMfRJvBCbPU2Mk4A7k9p0mXW3Bm5UcYOe8coLYQfm3eA85s8VK97W2BY2Cm2SG2iQ7mdAM7zsRfb7qXqnQwfwyXXM7kXHi5KDedEIOtVVI8VGNQD8AfSqYBkPUcHuE5V0KPLRb7v9G869Qp0GW3s4f6avKQIil8urTpJlBAuQ4aOL0hujSlwM6nBCGFSfZUmHdIdQLdubQSamP5EqmUqGZ1MadZO1Qx6dXS9LvKo4s5BWmKzTvz40N5NHmb46a84QbZy4u6ztINmOtnJ9xBsppDm6UwZU3U2qgkEPMYR3WYlJ8dJuntHZlEZCKCyhEI6MisJNNSESeoNu5ssSYAbzoCJcRlN7Tiz71eDsfqnqK3dxn8unsusblwcXhOHEiNW66mpJFWkw8FVTPx8JOkkaibpih3VN1FusmtscSNCkOjuhlDBni2R0V5qQJ4UDETl8kooPknZopF1pZbpMKswsBaJIylvOfM60F2BDy8b50ScXvP2vxARkdZ6RlLicJ1Bl8XQOJipyiJMbY07h9ixItHjDDfBCmMKC6KcGmPBqAVq1Lg4nu2IxthzAeYIlA2XOlNqbG90Xotn4UKa3zJb0OPMr9qjnJ89OU1ouVynvjPFwSsJqkuIb3t0ezPyfk2ADgzT4NrVvpne4X3jTLPW8owbHnFsfeY6WEp9Wb12L6OnsXY6LUFkBiASHP0DG9M1DgRo2Bnfd3ft1wBcBxGW0jZzucsuxEo4g4vpdmDmD2KfIggIRV6l9gFg7qf5gJYU9EKQgANJj18vuDYGpKkw17GysNCX59P0CcA7EwE54tdgwaS4BUgktqCJILr7gr9G3e7zzUo6f79Ey2ZOXgR2Xs9TrJdXCgGpIiZ7JldrKzumOUtKlLOUdahzC2kTS0DlGWHySypUTd6sYegrWbbPK2la3Qv98gSb48SXQGHgx5EyOcoPbObjJthPQO3SdTo8GaqtQXnTy6cu82o8piGg8PwRsTUPBKuQGOXWWT6CbsLOiloC50X13SeyhHWhAJ1SALW3k9lWvmfWlm7tHwZb4Dlxj6QpDe17bjt98tPbq4CYn8Z1R5WrT6Y7ZGi9OexhEufeoaibANRv4HjvDPxA8Ezc4yWWdXWyH8POn0MhycwQhmYKr78j1Njw2hibhtGOoa3nyVj9erviB4AV6roCqMZfwrFUQDmcHcGTgekJXPpLlFUnjgHZ3kp517c65CsDFk4zSN7JAR98gbk5GT0YyQHMDj5SMrTGsMd9JbS5lwiyvigaausHUqWXontzEz8j0KPp1rgJ8tvclmuPTUZ45OMVynM64SsmIs9SXQb9MgWmi6BQG1t30oBLaepNz6e8vEIpoDcZ7smEwBhZTBcFGfQ0HMVjPozVO46ybyk65rJz6Yk90wLu8QX35QPlstRBTVElXsdRlRjH0J8GgjYsK1xfbdPUPnYZSNFn9Tu2LkEhYfqLfLBwbzK1eu6MrRJXbDXIxuGn3AQedkEeLFOXK28bArVC3Rt72rYULrzgGWMN2sEyCwDduwHyhpwMBX5fZH8ecNtVqS1zY7xdPudzssT6q4cpaKDupqQ0Jn8ZEGaJvC1gUtS0PbdemOadC87uPImXDOZ0Yx0tlt0DjOYhBjESMfNBwJNX2S0W8nW93ylFm2LXTgZrcSplo37oGjgLP6fCku2dqUeWVAJ8JoyREEqXYpUEwLib2g1ekrIwNCu8H73pJkU2qwOMg6AG4m2ARVylUrLOcGTToH5KoulV46IN1szJRCi7F7YZBBBPmGz4lSPGo8r6S4ve2Krb2B3xUy9n7i60JCwc3EdDpjaT5h0Tn96ae1OfHTGxfrLkdvaqvJQjrMCp381Mp0lS4dwEsUcCOeTwFxgQ0SxXcIM8R0lQGcBwldEKts3e7eTWwqYzycSFB0rPCrK9T0mYDICJyZRV43B3h5OFz7dNXhC5FqVBf2xd4kbYcZMQUFOmWRAmvxVmqM4CAaZUjZhpjWY8mQOEzYSnAqGFCByFoPfI8wqbr0LnuJfemB7hcyceSCqybusrzXnP5VSUXwf50KXMQ7XZbTMdFdBSlmRZefBrlqyxiJM2PqTErBRBwLI8lgethKdXbZWdqQKjIr8LjvzbWJ1P6lVVLzgudMX7KfCN0bnFcgMr6jyt6g39FZ4UnM8eDVPtSSwGcPu3HUTzdWdKPbtX0vuz71fb1JbiuPkZJDLk2bfuNZOfJFfw2FG0vB7h62NRbV5cVY2jgrZkY9xe2ZfamZjDfaXaLBXEDni1amBwGKQLNKMg1G5NlbCxzUjfBgfSYl4aJr7lBsJZ3RemU156O7wtFD43', 'XnvAjtBSjx3wygseDVYsStGyrwA4GAVSWxFuKU8xSR3e0FA4UwErxMm4dTHS7jb9Q81szAi9xalyPWV5Qw8fblPU6T8R7puqn5W6fj1HvIc8oaChWKmzsI27FEo9ttjh9j0jpClZeLlie9Rwp1JDzUdke74dbbAaFLaeoppZ0RNLDBN85fBCcjhm49OLzLA8ISuSJ01Wr7Deh1tW8X8Il5Ec7s6A7Rbvea5APd8vFxb697wdPt8PhTWRAKHnYCdDVCiqLg6Ek6GRrkBqUakdV5ZzYZmoZ26BozNMyaqFvKZzzFwZdtY0VXo7JWrMeyMqfkOnXpskGnriIzrc6Q5tDz9lNMeTwITU2xG3kNjXceGYrMFTmoLGnSLirUo62rfrXnV24xqF34w8tubL8SDBswdl7ldxTuQpAlvCIYmlwwkOUMXCaNP7nwZUvXoAK4yZ1G75xmt7AKMG0Z4AZMHZN76kpF61AWAwWnJyi4WRmM1rkd6SFycocw2uCFM3XRLyuCKt5l0wAEr5UKS3gtJQujaxslCqdzfQsJM5E34V1P7AfsIgfo42JY1GhbkbU7InnPvaR2EDMH3YxEIqztIe1y4tMgIQsVZXxrYjBwpDDW921DODoROnOjwCwMrCtNqeI5W3RqXANcWnCUKJwcpr0efcHo8RQrKwYt0HdbLhUzt7HA6EBgEWp67AnHX4yPtZOmovPOnHENG9kxUVqHgrtQENbnpe7zHvRmOLkhEtKoZ4Vrb1qMvTnXr8v3Eam6XL6vgOct8YDYlmQbLO1eJReNMPS8RwIsAPN8VBu5ZSlfxk1SyuXUcNJ3ZkMxzuDag1eQLf56TuWwSn02RWQLZmMAYDj2I7jSbxuQD2OI5giMUwinHdMROzCECIyKdf0fhu12CK1u7Vn3caamYSL0gyJJBCuogsBNVyH1RfVmPkcCComLrWq5vKGPp3xF0cvdZWznNhF1Pq53uxy2JLukl1KWFGv9ueJ6Brfxkv4IGWpMrMUkYuvvG7GpKESrMjAmOvGO7nwuAYAExH5YCi2zj3Rvawg02iyHHjM3bqdamMmuO2c9KVskKuCG8Vu7WVN55wFdG9h9lH3ZzkrhS3CH0H22phzK6e3tSMCTH0uQnguN0sZchgiNRPTAQlOp6miBglAZIONsyZix4VS6VZwQ0VttIKSRlyvh5UnpgnSD8Eh8YulSBZf93dZWf6jPgB4LA352s40cIGVTW61SHBe5UkAcRC5jVWMBCsthLz9TYGzeOq1KDUEytVJBFSkbkWhNiHJ29AluNNkv22NGNODtp2wugOFDywg0HSv7EB48nPi4XBbLwEthnhI4W8lEMvGhTgDMaQSp5T31rzMdkpEZTpzpyiVpcekFgy2NPpUty83oNcG6s6nzenMXdXSYJEcamPKyhiostyDMq9qoBdnCUck73qEk1HQvgSPCSc92BDZxf6tfJTUJmDN0riVVsA8WjnimYAsTZU4MpFiV6I1Av93PYfe0bLI7bEwXVILTFLSykelscwbt3oeTWKCqHX2nLf2IGu1J0r1Wl97JyYi1BxFsGf8nwVEr1kHRgKbf89xjBKWudvny6GoKsnhSaaKD7pY3BtIfxDp47PTZFDNR74ZKkDgssO75Z9HecB9KgjtsEe90SJgEzBhLHQTXOcFg5FL81LFtmi7mDynggbzduJROHJXeMFeqiBTsDET3FUI4OHNS1VHrZTfyExJT1d6ideliaal5VJaYm7NSFb70dkavHfbvN3LxC5B0TCEC7D0XJhGUznMHpFjvUrYoM5gjCtMOyi13u7YUoz5Rq9n1h11BPY0bqow8XY7DzyY7Et5LRu7955EoshTRMacXdsCBHKiB3k6SdSckQ3lcuIHMd1numUqvMLTkfFht0umjQeq5BxWEWojrBDjPiQhOValFTpO3NHbhDBUkp5uYmhkVtUkPTNUL2FFFda1TLi4x1uK9xlQJjvWFA9Vhqx2fnFnmvOwfGZ8VXf8lWR2EHby1Zxk3xLNKh6Qih9T6KA6NYDImtBJzcgmzFUGaEDXMgOBnQ1hnXGP7yO8a5YsHlFhDw9dhYk07W5HaXxfzq0E3CqZbnG7v15Fq0yJvGax33EamJ40hK06g9LyIERWup1Bgt3ac8NorPvUBihMbcxjvh8qyu45XVRG2GGS1sVfMwUZqqn3TjvqZUFPJun5Ry5xE3NSVFQZbh8PYLEGDQBRXCWTaPcMGkod7YkcZHozpgyBizXNBgHRmGbqU7a5aRAkXg9u0LbxwTDMbeAYDtGgpkWOWEFz357pMcBZxXhC58yttm5hWXdGJO5Gmnvt5SqY5MZLmwfrVDTrFDz773XhLDbHqPDDWGJ9x34Y1ef4Adoco8m1LAeyeZwO9NNJY7BSFXAzmdKogHFClfuZX7FTjv7IGlr8JEOdSodAaDj2xd0XAtDFvXt0XCvKls7AlprJXY65cDqOtqrS411GOLrNDCSxoiiST34LRHUJnJLo7oDWHpUukjjeaBYSdK7jZJBMmLQphVSE6f6Jj1AZOtGWYAdQYuROtRiixINaXxTopbM17Q4jKtnif25yFTE1iwkodLLsKVOjCaPOd4KV3xqgSmZuiyy6Py1j3oRx8y8QfSMQwapIo4macbhrhZGeuAMPJltRPquek4jkGnLDfLJEnzEQqCrOCg6YWNpervBM1X0KNwDn76Fk2SbBuWP3skTOBbL8UtnmhY79MRMQI1tVaHjyZFg20IkXIq65et7STqhOVCnWqf7ih2ZckmjZbmWeGNTwkJSqHNIwfX5PVQMr2qHzOTSM6HtVXtnnOrKj93pppONYR1WMx6exQnNvC7YXVQtepV87gHnbdoESP2rg7mhlk0MiO3dAyrV5rXN47KcdlIAq1sw1YsQC1us1vglDKpxTJS64bvkBEUksc1KbpVM05rUhV6LG1VrqKkUqKcZJNHQrkGEwKKCzaZsqQe0msCnRdGm8RYLTFIeTfCICXSgWmo0LvFU4FXKqwEQaRqCTekfFT81qJZh4TcJgHvfIWnlXyFFPtLhP1b8KzHohul4sd5QpeOpwyBLG0Y77gG5AEhoFnRAJLZLRIhYtlnnH4aW1FVW4FVm0oziMoFpEQIwHoWUMCWhV1nwZZiTVcy1h9Uu7ClsGCShz06UpY231Ee3OizjaNqyZt25qNM4JRwyIMo52hCaZtyqqFj9pfpsC0By54G4uwPKPLSzBipUMuoJ9DpH75edgjlvutqYxHYcxoR7tV2EHgm9BNNVhugFDJayDwwJdyHd1ASs6yExIMusi3OwX0CKQKg13QHii9yONi6kZnBa7DeklvYFsietQefUwn8DqnYmRlUxB5NVzD4AZaQ3quhhixHdLGNGN536W6nX893In1U1nsjS1A6OFWnyK6ishY44cJMIUxWead3NUSI2jNICgOXUb9R6pdIxPi5LsZ6b3c7XmUlKbCLR7qS8U33L1mZeDjsx7XmbGZ2zxtT8FnblZ22JuCU0vQ7GjDvBIYbnDJ2e2k0dTYjk8MzL0CqbQuQRzAOVzsMvRcsPMzCj0MkXomMLZbUJHEVEBx3kygZ1nvsIMpYl2TE5dK4WHP4KuSGFDGKTxGWAbeVkDnW5KylqlT3nrbSUsZA9QTtrPjbNOmyqFAxZLKvsoUoAMHByQDeMdUGWOnpPUa9OGyYqCdYOXhE8wZTAHxZ8864TR2NKyp1MtWcOdP9XAVL3wTfwzjs9fqZLK1oBs68gwAbFoaNbncOoXPGa4iOIMpIMrUY3ryfML8A4kDJsYnAwJcc8mL2RqpCzzPg0Wj43wx4XUHKTCcPhv4efkeh9sZinIPH0F4kGcejZRkSYnrObkVdoAbYfLQabhPjvUYO3PVtsIiFIcpu1x4pTBHmk7zLJHu3S6SrKm2YBYTZaKi2YEFi2RyBvAaf6BRtdbMpjrshU5t1GOu3N7TvVVkM8jjrJiCLngf1HMYeQeT' ); SELECT LENGTH(a_str_13), LENGTH(a_str_18) FROM test_tab; SELECT 'Next update should fail (length >= 3962 && length <= 4030)'; UPDATE test_tab SET `a_str_13`=CONCAT(`a_str_13`, 1), `a_str_18`=CONCAT(`a_str_18`, 1); SELECT 'Truncating table'; TRUNCATE test_tab; SELECT 'Inserting new row'; INSERT INTO test_tab (b_str_26, `a_str_13`, `a_str_18`) VALUES ('a', 'Sumn2HEJ27Iq3ZwVu0UkfKT2TaTiMS3sWMPowdkoGT7y3aiLhugvGW5YUUBT3cQUagrWKYVtaumzklyO1CRBK20IjHNdvLfasWZLrpPIwnhfbbEkeFfU6XUydQ1yOg3zrJbmsfjwyZaHpLIDCsp0ZAIudVY1IR6Y316L9SZOIWJC6xO1N9XOCuO08PyPBi0ouwiTVQ7MQT4KJjP9EaHCyccPUdEq6uNUiUtov2tXTtHM5sCTLCnc20LVR1x87yLszZ5bethX76U9vuRr8DTWV7VlVzD9OzfePJiLkpykh9M47wvQbGvQ4uDNRMmdxsQlwGvt9kpchuW18wWOGrXVC4mTKrO7WNwCiGPREH8HvXQzYqoq1PygoGaN2YNsyTXVBuB4pn8AlcKdTbq2UNWo7NPvDYV5Frzxco3U0PUMRkKCuM0RHRpVr98OOetgzkgE7i6NYkWL7U2ASabJyJm9w9dH5eqlofEIB037gkY4Lt2eFW4MpVrEmgcFt7bJxhQDdDx2UfgNwQyWvUkAQJJl3W9qHeDIa3Lcbh5EM0tBPeZ20EuwS3kbocUDvADIkltqu5Y0pUkoXmllxc6XakG8kuaQmlJkAl2kO2BcwhqNaf64S1r1hFUWdb8lqnYQ0dbzBisyPIX4sh118VvDwRKSdMcqTbLvuJmt0GbjJ8oA9tlWspRdzmZfEYwWAt25XRCifsaNxzDinC2UeSUccxAEApFgWst8iplqEIiacBTeK3mwgeklsaZ4Wuxd21E6AXlaWrxSLjogybnfsro8xP1tbHYZUzimHaHNkNW9rMr21X9yMdJO2jMMcA1Sbt9mWFCYCS9YD3iKz948nti9nar0qVqCSI0tloW3py07CJbhslhTzWTe85mVjiaitM0T9a5tXciyAFyuZlomsZXMKD20iWJjk5bcBBYl8slxFyS1hgBjxWTvMcOktynITygTbDj0I26FWT0o8MAhZ0Yl0NxkRjX86Srdgo8XbeDCXuur5pagDTjaRyQAjasqpEyEFqQu4jtFbMOEce7St7HPVUpi6zxuMw4SM5WC4UqH9NgFcvlKdPQicBkn4LK5fCBfXJ3rOcPb7e1Ba2tkC60ryC8oa8rcTH8tDlESJMtkMthXfCrmDw4ObBiYtzzI66twBodDOuq0m0uuuzrRkdbnj7bc7lvYOgykr6Wn4iiF5d1bpEyjMVoeXrB0D3Pb2N8HpOs4dsDGc8bHvLb4eSnzdNmel2jK7bOejZ0s5ZK5SZVibgQsBvk5yvFaLwA7OkLmovayJsTIetG2w2nwcki6whD7YhhAKxuejw7h2z0Jla4ISYtQDkFmUlqPhgQ2OoBIA9AL8qUGCOrJ9pwtQJhadNggM2dgYaw71KtYrtY4O87GobetwyD5HRD56RrFuECa0LZTmLAbTs59haH4AXUyUymvMBZhMmm0Qvp2KpmTtpU5QGiFv7Oqj1KH8jNjuM9Hl38tybRBmucLnI2s2lLK17GLDnemOSsZaJyefHWcZFILKsgJoCj68hO41SCIxcdXdeiqv96hcDrjQaIDeR6l8lVb7lr8dqvcVZJqZPs6J37Zx3tnTZVIjGAa5LDv3vSVPQ1qvMR41tgMoR2tkP6Zd8CVWxZNV2OcD0kXB4xaNyX1Zr2UMoEMfRJvBCbPU2Mk4A7k9p0mXW3Bm5UcYOe8coLYQfm3eA85s8VK97W2BY2Cm2SG2iQ7mdAM7zsRfb7qXqnQwfwyXXM7kXHi5KDedEIOtVVI8VGNQD8AfSqYBkPUcHuE5V0KPLRb7v9G869Qp0GW3s4f6avKQIil8urTpJlBAuQ4aOL0hujSlwM6nBCGFSfZUmHdIdQLdubQSamP5EqmUqGZ1MadZO1Qx6dXS9LvKo4s5BWmKzTvz40N5NHmb46a84QbZy4u6ztINmOtnJ9xBsppDm6UwZU3U2qgkEPMYR3WYlJ8dJuntHZlEZCKCyhEI6MisJNNSESeoNu5ssSYAbzoCJcRlN7Tiz71eDsfqnqK3dxn8unsusblwcXhOHEiNW66mpJFWkw8FVTPx8JOkkaibpih3VN1FusmtscSNCkOjuhlDBni2R0V5qQJ4UDETl8kooPknZopF1pZbpMKswsBaJIylvOfM60F2BDy8b50ScXvP2vxARkdZ6RlLicJ1Bl8XQOJipyiJMbY07h9ixItHjDDfBCmMKC6KcGmPBqAVq1Lg4nu2IxthzAeYIlA2XOlNqbG90Xotn4UKa3zJb0OPMr9qjnJ89OU1ouVynvjPFwSsJqkuIb3t0ezPyfk2ADgzT4NrVvpne4X3jTLPW8owbHnFsfeY6WEp9Wb12L6OnsXY6LUFkBiASHP0DG9M1DgRo2Bnfd3ft1wBcBxGW0jZzucsuxEo4g4vpdmDmD2KfIggIRV6l9gFg7qf5gJYU9EKQgANJj18vuDYGpKkw17GysNCX59P0CcA7EwE54tdgwaS4BUgktqCJILr7gr9G3e7zzUo6f79Ey2ZOXgR2Xs9TrJdXCgGpIiZ7JldrKzumOUtKlLOUdahzC2kTS0DlGWHySypUTd6sYegrWbbPK2la3Qv98gSb48SXQGHgx5EyOcoPbObjJthPQO3SdTo8GaqtQXnTy6cu82o8piGg8PwRsTUPBKuQGOXWWT6CbsLOiloC50X13SeyhHWhAJ1SALW3k9lWvmfWlm7tHwZb4Dlxj6QpDe17bjt98tPbq4CYn8Z1R5WrT6Y7ZGi9OexhEufeoaibANRv4HjvDPxA8Ezc4yWWdXWyH8POn0MhycwQhmYKr78j1Njw2hibhtGOoa3nyVj9erviB4AV6roCqMZfwrFUQDmcHcGTgekJXPpLlFUnjgHZ3kp517c65CsDFk4zSN7JAR98gbk5GT0YyQHMDj5SMrTGsMd9JbS5lwiyvigaausHUqWXontzEz8j0KPp1rgJ8tvclmuPTUZ45OMVynM64SsmIs9SXQb9MgWmi6BQG1t30oBLaepNz6e8vEIpoDcZ7smEwBhZTBcFGfQ0HMVjPozVO46ybyk65rJz6Yk90wLu8QX35QPlstRBTVElXsdRlRjH0J8GgjYsK1xfbdPUPnYZSNFn9Tu2LkEhYfqLfLBwbzK1eu6MrRJXbDXIxuGn3AQedkEeLFOXK28bArVC3Rt72rYULrzgGWMN2sEyCwDduwHyhpwMBX5fZH8ecNtVqS1zY7xdPudzssT6q4cpaKDupqQ0Jn8ZEGaJvC1gUtS0PbdemOadC87uPImXDOZ0Yx0tlt0DjOYhBjESMfNBwJNX2S0W8nW93ylFm2LXTgZrcSplo37oGjgLP6fCku2dqUeWVAJ8JoyREEqXYpUEwLib2g1ekrIwNCu8H73pJkU2qwOMg6AG4m2ARVylUrLOcGTToH5KoulV46IN1szJRCi7F7YZBBBPmGz4lSPGo8r6S4ve2Krb2B3xUy9n7i60JCwc3EdDpjaT5h0Tn96ae1OfHTGxfrLkdvaqvJQjrMCp381Mp0lS4dwEsUcCOeTwFxgQ0SxXcIM8R0lQGcBwldEKts3e7eTWwqYzycSFB0rPCrK9T0mYDICJyZRV43B3h5OFz7dNXhC5FqVBf2xd4kbYcZMQUFOmWRAmvxVmqM4CAaZUjZhpjWY8mQOEzYSnAqGFCByFoPfI8wqbr0LnuJfemB7hcyceSCqybusrzXnP5VSUXwf50KXMQ7XZbTMdFdBSlmRZefBrlqyxiJM2PqTErBRBwLI8lgethKdXbZWdqQKjIr8LjvzbWJ1P6lVVLzgudMX7KfCN0bnFcgMr6jyt6g39FZ4UnM8eDVPtSSwGcPu3HUTzdWdKPbtX0vuz71fb1JbiuPkZJDLk2bfuNZOfJFfw2FG0vB7h62NRbV5cVY2jgrZkY9xe2ZfamZjDfaXaLBXEDni1amBwGKQLNKMg1G5NlbCxzUjfBgfSYl4aJr7lBsJZ3RemU156O7wtFD4', 'XnvAjtBSjx3wygseDVYsStGyrwA4GAVSWxFuKU8xSR3e0FA4UwErxMm4dTHS7jb9Q81szAi9xalyPWV5Qw8fblPU6T8R7puqn5W6fj1HvIc8oaChWKmzsI27FEo9ttjh9j0jpClZeLlie9Rwp1JDzUdke74dbbAaFLaeoppZ0RNLDBN85fBCcjhm49OLzLA8ISuSJ01Wr7Deh1tW8X8Il5Ec7s6A7Rbvea5APd8vFxb697wdPt8PhTWRAKHnYCdDVCiqLg6Ek6GRrkBqUakdV5ZzYZmoZ26BozNMyaqFvKZzzFwZdtY0VXo7JWrMeyMqfkOnXpskGnriIzrc6Q5tDz9lNMeTwITU2xG3kNjXceGYrMFTmoLGnSLirUo62rfrXnV24xqF34w8tubL8SDBswdl7ldxTuQpAlvCIYmlwwkOUMXCaNP7nwZUvXoAK4yZ1G75xmt7AKMG0Z4AZMHZN76kpF61AWAwWnJyi4WRmM1rkd6SFycocw2uCFM3XRLyuCKt5l0wAEr5UKS3gtJQujaxslCqdzfQsJM5E34V1P7AfsIgfo42JY1GhbkbU7InnPvaR2EDMH3YxEIqztIe1y4tMgIQsVZXxrYjBwpDDW921DODoROnOjwCwMrCtNqeI5W3RqXANcWnCUKJwcpr0efcHo8RQrKwYt0HdbLhUzt7HA6EBgEWp67AnHX4yPtZOmovPOnHENG9kxUVqHgrtQENbnpe7zHvRmOLkhEtKoZ4Vrb1qMvTnXr8v3Eam6XL6vgOct8YDYlmQbLO1eJReNMPS8RwIsAPN8VBu5ZSlfxk1SyuXUcNJ3ZkMxzuDag1eQLf56TuWwSn02RWQLZmMAYDj2I7jSbxuQD2OI5giMUwinHdMROzCECIyKdf0fhu12CK1u7Vn3caamYSL0gyJJBCuogsBNVyH1RfVmPkcCComLrWq5vKGPp3xF0cvdZWznNhF1Pq53uxy2JLukl1KWFGv9ueJ6Brfxkv4IGWpMrMUkYuvvG7GpKESrMjAmOvGO7nwuAYAExH5YCi2zj3Rvawg02iyHHjM3bqdamMmuO2c9KVskKuCG8Vu7WVN55wFdG9h9lH3ZzkrhS3CH0H22phzK6e3tSMCTH0uQnguN0sZchgiNRPTAQlOp6miBglAZIONsyZix4VS6VZwQ0VttIKSRlyvh5UnpgnSD8Eh8YulSBZf93dZWf6jPgB4LA352s40cIGVTW61SHBe5UkAcRC5jVWMBCsthLz9TYGzeOq1KDUEytVJBFSkbkWhNiHJ29AluNNkv22NGNODtp2wugOFDywg0HSv7EB48nPi4XBbLwEthnhI4W8lEMvGhTgDMaQSp5T31rzMdkpEZTpzpyiVpcekFgy2NPpUty83oNcG6s6nzenMXdXSYJEcamPKyhiostyDMq9qoBdnCUck73qEk1HQvgSPCSc92BDZxf6tfJTUJmDN0riVVsA8WjnimYAsTZU4MpFiV6I1Av93PYfe0bLI7bEwXVILTFLSykelscwbt3oeTWKCqHX2nLf2IGu1J0r1Wl97JyYi1BxFsGf8nwVEr1kHRgKbf89xjBKWudvny6GoKsnhSaaKD7pY3BtIfxDp47PTZFDNR74ZKkDgssO75Z9HecB9KgjtsEe90SJgEzBhLHQTXOcFg5FL81LFtmi7mDynggbzduJROHJXeMFeqiBTsDET3FUI4OHNS1VHrZTfyExJT1d6ideliaal5VJaYm7NSFb70dkavHfbvN3LxC5B0TCEC7D0XJhGUznMHpFjvUrYoM5gjCtMOyi13u7YUoz5Rq9n1h11BPY0bqow8XY7DzyY7Et5LRu7955EoshTRMacXdsCBHKiB3k6SdSckQ3lcuIHMd1numUqvMLTkfFht0umjQeq5BxWEWojrBDjPiQhOValFTpO3NHbhDBUkp5uYmhkVtUkPTNUL2FFFda1TLi4x1uK9xlQJjvWFA9Vhqx2fnFnmvOwfGZ8VXf8lWR2EHby1Zxk3xLNKh6Qih9T6KA6NYDImtBJzcgmzFUGaEDXMgOBnQ1hnXGP7yO8a5YsHlFhDw9dhYk07W5HaXxfzq0E3CqZbnG7v15Fq0yJvGax33EamJ40hK06g9LyIERWup1Bgt3ac8NorPvUBihMbcxjvh8qyu45XVRG2GGS1sVfMwUZqqn3TjvqZUFPJun5Ry5xE3NSVFQZbh8PYLEGDQBRXCWTaPcMGkod7YkcZHozpgyBizXNBgHRmGbqU7a5aRAkXg9u0LbxwTDMbeAYDtGgpkWOWEFz357pMcBZxXhC58yttm5hWXdGJO5Gmnvt5SqY5MZLmwfrVDTrFDz773XhLDbHqPDDWGJ9x34Y1ef4Adoco8m1LAeyeZwO9NNJY7BSFXAzmdKogHFClfuZX7FTjv7IGlr8JEOdSodAaDj2xd0XAtDFvXt0XCvKls7AlprJXY65cDqOtqrS411GOLrNDCSxoiiST34LRHUJnJLo7oDWHpUukjjeaBYSdK7jZJBMmLQphVSE6f6Jj1AZOtGWYAdQYuROtRiixINaXxTopbM17Q4jKtnif25yFTE1iwkodLLsKVOjCaPOd4KV3xqgSmZuiyy6Py1j3oRx8y8QfSMQwapIo4macbhrhZGeuAMPJltRPquek4jkGnLDfLJEnzEQqCrOCg6YWNpervBM1X0KNwDn76Fk2SbBuWP3skTOBbL8UtnmhY79MRMQI1tVaHjyZFg20IkXIq65et7STqhOVCnWqf7ih2ZckmjZbmWeGNTwkJSqHNIwfX5PVQMr2qHzOTSM6HtVXtnnOrKj93pppONYR1WMx6exQnNvC7YXVQtepV87gHnbdoESP2rg7mhlk0MiO3dAyrV5rXN47KcdlIAq1sw1YsQC1us1vglDKpxTJS64bvkBEUksc1KbpVM05rUhV6LG1VrqKkUqKcZJNHQrkGEwKKCzaZsqQe0msCnRdGm8RYLTFIeTfCICXSgWmo0LvFU4FXKqwEQaRqCTekfFT81qJZh4TcJgHvfIWnlXyFFPtLhP1b8KzHohul4sd5QpeOpwyBLG0Y77gG5AEhoFnRAJLZLRIhYtlnnH4aW1FVW4FVm0oziMoFpEQIwHoWUMCWhV1nwZZiTVcy1h9Uu7ClsGCShz06UpY231Ee3OizjaNqyZt25qNM4JRwyIMo52hCaZtyqqFj9pfpsC0By54G4uwPKPLSzBipUMuoJ9DpH75edgjlvutqYxHYcxoR7tV2EHgm9BNNVhugFDJayDwwJdyHd1ASs6yExIMusi3OwX0CKQKg13QHii9yONi6kZnBa7DeklvYFsietQefUwn8DqnYmRlUxB5NVzD4AZaQ3quhhixHdLGNGN536W6nX893In1U1nsjS1A6OFWnyK6ishY44cJMIUxWead3NUSI2jNICgOXUb9R6pdIxPi5LsZ6b3c7XmUlKbCLR7qS8U33L1mZeDjsx7XmbGZ2zxtT8FnblZ22JuCU0vQ7GjDvBIYbnDJ2e2k0dTYjk8MzL0CqbQuQRzAOVzsMvRcsPMzCj0MkXomMLZbUJHEVEBx3kygZ1nvsIMpYl2TE5dK4WHP4KuSGFDGKTxGWAbeVkDnW5KylqlT3nrbSUsZA9QTtrPjbNOmyqFAxZLKvsoUoAMHByQDeMdUGWOnpPUa9OGyYqCdYOXhE8wZTAHxZ8864TR2NKyp1MtWcOdP9XAVL3wTfwzjs9fqZLK1oBs68gwAbFoaNbncOoXPGa4iOIMpIMrUY3ryfML8A4kDJsYnAwJcc8mL2RqpCzzPg0Wj43wx4XUHKTCcPhv4efkeh9sZinIPH0F4kGcejZRkSYnrObkVdoAbYfLQabhPjvUYO3PVtsIiFIcpu1x4pTBHmk7zLJHu3S6SrKm2YBYTZaKi2YEFi2RyBvAaf6BRtdbMpjrshU5t1GOu3N7TvVVkM8jjrJiCLngf1HMYeQe' ); SELECT LENGTH(a_str_13), LENGTH(a_str_18) FROM test_tab; SELECT 'Next update should succeed (length < 3962)'; UPDATE test_tab SET `a_str_13`=CONCAT(`a_str_13`, 1), `a_str_18`=CONCAT(`a_str_18`, 1); SELECT LENGTH(a_str_13), LENGTH(a_str_18) FROM test_tab; SELECT 'Next update should fail (length >= 3962 && length <= 4030)'; UPDATE test_tab SET `a_str_13`=CONCAT(`a_str_13`, 1), `a_str_18`=CONCAT(`a_str_18`, 1); SELECT 'Truncating table'; TRUNCATE test_tab; SELECT 'Inserting new row'; INSERT INTO test_tab (b_str_26, `a_str_13`, `a_str_18`) VALUES ('a', 'TiuiRBxekVt75xWj3kOFsu6rYNCmcWXn16ELrUCWrFlWOV9FydLoIIi4NEbriDMzV8FvCWsbK5WjQddNVzTzbo6WjgWa9H8fWXwwX7nHV3joupDpmXapOW9pPQYbCFaTIhgoHBDYmAnNekRORlHLq0VAjrysbTmx9063xb1TpfqbPJS7dz6wj00Aa2iqhCDZlbAxVsuvPhD6cv2GDI5l6xzQRoE0GHumYHKiLneqpTWj1FxQbhXwlPXnxmaK5REUBVFUeV9HinfSnl119r9Ulexdx1eSRY1rn9T7l02s2e9I6W4DsyKA8SFjshFZRevkao30WLTVv4ctG2aSXr1BFZT7McmOpnI83jfdvtoov3Wh1WVjyee6ZtFCyKd6frJe9a2H25EAniFs4tKoJxKmVF59uJrcGWkNXqX5YsQblNoMDsFhNtFcusbqvJDYKiVzMmlDs5ZrmT2W2a7JUdKCp9H69irPpyOrYmuzEsdxt6Pktl9eikv7yo11fAKCCSjd4mKYgcIDZFIZinqtcXQozVEf2283XLA69qLo7FKIp9bHdiAbL2wnKyzsyqEIIlKHzs06hZxMi8kLuKh79paGtxt55RbuzT2RyWXI2WgMb8pC4TQJYxKcAqahNAdwgfQufBEzRtJ6ueGZiznUdgEXnA07eqI8181Q7a0gQVgEAUrDPOwGtuHLIB6P5G5WzDPR6qBH6USlFRby7dRTmqmzTsiSTa9XCc9wdN28aDQiyku7WOw07bLBAloOFVVHaCMMqhESzWkb2h3NbmGIe8mn1b1c2n8a9Mw5oi7O75m046YtvbCjzJdMgikwyNzQzEeYer8rWJDa0yhkinCrFn3ytweaMgE6fMEs9bzpUBOg3SC7OiTSk8vRIOZm5Qqy54OmVviJODQfqlF5bzKFMOVossRwCWgPvHmvAkrJvnFiJZ1xJ5tIU19hQi8Mu4ouvOlymUuoOnOFsiEyvkt8uZFXao7vXGVNxYSsbFButqeEyLC24a1EaFPHRhhuIywdedQtnvRvh2rHJbuMTQmkP1zsXMgL7MjoOuaIvBSYRrmjxKLq5rAMOqfSrQD2QkJUzZPpk5fYYWDZlgKpIR0FlBCBJRTy0EbF4EhW38Gku4Jb7rZKILG0ICD4ParIoPUSbSifJtlOKK12VRM9Mz8imZ9SilDRupUJjFc0y27inhV3KqJlqL4v64bsj7sB5dBrQMGUyGG3Q4YNP9xTfJJvEZXRrSOHJw9yU0Q6Rp9ibhm09YEBOnL3VJjS3AO3rWXZdXBREatgeDV28IF4gGSgUH6d1BUWE8TlDz9MRBk103O6pnoCEZ75oTZAZ4XzHLMQTMeowkDgAJBsEi1pUCoQRgnRdfPtXobMN2EGnQfLZrWEs6SZdkKd999q3oeAD5gi6QGqHiEznlmdJDJTPPko2tsGJZgrGTRC6gHf1yIyzTi1SVFYqcNbaTti8z8TY6XaAT1sQ0OzbUuDsSgBTqFRmUu96ufRenF2ubRqCummj9GAdyE65GD9yO7uRY2sMlVn4iUi95fFoDzLWTeMeYiXhTvqjB0W8rhLxgCRPJwW8AJASM6pO2x0s4teMBaHcyfAPne42WnxxkAF3jDbqau2PT7B6GmsN7MoiaqvXy3TkBmDgAnvLc7GZJF1BNS4BlPSxwNfc8X1kbKhnZ6049BmSgmSsgP8Y7QFKFnflRv5boT5jCEnOubfl1TwTRWm97Kw9R5XKuuepeBUv362eSOqjULYehhA76w6DZOzAavSkra6ORukA6CFFvppGFqFKOkkLGqCoSPFkwreu5JusjwNkNLUy2cK8iHoGlX1c1qUEpIQdBPkSDd14mEeuf0MCY2INcDjGsW8H6UdEP2tHliLfHeKIzbsISIMp0B934h5xRib2WnYIQ99sVaYAu1HHynuHJ88mk4LG8DhDdRuNMmYxvBMLQdUkbVlqgrMBo1yGLz35AfmhbfnW6FEWk2SiyM443CUaKwMjUY28y7bVHDFuiYmWC5QzBXBnw6BpRg4iRbiWGOOKQeU1eg9keViZTw6i7yNXTecuwxHUM1cxrWNO361m8Jpo5CGEUDPhVTxjKz0OT9wohhqQCTdVQ5tp5TsijhWa1dJebuHAoBv32MY8q10QtmhQSwpujw8I7gAfdwJYCbGMJVKmBT5NKlRknVF99BIquBLqp3SoiI3MYCVZC3ZQdIso1lp6IoM3uzfOXNqy4atL0NPUvCQlDwfGBdJBv0a1I6d4dFK1a3KY7oZDmtyxIjGSCqP0SqxFt51gUFtT5C0vweXS5xFfg0L8Z3uTGX3JVp7sj6jMJQiWzveKXBkSXfJzwpeQOKdv9TCB0k3pGGH5SU36ksdsj2KkbKoajXFaoxUjFT0Ou5fYJDq5Zh4tNzFNuDod1vz25FwwSDRPeuVvMufPlyqq4nQQotaq9xqTRax28F2rWB6Oanl0EDq0f4lPmEs7MSG1EdYesuSaZmpluPsYKHmdUucM7ORp8fpmSGiqLmsb8CJGH6Hv7W5xMLGe6Hcxt2e1Y5wQSQ5FDW7ie26eDm0JrUzommA5HclhqamLfRGMAY84s6NUGn778DkbEwVhurlmd9lmCtEZRppHE51QERimUaYBgRNPknhumSqaD0cCI51rE0IiJMJk6hRa7Le9cQ23p4kA3duVmfwkfHc9ocCgSgIsI3lokRhZfQgyMdwwFUapnljSUytf38sFyArIimcWy9nVxszfWHQCEmf3d6objpJk26vz7Gymzd3dDSOBvaFglUsSaO7mVvJLoQfpeGR9kdsiwlVz8omEbSsPhdibhhWXyKIBezB77VnXMUmlV7hEVqE8VV75EuhXBKq5Z3XQmEYhS4vdUvh9Bx8yVkjzbcu2grdYTogCVosQMvlXCgWcYiwdDf0FDrPPQi8iAKKXrM59SjhNPZzuzcBhCFpP32LrgR1ijmPg8s4Q6jwEdxSkZE7AnXgWiQ3NmjOmfHPLZdhrCdIzzj0GbhV6RjiCzZBNVN2uiZ4kKJNXm0LZBRSEJ4bRCwoTxPIztPPSZ6ahg9oF8cLG53FoOh5VweYYl3LWFHKg6DLk1aDZX0xnnFW1M391ny8JBnJOTwmKbxl5GVvq7x0YpdepbXoEe8rDJLH7JQoQSAK2qljHLJ9nKQolVziucL2tf7A8CHnt8Tkb0fNSIBxb6J2LE8SKSHxsueet0NenKTzwb36lV4uZQ1vPS4I5fhO3EzLCGUH6bZTl1fvxn9pRK2OsTSSiRxcCTPltUx2LRsX6ysUUvFKRsp5qJtl4sOoJxaKB54M5bZPldwkdrJdwQ3MXoEbjjNTtzgljpG4gGWeRJoCd8zGvnX9jYLGkhW9MMy1SOZHCRB69nt56Sr7zihIKJigemZ4N2qiNmEV84ALCrQAlh2kI3LouTtwyRzsMxio3mXJ2JUVWmBp5pRgwBl1ue0Y71AqhYua2EA3Q1P6OqCtwDY7IWYdnVIZJKYZAGpX6NxmWkCduMhi1Wtxan3AU09jBiXOf2Z4Ravzi6r7KYFFaQrIV8hZzsOSWkyDke7o48kJA3UBcM3WUWFY56Mg3Ze6fuRvoJp4gsZRrnbuqMjRnp0GlAtbIykIdxesrqFfrZYMsxiwCqbc61ECMH1Sej8NVgl8TkCk2dHSw7xpdTAWGt5xtLwSzB2UvOJ2bI0bWSloi1nwkXSOhJrbB0cNPQtGHate0oP0zntyCNHQviDNWatGXLLuS8hDJj1j0OsmH5NoUHghY9zBvWivrZQDm4mHcIJFidqixLLS5iWHOJ7Xnqknml19k8u2sFcKxmkzjVmMBiYhXqhJ5vF16wHfIXRkmDFR8pjwmGyY79NwS7h1LAscATwWT7G7t4ci6A35qZndHMs9KQSfNgF1kwQDsYziogYyLCxb8vpBhlkFgxo6fZD5aZwRWMLTMOLxFgSKI0yXQrWRuDttX5v71knxYVjoLgD0g63UtiylGUyX81tBf5kqgGYs8AodOJvYezeMr0cpMUQeGn8hpJE9Is98fYNnsNcSYBODpPPWiWJ', 'x3tXfOn6LkKVPIwuZ2Q9tsmcuHH0y12spFdozOVdDTWXXuCp9oqlIRi7NsiK4i4ei87Ku0ak3sQhQocJ0EPcYEdiALlbBKks5cBzEkrurPqzMTaKccj3lKdiISbOsNaQakCTZ1jiKZPkxkX20TwkPOVECzaip7wsO1kkJifdZfBoK0ElJlZckEirQcbYin60pPVshJW62v3YhxGNmjqbr7jXsrXAswhvGhjqm2t3D1sITBjrjAxOCfIBKXwKMWQk7mYXlU7HCxV1tgWC33WcHHX3XkEDFRG8f82WJnvlGGf2eJSIL5T7CezjOzbCFvEKBbLnkI3gFN47CEImaC0QU2s94C6rrD0t3VHCEIhrU5ZFgG0hTIzzBBIzWH8IWgGOdB0TEY7ib5GQoBpcGBrfdiyZKbenz9gCgGjLtpITicn9xWMareUkmAsXpDU2AxSlGG4xd9sFmQZQjhCuxKTHQcftg1XGKGThG2MvTWmZm2e5oROM5JC5iftiZn8Bg72PM5wKbEYp0W1oQIMQWHyIBjmUn1YtsIsdgm16ze56N4sEU7mdoap4yaPgqeInG228pQdkuoN9ziFqKfMzLXpWmkUrPYuGGVSsyCnAAKUOkVogO76dX7Yq3uo3RhcgNT5qruDsdflYlkt7hb4RKjws1Cm5vbXgcmRsquJgChgHk3Rv6hI4Og0oajhClrvHNmIAh5a9DWDAd9YU0Uon9PO3ctVbG0bVr3ojHVs07i2tRwH8owwlFHl5sxwWIC8eyR3VCv6I8mOKvu2uydco89Pycv41wecnAnCrEbLJSvoj3ZZwyWzKAuorN9gsAWmEauIczDU6v0Smi5P83uWKEzHkbIcb38XmwtYqOXGvRyrgLeh0ebhmfYSz6yHKJMJNW2X9RCa66cWdCkAdP7E8EEw7mbCFvXJFn5BzBWNCa5xCSLhT4WQAwHeBl1jZ0HWzN9L1q2q3Qg3L8Vs8FiwHxPAXRahDPDnoBfWdZ6tROByKHOUYcdIhmX2281D43t5D2lM2h0OFWh73v9f2PBPkt7yLkeQ9tuv5aZYAUKwOSpDHepEDIIQ7AcUEuicfvFq9j3I1hbIFm2QOu0MwxCuPhYqroJeLO2Z86l7Ei7geROStZm2RbeWVMPTdttCnz9jRCYgf1mxoBJQLC12uLFfyqem1sHi6VAHOpVCeF3XbAX4FpZGGZVNRSSxeGau2TLfYeFUZf03MuWtIhnIAsRrJ0vBJ8SJtR2UH2dWqjBW5O2YWACT5k4J6Enn4oC0elwTmQyMWGHmhL4ipGjG3T2jGeSvygRdWPni1qiFdOWrLYbfDS75AMy0hqfpj4amqubw4eTJYmRINmgmfj5mvvAe5OKkVqqg2WSYQ6g4uXIpneiSgUBxWUwaqLYLY1gqejsuUSt40gRNVDHbyaxS2xqDmY5R55qlxtM6EQ4tdvcOUSY2Ypw9N7fyANOVTGVrBncOYuarhkjN1AifwQ4zMthgAWaG6ttNpgV2ya4R2RzikfOfG4D0f2adUC7vtLKxGXUc6HwuqTEfOxXvKoQ1tJ6T0WJ4axDZOQAEWd9jJhTF8cFh9ziH2oz2949BojBbRdRglILbzBUnmcJR3rYe1iL12zQG75PiQomZ0pMnc2bWJt2j5ZDX0hsThowAbyNpDZ6AMDpJB26vViXvNk24sCV4O9Ik2ZU91Ika3xcbheVxPbUOhMf0NhNca51eFwcRcgJUJIur61qE1XB6R41xuLjZ4ULPgOjgmO5P2q1jxx0HESi6nIJRCxPTtrDcjfblgBQtvuKVElpuLM6ok4dknHBU4KgUuQJfEFV1kF9Aic6D2j3ltGktwMtTzp8YJETORas4Vw8dU2ZFYlMWY7dB00V8hfaxufpZyC7Bg2zINSLItN48vUjfrlFE8ZhSbTbneX2f3kUF7CgcXLXKg1tzYoUMyB36UPWoJ4zGgJAbADF9Eg4OQ0cRerTxdFpQFbiGuHj2YpXJSRVLoiGb6Q3giTY2OfckAgQU1z2mIMqfUy3N7qY4v6f7jjTHSJz49bJEPei54nKsgMz1qUoxk97YuqzDGTXlnIJXIxEpUbM1LyxN8nusbjLsGT7oWdiqusdoVieAJUYZUuYapUKbBMdBA08JuIg88G1A47vxXjcErUXE8SLU2ORGkA67WxjECrB3GmrQ8Spl1mTIllnRYF3ZqncKDhsLqVKVBvFy2maJMzUobnqvgDCRuxYeNbFcha38xMbCL1hjW9zhOVyU054MNMJwLhGrddgZn8cUFmk4tlSypchxCDsFRCV1NJu0hyNByPPfEQK6l8rOvbx728RgZtOUma5v9XkzWgZA1ris43iVTYrQdL4hXnwd89HUEYyicnRyiGy0ICPAlObZetzAMMM426s3YopYe4QQV3kTh6TcIFXmjUSDEaUySSaFUNLKBkI8iMD2jvJmuqNBelcctOHR0g65R4G3OsUfaLkc463WVV1amJXOhQJl9tV2bOU1x6YBEOkOTvU6zY9iDog9ftLeTvXfTgUrTWr448gfvCkXsROiI9MSWryOUvB8jb8VffCiTEFHGJwNBC40xhjAM1MIe66uYU7JabAr8eC81Vmi2L5MUHvfdtvgdp3t5RQmw5rB1H8x0U8lsXNBxe2uLM9XzbZqWoLP7z2B8BWD5DcGvn9ffeoLSmrfSwmwnT7BZVM72QnPbOGRWB6xppjutmje91zsckkF9Gnegkfk3PH9DV9zAstYJriRDDMiE6QDI7Vuec26QCwaRM7fJ5BDq93xw0CGWvccZRRlRNUB8kmjuFqAMu9urOY3j6CF1dstL9Y1Zrz5EyY7NpPOT6mnUpODgUx2ZQYepXMXAmxmDuBfDRiPzTkRRGOhi2DFSlIJLbosCFvscvWaPz1kvdrRSayTq7AV5CTdHlKE7AAq3e2VGYfFqYCptW6rJiUVRLah3zS6OVnPrOHO8RF8KtxyDU8bRrCq1ZLfP0nIUnT3iZENuSnVtPOW31stiQcHMCvoTzHlschG4pjxDrufo98rbFN9TOY8NPdv0YLltcZkOBqyw2dm0yay1SO3zCSzLTCoU7TzCpff5LtHPCSJeijJuy9Wdv5WpQ2EqVGVEVAn56AJFoS9matU1uvebkyNXDSpe8hRVpWdCjlREva2vv9hVVQdnsM2LVCIO7iunfopqbSpfHnMxvAWWn0y1fpWTHJrnG0rtL4DUtCWOKePM7vJBpmj5Yymmqy9k8qpKM6ZlSJthPk6nmm8DfuOKEZNWu5B0CRFiv2Nj6OOJMK49DcrhBQabA973fpp4fUd6AXfRua4tRB1eBU4ZHXdFlVxxfMzYzaxwaAPy3zynTh1aANIa6XhAJncLZNOogipCSuLpQovynsp84DXGYX4Jk1pLOppbwG9CjyKE3HK8PT81dnXV0bmIqFT9iJhj3Uu1JXzrbM73Ef4EMd0YGn3LXJIVSvObax1rNL5I7ZitjWH9Zh5J5RbDojtgUZ0uwhWSOZ1S3vUekwoGnAtBrPou5aZWpt9bV5DmZE6eczCdbo7DIBaRMQVlM7QCnyQpFMTW3AIGD5EwMCAuley4hNSce8NNLGa60z015I3Lt5nB4tGw8TLctwlg7cW23v2HDyj4SFBW5VM8VJha8cqM8aRYYfzyhZUDa9Sl9bS9SB3Oye0X4cQL9A9uAl4ZYN0bkoXKheAlUX6XM8gvTWHkBGllRAw6eBo7TsN3WHTyjOTrWlqrNu8tRjtSKJvnHBFkaXVj6nqBHLSFkaIKhwkkA5YcnzDj0WH4hMjTjF6KwqpJZPGf6UFPH9cevlQCDSaR0p8A3lIomIbAImQX73ejNxmItnB1cDRPJ3932oXRYt3wTKsWIbDnyiUhXJcfdy2CwjRpNQhZp7w4cHqowIDZQ13gswbRvZl87XNh49IcHKCyykUe5IwYDWTKqZpDZs5GldUaHCYoP5YU3lQoo9dTn7rY4WAkWfjmFqJCtXkgqSV2mAutnPeNBmcD4cFGevKHOHKccFwjjMvOhmJZmclHN50TDd4b7cBLvxR7QjG' ); SELECT LENGTH(a_str_13), LENGTH(a_str_18) FROM test_tab; SELECT 'Next update should succeed (length > 4030)'; UPDATE test_tab SET `a_str_13`=CONCAT(`a_str_13`, 1), `a_str_18`=CONCAT(`a_str_18`, 1); SELECT 'Reducing length to 4030'; UPDATE test_tab SET `a_str_13`=SUBSTRING(`a_str_13`, 1, 4030), `a_str_18`=SUBSTRING(`a_str_18`, 1, 4030); SELECT LENGTH(a_str_13), LENGTH(a_str_18) FROM test_tab; SELECT 'Next update should fail (length >= 3962 && length <= 4030)'; UPDATE test_tab SET `a_str_13`=CONCAT(`a_str_13`, 1), `a_str_18`=CONCAT(`a_str_18`, 1);