Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting
Mailing Lists: lists.mysql.com > commits > 07 > 072203.html (Request Expert lists.mysql.com Support)

[patch 1/2] BUG#26793 test: mysqld crashes in NDB on I_S query

From: <stewart(at)flamingspork.com>
Date: Thu Jul 26 2007 - 02:46:12 EDT


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

  • /dev/null 1970-01-01 00:00:00.000000000 +0000
    +++ ndb-work/mysql-test/t/ndb_bug26793.test 2007-07-16 17:16:36.355344342 +1000
    @@ -0,0 +1,29 @@
    +-- 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*);
    +
    +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;
    +}
    +
    +connect (root,localhost,root,,test);
    +connection root;
    +DROP TABLE `test`.`test`;
    Index: ndb-work/mysql-test/r/ndb_bug26793.result
  • /dev/null 1970-01-01 00:00:00.000000000 +0000
    +++ ndb-work/mysql-test/r/ndb_bug26793.result 2007-07-16 17:17:38.878907357 +1000
    @@ -0,0 +1,509 @@
    +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';
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
    +count(*)
    +17
    +17
    +17
    +DROP TABLE `test`.`test`;
--
Stewart Smith

-- 
MySQL Code Commits Mailing List
For list archives: 
http://lists.mysql.com/commits
To unsubscribe:    
http://lists.mysql.com/commits?unsub=lists@pantek.com
Received on Thu Jul 26 02:48:10 2007

This archive was generated by hypermail 2.1.8 : Thu Aug 09 2007 - 19:14:42 EDT

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library