Bug #45159 some tests in suite "jp" fail in embedded server (use LOAD DATA)
Submitted: 28 May 2009 14:05 Modified: 20 Dec 2009 0:46
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:azalea (5.4) 5.0, 5.1 OS:Linux
Assigned to: Georgi Kodinov CPU Architecture:Any

[28 May 2009 14:05] Horst Hunger
Description:
Some tests in the jp suite fail with the following message:

mysqltest: At line 38: query 'LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `�s�P`' failed: 1148: The used command is not allowed with this MySQL version

How to repeat:
./mtr --suite=jp --force --embedded-server

Suggested fix:
reject running with embedded server or replace LOAD DATA INFILE.
[28 May 2009 17:09] Sveta Smirnova
Thank you for the report.

Verified as described.
[28 May 2009 17:26] Sveta Smirnova
Failed test are:

jp_charset_sjis, jp_charset_ujis, jp_charset_utf8, jp_convert_sjis, jp_convert_ujis, jp_convert_utf8, jp_like_sjis, jp_like_ujis, jp_like_utf8, jp_select_sjis
[28 May 2009 17:49] Sveta Smirnova
Also failed: jp.jp_select_ujis jp.jp_select_utf8 jp.jp_where_sjis jp.jp_where_ujis jp.jp_where_utf8
[8 Sep 2009 14:11] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/82705
[8 Sep 2009 14:35] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/82707
[8 Sep 2009 16:07] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/82719

2811 Georgi Kodinov	2009-09-08
      Bug #45159 : some tests in suite "jp" fail in embedded server (use LOAD DATA)
      
      Enabled LOAD DATA LOCAL for embedded client
[8 Sep 2009 16:15] Georgi Kodinov
jp.tar.gz : updated test suite

Attachment: jp.tar.gz (application/x-gzip, text), 201.72 KiB.

[9 Sep 2009 13:03] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/82811
[9 Sep 2009 15:04] Georgi Kodinov
Pushed the Part1 fix to 5.0-bugteam and null-merged to 5.1-bugteam and mysql-pe.
Moving back to PP for the embedded server problem (LOAD DATA LOCAL disabled in embedded server).
[11 Sep 2009 10:23] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/83033

2811 Georgi Kodinov	2009-09-11
      Bug #45159 : some tests in suite "jp" fail in embedded server (use LOAD DATA)
            
      Initialize correctly client flags for the embedded client
[11 Sep 2009 12:52] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/83052
[14 Sep 2009 16:06] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090914155317-m1g9wodmndzdj4l1) (version source revid:alik@sun.com-20090914155317-m1g9wodmndzdj4l1) (merge vers: 5.4.4-alpha) (pib:11)
[25 Sep 2009 11:21] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/84624
[6 Oct 2009 8:57] Bugs System
Pushed into 5.0.87 (revid:joro@sun.com-20091006073202-rj21ggvo2gw032ks) (version source revid:kristofer.pettersson@sun.com-20090929151855-gvpblm4dnnubypdv) (merge vers: 5.0.87) (pib:11)
[6 Oct 2009 9:01] Bugs System
Pushed into 5.1.40 (revid:joro@sun.com-20091006073316-lea2cpijh9r6on7c) (version source revid:joro@sun.com-20090925113905-f0leztacxiisxaz6) (merge vers: 5.1.40) (pib:11)
[7 Oct 2009 23:50] Paul DuBois
Noted in 5.0.87, 5.1.40 changelogs.

Client flags were incorrectly initialized for the embedded server, 
causing several tests in the jp test suite to fail.

Setting report to NDI pending push into 5.4.x.
[22 Oct 2009 6:37] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091022063126-l0qzirh9xyhp0bpc) (version source revid:alik@sun.com-20091019135554-s1pvptt6i750lfhv) (merge vers: 6.0.14-alpha) (pib:13)
[22 Oct 2009 7:09] Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091022060553-znkmxm0g0gm6ckvw) (version source revid:alik@sun.com-20091013094238-g67x6tgdm9a7uik0) (merge vers: 5.5.0-beta) (pib:13)
[22 Oct 2009 19:25] Paul DuBois
Noted in 5.5.0, 6.0.14 changelogs.
[18 Dec 2009 10:36] Bugs System
Pushed into 5.1.41-ndb-7.1.0 (revid:jonas@mysql.com-20091218102229-64tk47xonu3dv6r6) (version source revid:jonas@mysql.com-20091218095730-26gwjidfsdw45dto) (merge vers: 5.1.41-ndb-7.1.0) (pib:15)
[18 Dec 2009 10:52] Bugs System
Pushed into 5.1.41-ndb-6.2.19 (revid:jonas@mysql.com-20091218100224-vtzr0fahhsuhjsmt) (version source revid:jonas@mysql.com-20091217101452-qwzyaig50w74xmye) (merge vers: 5.1.41-ndb-6.2.19) (pib:15)
[18 Dec 2009 11:07] Bugs System
Pushed into 5.1.41-ndb-6.3.31 (revid:jonas@mysql.com-20091218100616-75d9tek96o6ob6k0) (version source revid:jonas@mysql.com-20091217154335-290no45qdins5bwo) (merge vers: 5.1.41-ndb-6.3.31) (pib:15)
[18 Dec 2009 11:21] Bugs System
Pushed into 5.1.41-ndb-7.0.11 (revid:jonas@mysql.com-20091218101303-ga32mrnr15jsa606) (version source revid:jonas@mysql.com-20091218064304-ezreonykd9f4kelk) (merge vers: 5.1.41-ndb-7.0.11) (pib:15)