Debian Codegraph @

mysql-test/suite/ndb/t/show_indexes.inc

raw
1 --disable_query_log
2 let $dump_file = $MYSQLTEST_VARDIR/tmp/desc.txt;
3
4 # Dump the output of ndb_desc to file
5 --exec $NDB_DESC -d test t1 > $dump_file
6
7 # Load the file into a temporary table
8 CREATE TEMPORARY TABLE test.desc (a varchar(512))
9 CHARSET latin1 ENGINE = HEAP;
10
11 --replace_result $dump_file DUMP_FILE
12 eval LOAD DATA INFILE '$dump_file' INTO TABLE test.desc;
13 --remove_file $dump_file
14
15 # Query the temporary table
16 SELECT TRIM(TRAILING "\r" FROM a) as 'Indexes:' FROM test.desc
17 WHERE a REGEXP "- (UniqueHashIndex|OrderedIndex)"
18 AND a NOT LIKE "PRIMARY KEY%"
19 ORDER BY a;
20
21 DROP TABLE test.desc;
22 --enable_query_log