Drizzletest Commands
The commands that are endorsed in Drizzletest are delineated in the following documentation. Examples are given for the commands. Browse tests/t for more examples.
Note
The commands are not case sensitive
append_file
append_file file_name [terminator]
cat_file
cat_file file_name
change_user
change_user [user_name], [password], [db_name]
character_set
character_set charset_name
chmod
chmod octal_mode file_name
connect
connect (name, host_name, user_name, password, db_name [,port_num [,socket [,options [,default_auth]]]])
connection
connection connection_name
copy_file
copy_file from_file to_file
delimiter
delimiter string
diff_files
diff_files file_name1 file_name2
dirty_close
dirty_close connection_name
disable/enable_abort_on_error
disable_abort_on_error,enable_abort_on_error
disable/enable_connect_log
disable_connect_log, enable_connect_log
disable/enable_info
disable_info, enable_info
disable/enable_parsing
disable_parsing, enable_parsing
disable/enable_ps_protocol
disable_ps_protocol, enable_ps_protocol
disable/enable_query_log
disable_query_log, enable_query_log
disable/enable_reconnect
disable_reconnect, enable_reconnect
disable/enable_result_log
disable_result_log, enable_result_log
disable/enable_rpl_parse
disable_rpl_parse, enable_rpl_parse
disable/enable_warnings
disable_warnings, enable_warnings
disconnect
disconnect connection_name
error
error error_code [,error_code[,...]]
exec
exec command [arg1[,arg2[,...]]]
file_exists
file_exists file_name
horizontal_results
horizontal_results
let
let $var_name = value
let $var_name = query_get_value(query, col_name, row_num)
list_files
list_files dir_name [pattern]
list_files_append_file
list_files_append_file file_name dir_name [pattern]
list_files_write_file
list_files_write_file file_name dir_name [pattern]
lowercase_result
lowercase_result
move_file
move_file from_file to_file
query_get_value
query_get_value(query,col_name,row_num)
query_horizontal
query_horizontal statement
query_vertical
query_vertical statement
real_sleep
real_sleep num
remove_file
remove_file file_name
remove_files_wildcard
remove_files_wildcard dir_name [pattern]
replace_column
replace_column col_num value [col_num value [,...] ]
replace_regex
replace_regex /pattern/replacement/[i] ...
replace_result
replace_result from_val to_val [from_val to_val [...]]
require
require file_name
save_master_pos
save_master_pos
send_eval
send_eval [statement]
send_quit
send_quit [timeout]
shutdown_server
shutdown_server [timeout]
sorted_result
sorted_result
sync_slave_with_master
sync_slave_with_master [connection_name]
sync_with_master
sync_with_master offset
system
system command [arg1[,arg2[,...]]]
vertical_results
vertical_results
wait_for_slave_to_stop
wait_for_slave_to_stop
write_file
write_file file_name [terminator]