| 1 |
--source include/have_ndb.inc |
| 2 |
|
| 3 |
#BUG17069285 |
| 4 |
|
| 5 |
CREATE LOGFILE GROUP lg_1 |
| 6 |
ADD UNDOFILE 'undo_1.log' |
| 7 |
INITIAL_SIZE 16M |
| 8 |
UNDO_BUFFER_SIZE = 1M |
| 9 |
ENGINE NDBCLUSTER; |
| 10 |
|
| 11 |
CREATE TABLESPACE ts_1 |
| 12 |
ADD DATAFILE 'data_1.dat' |
| 13 |
USE LOGFILE GROUP lg_1 |
| 14 |
ENGINE NDBCLUSTER; |
| 15 |
|
| 16 |
CREATE DATABASE diskdb; |
| 17 |
|
| 18 |
USE diskdb; |
| 19 |
|
| 20 |
CREATE TABLE t1 |
| 21 |
(id int unsigned NOT NULL auto_increment PRIMARY KEY, |
| 22 |
value varchar(10)) ENGINE NDBCLUSTER |
| 23 |
TABLESPACE ts_1 STORAGE DISK; |
| 24 |
|
| 25 |
INSERT INTO t1 (value) VALUES |
| 26 |
('abc'), ('def'), ('ghi'), ('jkl'), |
| 27 |
('mno'), ('pqr'), ('stu'), ('vwx'), ('yz'); |
| 28 |
|
| 29 |
let $MYSQLD_DATADIR= `select @@datadir`; |
| 30 |
|
| 31 |
--error 256,1 |
| 32 |
--exec $NDB_PRINT_FILE |
| 33 |
--error 256,1 |
| 34 |
--exec $NDB_PRINT_FILE -v |
| 35 |
--error 256,1 |
| 36 |
--exec $NDB_PRINT_FILE -q |
| 37 |
--error 256,1 |
| 38 |
--exec $NDB_PRINT_FILE -v -q |
| 39 |
--exec $NDB_PRINT_FILE $MYSQLD_DATADIR/../../ndbd.2/ndb_2_fs/data_1.dat > $NDB_TOOLS_OUTPUT |
| 40 |
--exec $NDB_PRINT_FILE -v $MYSQLD_DATADIR/../../ndbd.2/ndb_2_fs/data_1.dat > $NDB_TOOLS_OUTPUT |
| 41 |
--exec $NDB_PRINT_FILE -q $MYSQLD_DATADIR/../../ndbd.2/ndb_2_fs/data_1.dat > $NDB_TOOLS_OUTPUT |
| 42 |
--exec $NDB_PRINT_FILE -v -q $MYSQLD_DATADIR/../../ndbd.2/ndb_2_fs/data_1.dat > $NDB_TOOLS_OUTPUT |
| 43 |
--exec $NDB_PRINT_FILE --help > $NDB_TOOLS_OUTPUT |
| 44 |
|
| 45 |
|
| 46 |
DROP TABLE t1; |
| 47 |
|
| 48 |
DROP DATABASE diskdb; |
| 49 |
|
| 50 |
ALTER TABLESPACE ts_1 |
| 51 |
DROP DATAFILE 'data_1.dat'; |
| 52 |
|
| 53 |
DROP TABLESPACE ts_1; |
| 54 |
|
| 55 |
DROP LOGFILE GROUP lg_1 |
| 56 |
ENGINE NDBCLUSTER; |
| 57 |
--remove_file $NDB_TOOLS_OUTPUT |