Bug #32236 "information_schema.routines" has new columns: Tests need to be adjusted

• Submitted: 9 Nov 2007 15:46
• Modified: 12 Nov 2007 14:07
• Reporter: Joerg Bruehe
• Status: Duplicate
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 6.0.4-alpha
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[9 Nov 2007 15:46] Joerg Bruehe

Description:
Found when doing "make test-bt" locally in current 6.0 tree.

Identical in all "*_storedproc_08" tests:
funcs_1.innodb_storedproc_08
funcs_1.memory_storedproc_08
funcs_1.myisam_storedproc_08
funcs_1.ndb_storedproc_08

--- /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/innodb_storedproc_08.result  2007-08-07 04:45:53.000000000 +0300
+++ /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/innodb_storedproc_08.reject  2007-11-09 09:02:22.000000000 +0300
@@ -103,6 +103,13 @@
 ROUTINE_SCHEMA db_storedproc
 ROUTINE_NAME   fn_1
 ROUTINE_TYPE   FUNCTION
+DATA_TYPE      year
+CHARACTER_MAXIMUM_LENGTH       NULL
+CHARACTER_OCTET_LENGTH NULL
+NUMERIC_PRECISION      NULL
+NUMERIC_SCALE  NULL
+CHARACTER_SET_NAME     NULL
+COLLATION_NAME NULL
 DTD_IDENTIFIER year(4)
 ROUTINE_BODY   SQL
 ROUTINE_DEFINITION     BEGIN
@@ -117,8 +124,8 @@
 SQL_DATA_ACCESS        CONTAINS SQL
 SQL_PATH       NULL
 SECURITY_TYPE  DEFINER
-CREATED        <modified>
-LAST_ALTERED   <created>
+CREATED        <create>
+LAST_ALTERED   <modify>
 SQL_MODE
 ROUTINE_COMMENT
 DEFINER        root@localhost

Similar differences further down in the test, just the line numbers:
@@ -130,6 +137,13 @@
@@ -144,8 +158,8 @@
@@ -157,6 +171,13 @@
@@ -169,8 +190,8 @@
@@ -182,6 +203,13 @@
@@ -194,8 +222,8 @@
@@ -321,6 +349,13 @@
@@ -335,8 +370,8 @@
@@ -348,6 +383,13 @@
@@ -362,8 +404,8 @@
@@ -375,6 +417,13 @@
@@ -387,8 +436,8 @@
@@ -400,6 +449,13 @@
@@ -412,8 +468,8 @@
@@ -532,6 +588,13 @@
@@ -546,8 +609,8 @@
@@ -559,6 +622,13 @@
@@ -573,8 +643,8 @@
@@ -573,8 +643,8 @@
@@ -586,6 +656,13 @@
@@ -598,8 +675,8 @@
@@ -611,6 +688,13 @@
@@ -623,8 +707,8 @@

How to repeat:
Run the "funcs_1" suite.

[12 Nov 2007 13:59] Patrick Crews

This is the same issue from Bug#31544: funcs_1: <engine>_storedproc_08 broken, adjustment to 5.2 properties missing.

A patch has been reviewed and ok'd to push.  It is in the maint tree, but not yet moved into the main and build trees.

[12 Nov 2007 14:07] Patrick Crews

Will find out when the patch for Bug#31544 will be pushed in the main and build trees to correct this issue.

The patch has been tested / reviewed and will eliminate this problem.