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

Syntax:

append_file file_name [terminator]

Example:

cat_file

Syntax:

cat_file file_name

Example:

change_user

Syntax:

change_user [user_name], [password], [db_name]

Example:

character_set

Syntax:

character_set charset_name

Example:

chmod

Syntax:

chmod octal_mode file_name

Example:

connect

Syntax:

connect (name, host_name, user_name, password, db_name [,port_num [,socket [,options [,default_auth]]]])

Example:

connection

Syntax:

connection connection_name

Example:

copy_file

Syntax:

copy_file from_file to_file

Example:

dec

Syntax:

dec $variable_name

Example:

delimiter

Syntax:

delimiter string

Example:

die

Syntax:

die [message]

Example:

diff_files

Syntax:

diff_files file_name1 file_name2

Example:

dirty_close

Syntax:

dirty_close connection_name

disable/enable_abort_on_error

Syntax:

disable_abort_on_error,enable_abort_on_error

Example:

disable/enable_connect_log

Syntax:

disable_connect_log, enable_connect_log

Example:

disable/enable_info

Syntax:

disable_info, enable_info

Example:

disable/enable_metadata

Syntax:

disable_metadata, enable_metadata

Example:

disable/enable_parsing

Syntax:

disable_parsing, enable_parsing

Example:

disable/enable_ps_protocol

Syntax:

disable_ps_protocol, enable_ps_protocol

Example:

disable/enable_query_log

Syntax:

disable_query_log, enable_query_log

Example:

disable/enable_reconnect

Syntax:

disable_reconnect, enable_reconnect

Example:

disable/enable_result_log

Syntax:

disable_result_log, enable_result_log

Example:

disable/enable_rpl_parse

Syntax:

disable_rpl_parse, enable_rpl_parse

Example:

disable/enable_warnings

Syntax:

disable_warnings, enable_warnings

Example:

disconnect

Syntax:

disconnect connection_name

Example:

echo

Syntax:

echo text

Example:

end

Syntax:

end

end_timer

Syntax:

end_timer

error

Syntax:

error error_code [,error_code[,...]]

Example:

eval

Syntax:

eval statement

Example:

exec

Syntax:

exec command [arg1[,arg2[,...]]]

Example:

exit

Syntax:

exit

file_exists

Syntax:

file_exists file_name

Example:

horizontal_results

Syntax:

horizontal_results

Example:

if

Syntax:

if(expr)

Example:

inc

Syntax:

inc $var_name

Example:

let

Syntax:

let $var_name = value

let $var_name = query_get_value(query, col_name, row_num)

Example:

mkdir

Syntax:

mkdir dir_name

Example:

list_files

Syntax:

list_files dir_name [pattern]

Example:

list_files_append_file

Syntax:

list_files_append_file file_name dir_name [pattern]

Example:

list_files_write_file

Syntax:

list_files_write_file file_name dir_name [pattern]

Example:

lowercase_result

Syntax:

lowercase_result

Example:

move_file

Syntax:

move_file from_file to_file

Example:

perl

Syntax:

perl [terminator]

Example:

ping

Syntax:

ping

query

Syntax:

query [statement]

query_get_value

Syntax:

query_get_value(query,col_name,row_num)

Example:

query_horizontal

Syntax:

query_horizontal statement

Example:

query_vertical

Syntax:

query_vertical statement

Example:

real_sleep

Syntax:

real_sleep num

Example:

reap

Syntax:

reap

remove_file

Syntax:

remove_file file_name

Example:

remove_files_wildcard

Syntax:

remove_files_wildcard dir_name [pattern]

Example:

replace_column

Syntax:

replace_column col_num value [col_num value [,...] ]

Example:

replace_regex

Syntax:

replace_regex /pattern/replacement/[i] ...

Example:

replace_result

Syntax:

replace_result from_val to_val [from_val to_val [...]]

Example:

require

Syntax:

require file_name

Example:

result

Syntax:

result file_name

rmdir

Syntax:

rmdir dir_name

Example:

save_master_pos

Syntax:

save_master_pos

send

Syntax:

send [statement]

Example:

send_eval

Syntax:

send_eval [statement]

Example:

send_quit

Syntax:

send_quit [timeout]

Example:

shutdown_server

Syntax:

shutdown_server [timeout]

Example:

sleep

Syntax:

sleep num

Example:

sorted_result

Syntax:

sorted_result

Example:

source

Syntax:

source file_name

Example:

start_timer

Syntax:

start_timer

sync_slave_with_master

Syntax:

sync_slave_with_master [connection_name]

sync_with_master

Syntax:

sync_with_master offset

system

Syntax:

system command [arg1[,arg2[,...]]]

Example:

vertical_results

Syntax:

vertical_results

Example:

wait_for_slave_to_stop

Syntax:

wait_for_slave_to_stop

while

Syntax:

while(expr)

Example:

write_file

Syntax:

write_file file_name [terminator]

Example: