Debian Codegraph @

mysql-test/suite/ndb/t/ndb_bug26793.test

raw
1 -- source include/have_ndb.inc
2
3 --disable_warnings
4 DROP TABLE IF EXISTS t1;
5 --enable_warnings
6
7 CREATE TABLE `test` (
8 `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
9 `t` VARCHAR( 10 ) NOT NULL
10 ) ENGINE = ndbcluster;
11
12 # Add user1@localhost with a specific password
13 # and connect as that user
14 CREATE USER user1@localhost IDENTIFIED BY 'pass';
15 GRANT USAGE ON *.* TO user1@localhost;
16 connect (user1,localhost,user1,pass,*NO-ONE*);
17
18 # Run the query 100 times
19 disable_query_log;
20 disable_result_log;
21 let $i= 100;
22 while ($i)
23 {
24 select count(*) from information_schema.tables union all select count(*) from information_schema.tables union all select count(*) from information_schema.tables;
25 dec $i;
26 }
27 enable_query_log;
28 enable_result_log;
29
30 disconnect user1;
31
32 # Switch back to the default connection and cleanup
33 connection default;
34 DROP TABLE `test`.`test`;
35 drop user user1@localhost;
36