← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

Viewing changes to mysql-test/include/have_multi_ndb.inc

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2011-11-08 11:31:13 UTC
  • Revision ID: package-import@ubuntu.com-20111108113113-3ulw01fvi4vn8m25
Tags: upstream-5.5.17
Import upstream version 5.5.17

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/include/have_multi_ndb.inc
 
1
# Setup connections to both MySQL Servers connected to the cluster
 
2
connect (server1,127.0.0.1,root,,test,$MASTER_MYPORT,);
 
3
connect (server2,127.0.0.1,root,,test,$MASTER_MYPORT1,);
 
4
 
 
5
# Check that server1 has NDB  support
 
6
connection server1;
 
7
let $engines_table= query_get_value(SHOW TABLES FROM information_schema LIKE 'ENGINES', Tables_in_information_schema (ENGINES), 1);
 
8
disable_query_log;
 
9
if (`SELECT 1 FROM dual WHERE '$engines_table' = 'engines'`)
 
10
{
 
11
--require r/true.require
 
12
SELECT (support = 'YES' or support = 'DEFAULT' or support = 'ENABLED') as `TRUE` FROM information_schema.engines WHERE engine = 'ndbcluster';
 
13
--source include/ndb_not_readonly.inc
 
14
}
 
15
enable_query_log;
 
16
 
 
17
# Check that server2 has NDB support
 
18
connection server2;
 
19
let $engines_table= query_get_value(SHOW TABLES FROM information_schema LIKE 'ENGINES', Tables_in_information_schema (ENGINES), 1);
 
20
disable_query_log;
 
21
if (`SELECT 1 FROM dual WHERE '$engines_table' = 'engines'`)
 
22
{
 
23
--require r/true.require
 
24
SELECT (support = 'YES' or support = 'DEFAULT' or support = 'ENABLED') as `TRUE` FROM information_schema.engines WHERE engine = 'ndbcluster';
 
25
--source include/ndb_not_readonly.inc
 
26
}
 
27
enable_query_log;
 
28
 
 
29
# cleanup
 
30
 
 
31
connection server1;
 
32
disable_query_log;
 
33
disable_warnings;
 
34
--error 0,1051
 
35
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10;
 
36
flush tables;
 
37
flush status;
 
38
enable_warnings;
 
39
enable_query_log;
 
40
 
 
41
connection server2;
 
42
disable_query_log;
 
43
disable_warnings;
 
44
--error 0,1051
 
45
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10;
 
46
flush tables;
 
47
flush status;
 
48
enable_warnings;
 
49
enable_query_log;
 
50
 
 
51
# Set the default connection
 
52
connection server1;