Bug #32460 Test "nist_all" fails: Number of tables (and columns) changed
Submitted: 16 Nov 2007 20:46 Modified: 9 Jan 2008 14:02
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.0.51 OS:Any (all !)
Assigned to: Matthias Leich CPU Architecture:Any
Triage: D3 (Medium)

[16 Nov 2007 20:46] Joerg Bruehe
Description:
Detected in a build based on the "community" tree:

nist_all                       [ fail ]

--- /PATH/mysql-test/suite/nist/r/nist_all.result
+++ /PATH/mysql-test/var/log/nist_all.reject
@@ -13161,19 +13161,19 @@

 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES ;
 COUNT(*)
-59
+60
 set @exp_val:= 59;

-TEST-INFO: row count passed
+TEST-INFO: failed, wrong row count got:60 expected: 59

 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES A, INFORMATION_SCHEMA.TABLES B
 WHERE A.TABLE_SCHEMA = B.TABLE_SCHEMA
 AND A.TABLE_NAME = B.TABLE_NAME ;
 COUNT(*)
-59
+60
 set @exp_val:= 59;

-TEST-INFO: row count passed
+TEST-INFO: failed, wrong row count got:60 expected: 59

 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES A
 WHERE NOT EXISTS (
@@ -13228,13 +13228,13 @@
 AND Y.TABLE_SCHEMA = Z.TABLE_SCHEMA
 AND Y.TABLE_NAME = Z.TABLE_NAME) ;
 COUNT(*)
-59
+60

-TEST-INFO: NIST expectations violated (was to be expected), result got:59 expected: 0
+TEST-INFO: NIST expectations violated (was to be expected), result got:60 expected: 0
 Please check nist-MySQL.txt  41

-TEST-INFO: passed (MYSQL expectations)
+TEST-INFO: MySQL expectations violated , result got:60 expected: 59

 SELECT TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES
 WHERE TABLE_SCHEMA = 'FLATER' AND TABLE_NAME = 'USIG';
@@ -13325,11 +13325,11 @@
 SELECT COUNT(*)
 FROM INFORMATION_SCHEMA.COLUMNS ;
 COUNT(*)
-343
+361
 set @val_c= 343;
 set @exp_val:= @val_c;

-TEST-INFO: row count passed
+TEST-INFO: failed, wrong row count got:361 expected: 343

 SELECT COUNT(*)
 FROM INFORMATION_SCHEMA.COLUMNS A,
@@ -13338,10 +13338,10 @@
 AND A.TABLE_NAME = B.TABLE_NAME
 AND A.COLUMN_NAME = B.COLUMN_NAME ;
 COUNT(*)
-343
+361
 set @exp_val:= @val_c;

-TEST-INFO: row count passed
+TEST-INFO: failed, wrong row count got:361 expected: 343

 SELECT COUNT(*)
 FROM INFORMATION_SCHEMA.COLUMNS A,
@@ -13350,10 +13350,10 @@
 AND A.TABLE_NAME = B.TABLE_NAME
 AND A.ORDINAL_POSITION = B.ORDINAL_POSITION ;
 COUNT(*)
-343
+361
 set @exp_val:= @val_c;

-TEST-INFO: row count passed
+TEST-INFO: failed, wrong row count got:361 expected: 343

 SELECT COUNT(*)
 FROM INFORMATION_SCHEMA.COLUMNS A

mysqltest: Result content mismatch

How to repeat:
Run the "nist" suite on the community tree.

This bug did *not* occur in the last "enterprise" tree build, 5.0.50.

Suggested fix:
1) Change the test so that it (at one place only) lists the tables,
   from the difference quoted it cannot be detected which table
is the additional one.

2) Determine whether that additional table is in both the "community"
   and the "enterprise" build, or in "community" only.

3) If in both trees, update the test -
   if specific to "community", restrict the test to the "enterprise" tree.
[9 Jan 2008 14:02] Matthias Leich
Patches also pushed to
mysql-test-extra-5.1
mysql-test-extra-6.0

Maintenance of test scripts and results, no documentation needed.