bug: ALTER table..MODIFY, Got error from storage engine #752
Description
Have you read the Contributing Guidelines on issues?
- I have read the Contributing Guidelines on issues.
Please confirm if bug report does NOT exists already ?
- I confirm there is no existing issue for this
Describe the problem
there are 1000001 rows in the table delete_test;
mysql> desc delete_test;
+-------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| c_int | int(11) | YES | | NULL | |
| c_smallint | smallint(6) | YES | | NULL | |
| c_mediumint | mediumint(9) | YES | | NULL | |
| c_bigint | bigint(20) | YES | | NULL | |
| c_float | float | YES | | NULL | |
| c_double | double | YES | | NULL | |
| c_decimal | decimal(10,5) | YES | | NULL | |
| c_date | date | YES | | NULL | |
| c_datetime | datetime | YES | | NULL | |
| c_timestamp | timestamp | YES | | NULL | |
| c_time | time | YES | | NULL | |
| c_char | char(10) | YES | | NULL | |
| c_varchar | varchar(100) | YES | | NULL | |
| c_blob | blob | YES | | NULL | |
| c_text | text | YES | | NULL | |
| c_longblob | longblob | YES | | NULL | |
+-------------+---------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
mysql> alter table delete_test modify c_bigint int(11);
ERROR 1030 (HY000): Got error 1 from storage engineExpected behavior
No response
How To Reproduce
CREATE TABLE `delete_test` (
`c_int` int DEFAULT NULL,
`c_smallint` smallint(6) DEFAULT NULL,
`c_mediumint` mediumint(9) DEFAULT NULL,
`c_bigint` bigint(20) DEFAULT NULL,
`c_float` float DEFAULT NULL,
`c_double` double DEFAULT NULL,
`c_decimal` decimal(10,5) DEFAULT NULL,
`c_date` date DEFAULT NULL,
`c_datetime` datetime DEFAULT NULL,
`c_timestamp` timestamp NULL DEFAULT NULL,
`c_time` time DEFAULT NULL,
`c_char` char(10) DEFAULT NULL,
`c_varchar` varchar(100) DEFAULT NULL,
`c_blob` blob,
`c_text` text,
`c_longblob` longblob
) ENGINE=TIANMU;
drop procedure doinsert;
delimiter //
create procedure doinsert()
begin
declare i int;
set i = 0;
while(i<=1000000) do
insert into delete_test(c_int,c_smallint,c_mediumint,c_bigint,c_float,c_double,c_decimal,c_date,c_datetime,c_timestamp,c_time,c_char,c_varchar,c_text)
values(i,105,105,i,5.2,10.88,105.083,'2016-02-25','2016-02-25 10:20:01','2016-02-25 05:20:01','10:20:01','stoneatom',CONCAT('hello',i),'bcdefghijklmn');
set i = i+1;
end while;
end;//
delimiter ;
call doinsert();
alter table delete_test modify c_bigint int(11);Environment
ubuntu@ubuntu:~$ cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04.4 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.4 LTS"
VERSION_ID="20.04"
ubuntu@ubuntu:~$ /stonedb57/install/bin/mysqld --version
/stonedb57/install/bin/mysqld Ver 5.7.36-StoneDB for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
Branch name: stonedb-5.7-dev
Last commit ID: 5d996f9
Last commit time: Date: Sat Oct 8 14:34:42 2022 +0800
Build time: Date: Fri 14 Oct 2022 12:28:00 PM UTC
Are you interested in submitting a PR to solve the problem?
- Yes, I will!