Bug #23471 mysql client test fails on external server, when sql_mode is set
Submitted: 19 Oct 2006 16:45 Modified: 18 Jun 2009 14:30
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:4.1 BK, 5.0 BK, 5.1 BK OS:Any (all)
Assigned to: Bernt Marius Johnsen CPU Architecture:Any

[19 Oct 2006 16:45] Georg Richter
Description:
When running mysql-client-test against an external server, several tests will fail, if sql_mode is set.

E.g. when running server with sql_mode="ANSI_QUOTES" test_stmt_close fails.

How to repeat:
see description

Suggested fix:
Unset sql_mode after mysql_real_connect.
[20 Oct 2006 8:01] Sveta Smirnova
Thank you for the report.

Verified as described on Linux using last BK sources and server running on the same machine:

#####################################
54 of (1/1): test_stmt_close
#####################################

mysql_client_test.c:4691: check failed: 'stmt1 != 0'
 Establishing a test connection ... OKAborted
[2 Apr 2009 15:20] Bernt Marius Johnsen
It fails with the external server on 5.0, 5.1 and 6.0:

#####################################
214 of (1/1): test_change_user  
#####################################
mysql_client_test.c:16999: check failed: 'rc'
[22 Apr 2009 10:51] 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/72653

2864 Bernt M. Johnsen	2009-04-22
      Bug#23471 Added SET SQL_MODE = '' where needed and added some @localhost-users to make the test runnable in more settings.
[22 Apr 2009 17:14] Patrick Crews
Ok to push.
[28 Apr 2009 14:22] 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/72912

2874 Bernt M. Johnsen	2009-04-28
      Bug#23471 SET SQL_MODE to '' for all subtests which fails for some SQL_MODE. And added some @localhost users for increased usability.
[28 Apr 2009 14:47] Bernt Marius Johnsen
Have tried all possible values of SQL_MODE (present in the 5.1 ref man). Will backport to 5.0 when reviewed and the merge from there to 5.1 and 6.0
[5 May 2009 9: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/73364

2734 Bernt M. Johnsen	2009-05-05
      Bug#23471 prepared for commit in 5.0 gca branch
[5 May 2009 10: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/73380

2891 Bernt M. Johnsen	2009-05-05 [merge]
      Bug#23471 prepared for commit in 5.1 gca branch
[5 May 2009 11:58] 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/73384

3253 Bernt M. Johnsen	2009-05-05 [merge]
      Bug#23471 prepared for commit in 6.0 gca branch
[28 May 2009 7:41] Bugs System
Pushed into 5.0.83 (revid:joro@sun.com-20090528073529-q9b8s60vlpu28fny) (version source revid:bernt.johnsen@sun.com-20090507065727-76j7we99jlkmjxd2) (merge vers: 5.0.82) (pib:6)
[28 May 2009 8:14] Bugs System
Pushed into 5.1.36 (revid:joro@sun.com-20090528073639-yohsb4q1jzg7ycws) (version source revid:mats@sun.com-20090511132802-nnkiyb2huih1tklz) (merge vers: 5.1.35) (pib:6)
[29 May 2009 1:04] Paul DuBois
Test suite change. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[17 Jun 2009 19:27] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090616183122-chjzbaa30qopdra9) (version source revid:bernt.johnsen@sun.com-20090506113229-h9icr0c61gvhgjd9) (merge vers: 6.0.12-alpha) (pib:11)
[18 Jun 2009 14:30] Paul DuBois
Test suite change. No changelog entry needed.
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:33] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)