| 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 'Primary keys:' FROM test.desc |
| 17 |
WHERE a LIKE "%PRIMARY%"; |
| 18 |
|
| 19 |
DROP TABLE test.desc; |
| 20 |
--enable_query_log |