[MDEV-16397] ER_KEY_NOT_FOUND upon attempt to LOAD DATA into sequence Created: 2018-06-04  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Sequences
Affects Version/s: 10.3
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-19320 Sequence gets corrupted and produces ... Closed

 Description    

--let $datadir=`select @@datadir`
 
--write_file $datadir/test/f.data
 
0 0 7
 
0 0 4
 
EOF
 
 
 
SET sql_mode= '';
 
CREATE SEQUENCE seq ENGINE=Aria ROW_FORMAT PAGE;
 
LOAD DATA INFILE 'f.data' REPLACE INTO TABLE seq FIELDS TERMINATED BY ' ';
 
 
 
# Cleanup
 
DROP SEQUENCE seq;

10.3 b50685af825

 
mysqltest: At line 9: query 'LOAD DATA INFILE 'f.data' REPLACE INTO TABLE seq FIELDS TERMINATED BY ' '' failed: 1032: Can't find record in 'seq'


Generated at Thu Feb 08 08:28:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.