Bug #21648 information_schema test fails --with-ndbcluster

• Submitted: 15 Aug 2006 6:12
• Modified: 1 Sep 2006 8:09
• Reporter: Stewart Smith
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1.12bk
• Assigned to: Stewart Smith
• CPU Architecture: Any

[15 Aug 2006 6:12] Stewart Smith

Description:
*** r/information_schema.result 2006-08-15 06:20:19.575557000 +0300
--- r/information_schema.reject 2006-08-15 09:05:51.128240250 +0300
***************
*** 61,67 ****
--- 61,69 ----
  TRIGGERS
  USER_PRIVILEGES
  VIEWS
+ apply_status
  binlog_index
+ schema
  columns_priv
  db
  event
***************
*** 748,754 ****
  CREATE VIEW a1 (t_CRASHME) AS SELECT f1 FROM t_crashme GROUP BY f1;
  CREATE VIEW a2 AS SELECT t_CRASHME FROM a1;
  count(*)
! 113
  drop view a2, a1;
  drop table t_crashme;
  select table_schema,table_name, column_name from
--- 750,756 ----
  CREATE VIEW a1 (t_CRASHME) AS SELECT f1 FROM t_crashme GROUP BY f1;
  CREATE VIEW a2 AS SELECT t_CRASHME FROM a1;
  count(*)
! 115
  drop view a2, a1;
  drop table t_crashme;
  select table_schema,table_name, column_name from
***************
*** 847,853 ****
  flush privileges;
  SELECT table_schema, count(*) FROM information_schema.TABLES GROUP BY TABLE_SCHEMA;
  table_schema  count(*)
! cluster       1
  information_schema    23
  mysql 21
  create table t1 (i int, j int);
--- 849,855 ----
  flush privileges;
  SELECT table_schema, count(*) FROM information_schema.TABLES GROUP BY TABLE_SCHEMA;
  table_schema  count(*)
! cluster       3
  information_schema    23
  mysql 21
  create table t1 (i int, j int);
-------------------------------------------------------

How to repeat:
./mysql-test-run.pl --with-ndbcluster information_schema

Suggested fix:
have the test behave with ndbcluster running.

[15 Aug 2006 7:16] 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:

  http://lists.mysql.com/commits/10416

ChangeSet@1.2271, 2006-08-15 15:16:21+08:00, stewart@willster.(none) +2 -0
  BUG#21648 information_schema test fails --with-ndbcluster
  
  make test work both with and without ndbcluster

[15 Aug 2006 7:54] Stewart Smith

jonas had a look at it, patch now in 5.1-ndb tree

[15 Aug 2006 8:50] Stewart Smith

also reviewed by gluh, major changer of information_schema test file

[1 Sep 2006 8:09] Jonas Oreland

pushed to 5.1.12, nothing to document