DELETE and UPDATE on a CONNECT CSV table of 4300000100 bytes give an ftell error and cut the file to 5032704 bytes

--let $c= query_get_value(SELECT COUNT(*) AS c FROM information_schema.ENGINES WHERE ENGINE='CONNECT' AND SUPPORT='YES', c, 1)

if (!$c)

{

  --skip Needs the CONNECT engine

}

# t1.csv holds one line with a=2, then 43000000 lines with a=1, 100 bytes each

--perl

open(my $f, ">", "$ENV{MYSQLTEST_VARDIR}/tmp/t1.csv") or die;

print $f "2," . ("b" x 97) . "\n";

my $s= ("1," . ("a" x 97) . "\n") x 10000;

print $f $s for 1..4300;

close($f);

EOF

--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR

--eval CREATE TABLE t1 (a INT NOT NULL, b CHAR(97) NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='$MYSQLTEST_VARDIR/tmp/t1.csv' SEP_CHAR=',' HUGE=1

--error 0,ER_GET_ERRMSG

DELETE FROM t1 WHERE a = 2;

DROP TABLE t1;

# The size of t1.csv after the DELETE

--perl

my $n= -s "$ENV{MYSQLTEST_VARDIR}/tmp/t1.csv";

open(my $f, ">", "$ENV{MYSQLTEST_VARDIR}/tmp/t1.inc") or die;

print $f "--let \$n= $n\n";

close($f);

EOF

--source $MYSQLTEST_VARDIR/tmp/t1.inc

--remove_file $MYSQLTEST_VARDIR/tmp/t1.inc

--remove_file $MYSQLTEST_VARDIR/tmp/t1.csv

--let $cut= query_get_value(SELECT $n <> 4300000000 AS cut, cut, 1)

if ($cut)

{

  --die The DELETE of one 100 byte row from a CONNECT CSV table over a 4300000100 byte file left a file of $n bytes, not 4300000000

}

!include include/default_my.cnf

[mysqld.1]

plugin-load-add=ha_connect

mysqltest: At line 32: The DELETE of one 100 byte row from a CONNECT CSV table over a 4300000100 byte file left a file of 5032704 bytes, not 4300000000

mysqltest: At line 32: The DELETE of one 100 byte row from a CONNECT CSV table over a 4300000100 byte file left a file of 5032704 bytes, not 4300000000

mysqltest: At line 32: The DELETE of one 100 byte row from a CONNECT CSV table over a 4300000100 byte file left a file of 5032704 bytes, not 4300000000

CREATE TABLE t1 (a INT NOT NULL, b CHAR(97) NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='.../c99.csv' SEP_CHAR=',' HUGE=1

Query OK, 0 rows affected (0.013 sec)

DELETE FROM t1 WHERE a = 2

ERROR 1296 (HY000) at line 4: Got error 122 'ftell error for recd=0: Invalid argument' from CONNECT

CREATE TABLE t1 (a INT NOT NULL, b CHAR(97) NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='.../c37.csv' SEP_CHAR=',' HUGE=1

Query OK, 0 rows affected (0.010 sec)

SELECT COUNT(*) FROM t1

ERROR 1296 (HY000) at line 4: Got error 174 'Error in _filelength for .../c37.csv' from CONNECT

SELECT a, LEFT(b, 3) FROM t1 WHERE a = 2

ERROR 1296 (HY000) at line 6: Got error 174 'Error in _filelength for .../c37.csv' from CONNECT

DELETE FROM t1 WHERE a = 2

Query OK, 0 rows affected (0.000 sec)

SHOW WARNINGS

Empty set (0.000 sec)

CREATE TABLE t1 (a INT NOT NULL, b CHAR(97) NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='.../c37.csv' SEP_CHAR=','

Query OK, 0 rows affected (0.009 sec)

UPDATE t1 SET b='x' WHERE a = 2

Query OK, 1 row affected (15.154 sec)

Rows matched: 1  Changed: 1  Warnings: 0

SHOW WARNINGS

Empty set (0.000 sec)

rnd_next CONNECT: ftell error for recd=0: No such file or directory