Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Build tested:
getcalpontsoftwareinfo Fri May 20 13:28:21 2016
Name : infinidb-platform Relocations: (not relocatable)
Version : 5.0 Vendor: MariaDB, Inc.
Release : 0 Build Date: Sun 15 May 2016 07:24:29 PM CDT
Install Date: Mon 16 May 2016 05:21:51 PM CDT Build Host: srvbuilder
This issue is uncovered by the DMLRate test in Autopilot.
set autocommit=0;
select unix_timestamp();
insert into lineitem values(700000000,10000,1000,1,10,950.50,0.03,0.02,'N','O','1999-01-01','1999-01-01','1999-01-01','DELIVER IN PERSON','TRUCK','test test test test test');
select unix_timestamp();
commit;
The commit command does not commit the transaction. Another query session did not see the inserted row and the table lock remained in place.
If the "select unix_timestamp();" after insert is omitted, then the transaction worked as expected.