bk commit into 5.0 tree (stewart:1.2470) BUG#26793

[Stewart Smith]

Below is the list of changes that have just been committed into a local
5.0 repository of stewart. When stewart does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-07-26 20:24:54+10:00, stewart@stripped +2 -0
  [PATCH] BUG#26793 test: mysqld crashes in NDB on I_S query
  
  Reduce case and formalise into something we should be
  able to use in mysql-test-run.
  
  Index: ndb-work/mysql-test/t/ndb_bug26793.test
  ===================================================================

  mysql-test/r/ndb_bug26793.result@stripped, 2007-07-26 17:07:57+10:00,
stewart@stripped +9 -0
    BUG#26793 test: mysqld crashes in NDB on I_S query

  mysql-test/r/ndb_bug26793.result@stripped, 2007-07-26 17:07:57+10:00,
stewart@stripped +0 -0

  mysql-test/t/ndb_bug26793.test@stripped, 2007-07-26 17:06:48+10:00, stewart@stripped
+33 -0
    BUG#26793 test: mysqld crashes in NDB on I_S query

  mysql-test/t/ndb_bug26793.test@stripped, 2007-07-26 17:06:48+10:00, stewart@stripped
+0 -0

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	stewart
# Host:	willster.(none)
# Root:	/home/stewart/Documents/MySQL/5.0/ndb-merge
--- New file ---
+++ mysql-test/r/ndb_bug26793.result	07/07/26 17:07:57
DROP TABLE IF EXISTS t1;
CREATE TABLE `test` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`t` VARCHAR( 10 ) NOT NULL
) ENGINE = ndbcluster;
delete from mysql.db where user='';
flush privileges;
GRANT USAGE ON *.* TO user1@localhost IDENTIFIED BY 'pass';
DROP TABLE `test`.`test`;

--- New file ---
+++ mysql-test/t/ndb_bug26793.test	07/07/26 17:06:48
-- source include/have_ndb.inc

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE `test` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`t` VARCHAR( 10 ) NOT NULL
) ENGINE = ndbcluster;

delete from mysql.db where user='';

flush privileges;

GRANT USAGE ON *.* TO user1@localhost IDENTIFIED BY 'pass';

connect (user1,localhost,user1,pass,*NO-ONE*);

disable_query_log;
disable_result_log;
let $i= 100;
while ($i)
{
select count(*) from information_schema.tables union all select count(*) from
information_schema.tables union all select count(*) from information_schema.tables;
dec $i;
}
enable_query_log;
enable_result_log;

connect (root,localhost,root,,test);
connection root;
DROP TABLE `test`.`test`;