| Server IP : 45.40.142.9 / Your IP : 216.73.216.250 Web Server : Apache System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : bayspec ( 506) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/mysql-test/suite/ndb/t/ |
Upload File : |
############################################################# # Author: Guangbao # Date: 2007-10-31 # Purpose: mix backup/restore test for basic online alter table ############################################################## --source include/have_ndb.inc # Directory containing the saved backup files let $backup_data_dir=$MYSQL_TEST_DIR/suite/ndb/backups; ############################## # mix endian restore section # ############################## # # Restore backup files (from little endian) # --disable_warnings USE test; DROP TABLE IF EXISTS t1; --enable_warnings --echo ********************************* --echo * restore tables w/ new column from little endian --echo ********************************* --exec $NDB_RESTORE --no-defaults -b 1 -n 1 -m -r $backup_data_dir/51_d2_le >> $NDB_TOOLS_OUTPUT 2>&1 --exec $NDB_RESTORE --no-defaults -b 1 -n 2 -r $backup_data_dir/51_d2_le >> $NDB_TOOLS_OUTPUT 2>&1 SHOW TABLES; SHOW CREATE TABLE t1; SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a; DROP TABLE t1; # # Restore backup files (from big endian) # --echo ********************************* --echo * restore tables w/ new column from big endian --echo ********************************* --exec $NDB_RESTORE --no-defaults -b 1 -n 1 -m -r $backup_data_dir/51_d2_be >> $NDB_TOOLS_OUTPUT 2>&1 --exec $NDB_RESTORE --no-defaults -b 1 -n 2 -r $backup_data_dir/51_d2_be >> $NDB_TOOLS_OUTPUT 2>&1 SHOW TABLES; SHOW CREATE TABLE t1; SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a; DROP TABLE t1; # End of 5.1 Test Case