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.
