Bug #32245 Change in NDB is not reflected in the test results: on-line ADD COLUMN
Submitted: 9 Nov 2007 19:25 Modified: 9 Jan 2015 14:32
Reporter: Joerg Bruehe Email Updates:
Status: Won't fix Impact on me:
None 
Category:Tests: Cluster Severity:S3 (Non-critical)
Version:6.0.4-alpha,5.4 OS:Any
Assigned to: CPU Architecture:Any

[9 Nov 2007 19:25] Joerg Bruehe
Description:
It seems NDB got a functional change recently
(current 6.0 tree)
which is missing in the ".result" files of the "extra" tests:

--- /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/ndb_func_view.result 2007-11-09 00:34:35.000000000 +0300
+++ /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/ndb_func_view.reject 2007-11-09 09:07:22.000000000 +0300
@@ -11,18 +11,40 @@
 PRIMARY KEY(id)
 ) ENGINE = <engine_to_be_tested>;
 ALTER TABLE t1_values ADD my_char_30        CHAR(30);
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_varchar_1000   VARCHAR(1000);
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_binary_30      BINARY(30);
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_varbinary_1000 VARBINARY(1000);
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_datetime       DATETIME;
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_date           DATE;
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD ts_dummy          TIMESTAMP;
 ALTER TABLE t1_values ADD my_timestamp      TIMESTAMP;
 ALTER TABLE t1_values ADD my_time           TIME;
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_year           YEAR;
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_bigint         BIGINT;
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_double         DOUBLE;
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 ALTER TABLE t1_values ADD my_decimal        DECIMAL(64,30);
+Warnings:
+Warning        1477    Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
 SET sql_mode = 'traditional';
 INSERT INTO t1_values SET id = 0;
 INSERT INTO t1_values SET

How to repeat:
Run "make test-bt".

Suggested fix:
Adapt the ".result" file.
[4 Sep 2008 18:09] Joerg Bruehe
Same issue in Cluster-6.3.17

*Please*, run "make test-bt"
and then adapt the result files to your functional changes.