Debian Codegraph @

mysql-test/suite/ndb/include/ndb_check_blob_tables.inc

raw
1 #
2 # ndb_check_blob_tables.inc - check that all blob tables use same hashmap as main table
3 #
4 # Usage:
5 # let $ndb_die_on_error=1; # 1 if it should fail on hashmap mismatch
6 # let $ndb_database=<table database>;
7 # let $ndb_table=<table name>;
8 # --source suite/ndb/include/ndb_check_blob_tables.inc
9 #
10
11 let $header=`SELECT CONCAT("Table: ", "$ndb_database", ".", "$ndb_table")`;
12
13 disable_query_log ONCE;
14 eval SELECT table_id into @describe_table_id from ndbinfo.dictionary_tables
15 WHERE table_name = "$ndb_table" AND database_name = "$ndb_database";
16
17 let $hashmap=`SELECT hash_map FROM ndbinfo.dictionary_tables WHERE table_id=@describe_table_id`;
18
19 echo $header;
20 echo HashMap: $hashmap;
21
22 disable_query_log ONCE;
23 SELECT CONCAT("HashMap: ", hash_map, "\n") AS ""
24 FROM ndbinfo.dictionary_tables t JOIN ndbinfo.blobs b
25 ON t.table_name = b.blob_table_name
26 WHERE b.table_id = @describe_table_id;
27
28 if($ndb_die_on_error)
29 {
30 disable_query_log ONCE;
31 LET $unmatched=`SELECT count(*)
32 FROM ndbinfo.dictionary_tables t JOIN ndbinfo.blobs b
33 ON t.table_name = b.blob_table_name
34 WHERE b.table_id=@describe_table_id AND t.hash_map != "$hashmap"`;
35
36 assert($unmatched == 0);
37 }
38
39 let $hashmap=;
40 let $ndb_die_on_error=;
41 let $ndb_database=;
42 let $ndb_table=;