Bug #58097 "show warnings" has no output in ndb+ps test mode
Submitted: 9 Nov 2010 22:18 Modified: 11 Nov 2010 14:17
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:cluster 7.1.9 OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[9 Nov 2010 22:18] Joerg Bruehe
Test failure in the build of Cluster-7.1.9, on all platforms,
when the "ndb" suite is run in mode "ndb+ps":

ndb.ndb_native_default_support           [ retry-fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: ndb.ndb_native_default_support
--- /PATH/mysql-test/suite/ndb/r/ndb_native_default_support.result
+++ /PATH/mysql-test/suite/ndb/r/ndb_native_default_support.reject
@@ -1423,7 +1423,6 @@
 Warning    1101    BLOB/TEXT column 'f03' can't have a default value
 show warnings;
 Level  Code    Message
-Warning    1101    BLOB/TEXT column 'f03' can't have a default value
 show create table t1;
 Table  Create Table
 t1 CREATE TABLE `t1` (

mysqltest: Result length mismatch

In mode "ndb", the test passes.

How to repeat:
Run the "ndb" suite in mode "ndb+ps", on any platform.
[10 Nov 2010 13:39] 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:


3992 Jonas Oreland	2010-11-10
      ndb - bug#58097 - change testcase not to expose difference in ps/normal mode (difference is also there for e.g myisam)
[10 Nov 2010 13:40] Jonas Oreland
The difference also exists for myisam...
Didn't spend time investigating why.
Cause the "show warnings" is not essential for what test is trying to test.
Instead altered test case slightly
[10 Nov 2010 13:47] Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.21 (revid:jonas@mysql.com-20101110133911-76u6lvilv2moalji) (version source revid:jonas@mysql.com-20101110133911-76u6lvilv2moalji) (merge vers: 5.1.51-ndb-7.0.21) (pib:21)
[10 Nov 2010 13:50] Jonas Oreland
pushed to 7.0.21 and 7.1.10
[11 Nov 2010 14:17] Paul DuBois
Changes to test suite. No changelog entry needed.