Client get lost connection when try to load data local for a empty file #683
Closed
Description
-
dble version: 2.18.09-release
-
preconditions :
-
configs:
schema.xml
default
rule.xml
default
server.xml
default
- steps:
execute sql
use testdb
load data local infile "C:/workspace/test.txt" into table table_a fields terminated by',' lines terminated by '/n'; - expect result:
Query OK, 0 rows affected (2.95 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 - real result:
ERROR 2013 (HY000): Lost connection to MySQL server during query
/label ~BUG
Activity
load data with empty file get error return (#684) #683
irene-coming commentedon Sep 4, 2018
bug found on version:5.6.29-dble-9.9.9.9-18e8b31-20180903030245
irene-coming commentedon Sep 4, 2018
dble commit version:5.6.29-dble-2.18.09.1-2b298cd-20180904021034
case1. with no lines in test.txt:
dble:
case2. with 1 empty line in test.txt (echo> test.txt)
dble:
mysql:
case3. with 2 lines data in test.txt
dble:
mysql:
resolved:verified dble version: 5.6.29-dble-2.18.09.1-1748fd0-20180904095646
irene-coming commentedon Sep 4, 2018
dble commit version:5.6.29-dble-2.18.09.1-2b298cd-20180904021034
with multi-times operation as above, other queries( not "load data ...") are affected:
load data no local empty file #683
load data no local empty file #683
irene-coming commentedon Sep 5, 2018
dble commit version: 5.6.29-dble-2.18.09.1-1748fd0-20180904095646
preconditions: test.txt has no lines, table_a does not exist
case:
expect: ERROR 1146 (42S02): Table 'table_a' doesn't exist
real: query success
resolved:
verified on dble version:dble version: 5.6.29-dble-2.18.09.1-0752712-20180905032631
Table not exist #683
15 remaining items