Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

dble query [load data...replace...] fail for lost \n (0a) during dble parse #774

Closed
irene-coming opened this issue Oct 19, 2018 · 2 comments
Closed

dble query [load data...replace...] fail for lost \n (0a) during dble parse #774

irene-coming opened this issue Oct 19, 2018 · 2 comments
Assignees
@irene-coming
Labels
load-data resolve problem has been fixed by developer
Milestone
2.18.10.0

Comments

@irene-coming
Copy link
Member

  • dble version：
    5.6.29-dble-2.18.10.0-c683b99-20181015051308

  • preconditions ：
    test3 is a base table

  • steps：
    step1. create file 'file1.txt' and fill contents in both dble and mysql respectively:

1,1,,

step2. execute sqls in both dble and mysql respectively

create table test3(id int, c1 char(5), c2 char(5), c3 char(5));
load data local infile "./file1.txt" replace into table test3 fields terminated by ',' lines terminated by '\n';
step3.dble and mysql results :

dble resultsets:

mysql> load data local infile "./file1.txt" replace into table test3 fields terminated by ',' lines terminated by '\n';
ERROR 2013 (HY000): Lost connection to MySQL server during query

mysql resultsets:

mysql>load data local infile "./file1.txt" replace into table test3 fields terminated by ',' lines terminated by '\n';
Query OK, 1 row affected (0.01 sec)
Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
  • expect result：
    1. step3 dble get same result with mysql
  • real result：
    1. step3 dble get different result with mysql
  • supplements：
    1. capture package with tcpdump for dble and mysql respectively during step3:
      loaddata_dble.txt
      loaddata_mysql.txt
      for the package after query [load data...], dble lack 0a( that is \n ASCII) compare with mysql
      /label ~BUG
yanhuqing666 added a commit that referenced this issue Oct 20, 2018
@yanhuqing666
load data #774
6cbccd3
@yanhuqing666 yanhuqing666 added this to the 2.18.10.0 milestone Oct 20, 2018
@yanhuqing666 yanhuqing666 added the resolve problem has been fixed by developer label Oct 20, 2018
@irene-coming
Copy link
Member Author

verified on dble:5.6.29-dble-2.18.10.0-6cbccd3-20181020142155
append to autotest plan 10.0 on confluence

@irene-coming
Copy link
Member Author

verified on dble:5.6.29-dble-2.18.10.0-6cbccd3-20181020142155
append to autotest plan 10.0 on confluence

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@irene-coming irene-coming

Labels
load-data resolve problem has been fixed by developer
Projects
None yet
Milestone
2.18.10.0
Development

No branches or pull requests
2 participants
@irene-coming @yanhuqing666