CREATE TABLE D ( pk INTEGER AUTO_INCREMENT, col_int_key INTEGER, col_date_key DATE, col_varchar_key VARCHAR(1), PRIMARY KEY (pk), KEY (col_varchar_key, col_int_key) ) /* QNO 13 CON_ID 10 */; CREATE VIEW view_D AS SELECT * FROM D /* QNO 14 CON_ID 10 */; CREATE TABLE E ( pk INTEGER AUTO_INCREMENT, col_int_key INTEGER, col_date_nokey DATE /*! NULL */, col_time_key TIME, col_varchar_key VARCHAR(1), PRIMARY KEY (pk), KEY (col_varchar_key, col_int_key) ) /* QNO 17 CON_ID 10 */; CREATE TABLE BB ( pk INTEGER AUTO_INCREMENT, col_int_key INTEGER, col_datetime_key DATETIME, col_varchar_key VARCHAR(1), PRIMARY KEY (pk), KEY (col_varchar_key, col_int_key) ) AUTO_INCREMENT=10 /* QNO 25 CON_ID 10 */; --connect (con18_0,localhost,root,,test) ALTER TABLE `BB` ADD SYSTEM VERSIONING /* QNO 4562 CON_ID 19 */; CREATE PROCEDURE stored_proc_11998 () LANGUAGE SQL SET @stmt = " SELECT OLD_PASSWORD( `col_int_key` ) AS field1 FROM `BB` WHERE COT( 'ttslqcplqcysmyoxppxzczvxmxqmygufulxpbixqoqcthooeiyxsczhbdxha' ) GROUP BY ABS( ( ~ '1972-05-09 02:26:14.053914' ) ) " /* QNO 3586 CON_ID 18 */ /* QNO 3595 CON_ID 18 */; CALL stored_proc_11998 /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 3597 CON_ID 18 */; SET @stmt_create = CONCAT("CREATE TEMPORARY TABLE `ps` AS ", @stmt ) /* QNO 3599 CON_ID 18 */; PREPARE stmt FROM @stmt_create /* QNO 3601 CON_ID 18 */; --error ER_DATA_OUT_OF_RANGE,ER_TRUNCATED_WRONG_VALUE EXECUTE stmt /* QNO 3608 CON_ID 18 */; SELECT * FROM `E` GROUP BY 1 MOD ( 'lqcplqcysmyoxppxzczvxmxqmygufulxpbixqoqcthooeiyxsczhbdxhadxpqhgspxonbmusurlhpijnwgwiihfirmxahrnkhjrkicgnbedxkshebdbvdsxcmcqtoxtbhlxvcvswrjqylfsddozmcroqbrynjcakeyucvlrbhruwhqduvafwzlunys' ); SHOW WARNINGS;