-1 before test before test SET GLOBAL max_connections = 1000; select otto from (select 1 as otto) as t1; otto 1 select otto from (select 1 as otto) as t1; otto 1 select friedrich from (select 1 as otto) as t1; mysqltest: At line 1: query 'select friedrich from (select 1 as otto) as t1' failed: ER_BAD_FIELD_ERROR (1054): Unknown column 'friedrich' in 'field list' select friedrich from (select 1 as otto) as t1; ERROR 42S22: Unknown column 'friedrich' in 'field list' select otto from (select 1 as otto) as t1; otto 1 select otto from (select 1 as otto) as t1; mysqltest: At line 1: query 'select otto from (select 1 as otto) as t1' succeeded - should have failed with sqlstate 42S22... mysqltest: At line 1: expecting a SQL-state (00000) from query 'remove_file MYSQLTEST_VARDIR/tmp/test_nonexistent.tmp' which cannot produce one... select friedrich from (select 1 as otto) as t1; ERROR 42S22: Unknown column 'friedrich' in 'field list' select friedrich from (select 1 as otto) as t1; mysqltest: At line 1: query 'select friedrich from (select 1 as otto) as t1' failed with wrong sqlstate 42S22: 'Unknown column 'friedrich' in 'field list'', instead of 00000... select otto from (select 1 as otto) as t1; otto 1 select 0 as "after_successful_stmt_errno" ; after_successful_stmt_errno 0 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 ER_PARSE_ERROR select 1064 as "after_wrong_syntax_errno" ; after_wrong_syntax_errno 1064 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 ER_PARSE_ERROR select 1064 as "after_let_var_equal_value" ; after_let_var_equal_value 1064 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 set @my_var= 'abc' ; select 0 as "after_set_var_equal_value" ; after_set_var_equal_value 0 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 ER_PARSE_ERROR select 1064 as "after_disable_warnings_command" ; after_disable_warnings_command 1064 drop table if exists t1 ; garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 drop table if exists t1 ; select 0 as "after_disable_warnings" ; after_disable_warnings 0 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 select 3 from t1 ; ERROR 42S02: Table 'test.t1' doesn't exist ER_NO_SUCH_TABLE select 1146 as "after_minus_masked" ; after_minus_masked 1146 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 select 3 from t1 ; ERROR 42S02: Table 'test.t1' doesn't exist ER_NO_SUCH_TABLE select 1146 as "after_!_masked" ; after_!_masked 1146 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 select -1 as "after_let_errno_equal_value" ; after_let_errno_equal_value -1 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 prepare stmt from "select 3 from t1" ; ERROR 42S02: Table 'test.t1' doesn't exist ER_NO_SUCH_TABLE select 1146 as "after_failing_prepare" ; after_failing_prepare 1146 create table t1 ( f1 char(10)); garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 prepare stmt from "select 3 from t1" ; select 0 as "after_successful_prepare" ; after_successful_prepare 0 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 execute stmt; 3 select 0 as "after_successful_execute" ; after_successful_execute 0 drop table t1; garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 execute stmt; ERROR 42S02: Table 'test.t1' doesn't exist ER_NO_SUCH_TABLE select 1146 as "after_failing_execute" ; after_failing_execute 1146 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 execute __stmt_; ERROR HY000: Unknown prepared statement handler (__stmt_) given to EXECUTE ER_UNKNOWN_STMT_HANDLER select 1243 as "after_failing_execute" ; after_failing_execute 1243 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 deallocate prepare stmt; select 0 as "after_successful_deallocate" ; after_successful_deallocate 0 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 deallocate prepare __stmt_; ERROR HY000: Unknown prepared statement handler (__stmt_) given to DEALLOCATE PREPARE ER_UNKNOWN_STMT_HANDLER select 1243 as "after_failing_deallocate" ; after_failing_deallocate 1243 garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 ER_PARSE_ERROR select 1064 as "after_--disable_abort_on_error" ; after_--disable_abort_on_error 1064 select 3 from t1 ; ERROR 42S02: Table 'test.t1' doesn't exist select 3 from t1 ; ERROR 42S02: Table 'test.t1' doesn't exist select 3 from t1 ; ERROR 42S02: Table 'test.t1' doesn't exist ER_NO_SUCH_TABLE select 1146 as "after_!errno_masked_error" ; after_!errno_masked_error 1146 select 3 from t1; mysqltest: At line 1: query 'select 3 from t1' failed with wrong errno ER_NO_SUCH_TABLE (1146): 'Table 'test.t1' doesn't exist', instead of ER_HASHCHK (1000)... ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 is empty ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nonsense' at line 1 is empty garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 ER_PARSE_ERROR select 1064 as "after_--enable_abort_on_error" ; after_--enable_abort_on_error 1064 select 3 from t1 ; ERROR 42S02: Table 'test.t1' doesn't exist select 3 from t1; mysqltest: At line 1: query 'select 3 from t1' failed with wrong errno ER_NO_SUCH_TABLE (1146): 'Table 'test.t1' doesn't exist', instead of ER_PARSE_ERROR (1064)... garbage; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 select 2; select 3; 3 3 select 5; ERROR 42S02: Table 'test.t1' doesn't exist select 7; 7 7 mysqltest: At line 1: End of line junk detected: "OCNE" connect con1,localhost,root,,; connection default; disconnect con1; select 5 from t1; lower case name abc xyz is empty is empty "Yes it's empty" hello hello ;;;;;;;; # MySQL: -- The mysqltest: At line 1: Extra argument '6' passed to 'sleep' mysqltest: At line 1: Extra argument '6' passed to 'sleep' mysqltest: At line 1: Extra argument 'A comment show status' passed to 'sleep' mysqltest: At line 1: End of line junk detected: "sleep 7 # Another comment " mysqltest: At line 1: Extra argument 'comment # comment 3 disable_query_log' passed to 'disconnect' mysqltest: At line 1: Extra argument 'comment # comment 3 disable_query_log' passed to 'disconnect' mysqltest: At line 1: End of line junk detected: "disconnect default # # comment # comment2 # comment 3 --disable_query_log " mysqltest: At line 1: End of line junk detected: "disconnect default # comment # comment part2 # comment 3 --disable_query_log " mysqltest: At line 1: Extra delimiter ";" found mysqltest: At line 1: Extra delimiter ";" found mysqltest: At line 1: Spurious text after `query` expression mysqltest: At line 1: Spurious text after `query` expression mysqltest: At line 2: Spurious text after `query` expression mysqltest: At line 1: Missing argument(s) to 'error' mysqltest: At line 1: Missing argument(s) to 'error' mysqltest: At line 1: The sqlstate definition must start with an uppercase S mysqltest: At line 1: The error name definition must start with an uppercase E or W or H mysqltest: At line 1: Invalid argument to error: '9eeeee' - the errno may only consist of digits[0-9] mysqltest: At line 1: Invalid argument to error: '1sssss' - the errno may only consist of digits[0-9] mysqltest: At line 1: The sqlstate must be exactly 5 chars long mysqltest: At line 1: The sqlstate may only consist of digits[0-9] and _uppercase_ letters mysqltest: At line 1: The sqlstate must be exactly 5 chars long mysqltest: At line 1: Unknown SQL error name 'E9999' mysqltest: At line 1: Invalid argument to error: '999e9' - the errno may only consist of digits[0-9] mysqltest: At line 1: Invalid argument to error: '9b' - the errno may only consist of digits[0-9] mysqltest: At line 1: Too many errorcodes specified MySQL "MySQL" MySQL: The world''s most popular open source database "MySQL: The world's most popular open source database" MySQL: The world''s most popular open source database # MySQL: The world''s # most popular open # source database - MySQL: The world''s - most popular open - source database - MySQL: The world''s -- most popular -- open source database # MySQL: The --world''s # most popular -- open - source database "MySQL: The world's most popular; open source database" "MySQL: The world's most popular ; open source database" "MySQL: The world's most popular ;open source database" echo message echo message mysqltest: At line 1: Missing argument in exec MySQL "MySQL" MySQL: The world''s most popular open source database # MySQL: The # world''s most # popular open # source database -- MySQL: The -- world''s most -- popular -- open source database # MySQL: The - world''s most -- popular open # source database '# MySQL: The - world''s most -- popular open # source database' "# MySQL: The - world''s most -- popular open # source database" hej hej hej 1 a long variable content a long variable content a long a long variable content variable content a long \$where variable content banana = banana Not a banana: ba\$cat\$cat with\`some"escaped\'quotes with\`some"escaped\'quotes single'tick`backtick mysqltest: At line 1: Missing arguments to let mysqltest: At line 1: Missing variable name in let mysqltest: At line 1: Missing assignment operator in let mysqltest: At line 1: Missing assignment operator in let mysqltest: At line 1: Missing assignment operator in let mysqltest: At line 1: Missing variable name in let mysqltest: At line 1: Missing variable name in let mysqltest: At line 1: Missing assignment operator in let # Execute: --echo # success: $success # success: 1 # Execute: echo # success: $success ; # success: 1 # The next two variants work fine and expand the content of $success # Execute: --echo $success 1 # Execute: echo $success ; 1 # Check if let $B = $A is an assignment per value. let $A = initial value of A; let $B = initial value of B; let $B = $A # Content of $A is: initial value of B let $A = changed value of A; # Content of $B is: initial value of B let $B = changed value of B; # Content of $A is: changed value of A var2: content of variable 1 var3: content of variable 1 content of variable 1 length of var3 is longer than 0 var1 hi 1 hi there var2 2 var2 again 2 var3 two columns with same name 1 2 3 var4 from query that returns NULL var5 from query that returns no row failing query in let create table t1 (a varchar(100)); insert into t1 values ('`select 42`'); `select 42` insert into t1 values ('$dollar'); $dollar `select 42` drop table t1; mysqltest: At line 1: query 'let $var2= `failing query`' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'failing query' at line 1 mysqltest: At line 1: Missing required argument 'filename' to command 'source' mysqltest: At line 1: Could not open 'non_existingFile' for reading, errno: 2 mysqltest: In included file "MYSQLTEST_VARDIR/tmp/recursive.sql": included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from MYSQLTEST_VARDIR/tmp/recursive.sql at line 1: included from at line 1: At line 1: Source directives are nesting too deep garbage ; mysqltest: In included file "MYSQLTEST_VARDIR/tmp/error.sql": included from at line 1: At line 1: query 'garbage ' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 2 = outer loop variable after while here is the sourced script 2 = outer loop variable before dec 1 = outer loop variable after dec 1 = outer loop variable after while here is the sourced script 1 = outer loop variable before dec 0 = outer loop variable after dec outer=2 ifval=0 outer=1 ifval=1 here is the sourced script ERROR 42S02: Table 'test.nowhere' doesn't exist ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'else' at line 1 In loop here is the sourced script In loop here is the sourced script In loop here is the sourced script In loop here is the sourced script In loop here is the sourced script In loop here is the sourced script In loop here is the sourced script In loop here is the sourced script In loop here is the sourced script here is the sourced script "hello" "hello" mysqltest: At line 2: Invalid argument to sleep "xyz" mysqltest: At line 2: Invalid argument to real_sleep "xyz" mysqltest: At line 1: Missing required argument 'sleep_delay' to command 'sleep' mysqltest: At line 1: Missing required argument 'sleep_delay' to command 'real_sleep' mysqltest: At line 1: Invalid argument to sleep "abc" mysqltest: At line 1: Invalid argument to real_sleep "abc" 1 101 -99 mysqltest: At line 1: Missing argument to inc mysqltest: At line 1: The argument to inc must be a variable (start with $) mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value mysqltest: At line 1: End of line junk detected: "1000" mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value -96 -96 -1 99 mysqltest: At line 1: Missing argument to dec mysqltest: At line 1: The argument to dec must be a variable (start with $) mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value mysqltest: At line 1: End of line junk detected: "1000" mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value mysqltest: At line 1: Cannot perform inc/dec on a non-numeric value mysqltest: At line 1: Missing arguments to system, nothing to do! mysqltest: At line 1: Missing arguments to system, nothing to do! system command 'NonExistsinfComamdn 2> /dev/null' failed test test2 test3 test4 outer true-inner true-inner again true-outer Counter is greater than 0, (counter=10) Counter should still be 10, is 10 Counter is not 0, (counter=0) Not space var works Counter is true, (counter=alpha) while with string, only once 5<7 5<7 again 5<7 still 5<6 5>=5 5>=5 again 5>3 5==5 5!=8 5!=five 5==3+2 5 == 5 hello == hello hello == hello hello != goodbye 'quoted' == ''quoted'' two words 'two words' "two words" two words are two words right answer anything goes 0 != string mysqltest: At line 2: Only == and != are supported for string values mysqltest: At line 2: Found junk '~= 6' after $variable in condition mysqltest: At line 2: Expression in if/while must begin with $, ` or a number mysqltest: At line 1: Missing right operand in comparison mysqltest: At line 1: Missing right operand in comparison counter is 2 counter is 3 counter is 4 counter is 5 counter is 6 counter is 7 1 Testing while with not mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest_while.inc": included from at line 1: At line 64: Nesting too deeply mysqltest: At line 1: missing '(' in while mysqltest: At line 1: missing ')' in while mysqltest: At line 1: Missing '{' after while. Found "dec $i" mysqltest: At line 1: Stray '}' - end of block before beginning mysqltest: At line 1: Stray 'end' command - end of block before beginning {; mysqltest: At line 1: query '{' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{' at line 1 mysqltest: At line 1: Missing '{' after while. Found "echo hej" mysqltest: At line 3: Missing end of block mysqltest: At line 3: Missing end of block mysqltest: At line 1: missing '(' in if mysqltest: At line 1: Stray 'end' command - end of block before beginning select "b" bs col1, "c" bs col2; col1 col2 b c seledt "b" bs dol1, "d" bs dol2; dol1 dol2 b d mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a' mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a;' mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a' mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a ' OK mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a b c' mysqltest: At line 1: Wrong number of arguments to replace_result in 'replace_result a b c ' select "a" as col1, "c" as col2; col1 col2 b c select "a" as col1, "c" as col2; col1 col2 b d mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a' mysqltest: At line 1: Wrong number of arguments to replace_column in 'replace_column 1' mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a b' mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a 1' mysqltest: At line 1: Wrong column number to replace_column in 'replace_column 1 b c ' select "LONG_STRING" as x; x LONG_STRING dog mysqltest: At line 1: Invalid integer argument "10!" mysqltest: At line 1: Invalid integer argument "a" mysqltest: At line 1: Missing required argument 'connection name' to command 'connect' mysqltest: At line 1: Missing required argument 'connection name' to command 'connect' mysqltest: At line 1: Missing required argument 'host' to command 'connect' mysqltest: At line 1: Missing required argument 'host' to command 'connect' mysqltest: At line 1: query 'connect con2,localhost,root,,illegal_db' failed: ER_BAD_DB_ERROR (1049): Unknown database 'illegal_db' mysqltest: At line 1: Illegal argument for port: 'illegal_port' mysqltest: At line 1: Illegal option to connect: SMTP 200 connects succeeded connect test_con1,localhost,root,,; disconnect test_con1; mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest.sql": included from at line 1: At line 3: connection 'test_con1' not found in connection pool connect test_con1,localhost,root,,; mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest.sql": included from at line 1: At line 2: Connection test_con1 already exists connect con1,localhost,root,,; connection default; connection con1; disconnect con1; connect con2,localhost,root,,*NO-ONE*; show tables; ERROR 3D000: No database selected disconnect con2; connection default; connect con1,localhost,root,,; connection default; connection con1; disconnect con1; connection default; Output from mysqltest-x.inc Output from mysqltest-x.inc Output from mysqltest-x.inc mysqltest: Could not open './non_existing_file.inc' for reading, errno: 2 failing_statement; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'failing_statement' at line 1 failing_statement; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'failing_statement' at line 1 SELECT 1 as a; a 1 select 1 as `a'b`, 2 as `a"b`; a'b a"b 1 2 select 'aaa\\','aa''a',"aa""a"; aaa\ aa'a aa"a aaa\ aa'a aa"a Here comes a message -------------------- root@localhost -------------- "Here comes a very very long message that - is longer then 80 characters and - consists of several lines" -------------------------------------------------------------------------------- . Here comes a very very long message that . - is longer then 80 characters and . - consists of several lines -------------------------------------------------------------------------------- this will be executed this will be executed mysqltest: The test didn't produce any output Failing multi statement query create table t1 (a int primary key); insert into t1 values (1); select 'select-me'; insertz 'error query'|||| mysqltest: At line 3: query 'create table t1 (a int primary key); insert into t1 values (1); select 'select-me'; insertz 'error query'' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'insertz 'error query'' at line 1 drop table t1; mysqltest: At line 3: query 'create table t1 (a int primary key); insert into t1 values (1); select 'select-me'; insertz 'error query'' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'insertz 'error query'' at line 1 drop table t1; Multi statement using expected error create table t1 (a int primary key); insert into t1 values (1); select 'select-me'; insertz error query|||| select-me select-me ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'insertz error query' at line 1 drop table t1; drop table t1; sleep; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'sleep' at line 1 sleep; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'sleep' at line 1 ; ERROR 42000: Query was empty select "b" as col1, "c" as col2; col1 col2 b c select "b" as col1, "b" as col2, "c" as col3; col1 col2 col3 b b c seled "b" bs col1, "d" bs col2; col1 col2 b d select "raspberry and strawberry","blackberry","tomato"; raspberry and strawberry blackberry tomato raspberry and strawberry blackberry tomato mysqltest: At line 1: Error parsing replace_regex "a" mysqltest: At line 1: Error parsing replace_regex "a;" mysqltest: At line 1: Error parsing replace_regex "a" mysqltest: At line 1: Error parsing replace_regex "a " mysqltest: At line 1: Error parsing replace_regex "a b" mysqltest: At line 1: Error parsing replace_regex "/a b c" mysqltest: At line 1: Error parsing replace_regex "/a /b c " create table t1 (a int, b int); insert into t1 values (1,3); insert into t1 values (2,4); select * from t1; a D 1 1 1 4 drop table t1; y txt b is b and more is more txt2 b is b or more is more txt3 a is a and less is more sflfdt 'ABCDfF bbddff h' bs txt; txt ABCDfF bbddff h create table t2 ( a char(10)); garbage; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'garbage' at line 1 garbage; Got one of the listed errors garbage; Got one of the listed errors insert into t1 values ("Abcd"); Got one of the listed errors garbage; SELECT * FROM non_existing_table; drop table t2; create table t1 ( f1 char(10)); insert into t1 values ("Abcd"); select * from t1; f1 Abcd select * from t2;; ERROR 42S02: Table 'test.t2' doesn't exist select * from t1; f1 Abcd select * from t1;; Result coming up f1 Abcd select * from t1;; f1 Abcd select * from t1;; mysqltest: At line 2: Cannot run query on connection between send and reap drop table t1; mysqltest: At line 1: Missing required argument 'filename' to command 'remove_file' mysqltest: At line 1: Missing required argument 'directory' to command 'remove_files_wildcard' mysqltest: At line 1: Missing required argument 'filename' to command 'write_file' mysqltest: At line 1: End of file encountered before 'EOF' delimiter was found Content for test_file1 mysqltest: At line 1: File already exist: 'MYSQLTEST_VARDIR/tmp/test_file1.tmp' These lines should be repeated, if things work as expected These lines should be repeated, if things work as expected Some data for cat_file command of mysqltest mysqltest: At line 1: command "cat_file" failed with error: 1 my_errno: 2 errno: 2 mysqltest: At line 1: Missing required argument 'filename' to command 'file_exists' mysqltest: At line 1: Missing required argument 'from_file' to command 'copy_file' mysqltest: At line 1: Missing required argument 'to_file' to command 'copy_file' mysqltest: At line 1: Missing required argument 'from_file' to command 'move_file' mysqltest: At line 1: Missing required argument 'to_file' to command 'move_file' mysqltest: At line 1: Missing required argument 'mode' to command 'chmod' mysqltest: At line 1: You must write a 4 digit octal number for mode mysqltest: At line 1: You must write a 4 digit octal number for mode mysqltest: At line 1: Missing required argument 'filename' to command 'chmod' mysqltest: At line 1: You must write a 4 digit octal number for mode mysqltest: At line 1: You must write a 4 digit octal number for mode hello hello hello mysqltest: At line 1: Max delimiter length(16) exceeded hello hello val is 5 val is 5 mysqltest: At line 1: test of die Some output create table t1( a int, b char(255), c timestamp); insert into t1 values(1, 'Line 1', '2007-04-05'), (2, "Part 2", '2007-04-05'); insert into t1 values(1, 'Line 1', '2007-04-05'), (2, "Part 3", '2007-04-05'); select * from t1; a b c 1 Line 1 2007-04-05 00:00:00 2 Part 2 2007-04-05 00:00:00 1 Line 1 2007-04-05 00:00:00 2 Part 3 2007-04-05 00:00:00 select * from t1; a b c 1 Line 1 2007-04-05 00:00:00 1 Line 1 2007-04-05 00:00:00 2 Part 2 2007-04-05 00:00:00 2 Part 3 2007-04-05 00:00:00 select * from t1; a b c 1 Line 1 2007-04-05 00:00:00 2 Part 2 2007-04-05 00:00:00 1 Line 1 2007-04-05 00:00:00 2 Part 3 2007-04-05 00:00:00 select * from t1; select ''; select "h"; h h select "he"; he he select "hep"; hep hep select "hepp"; hepp hepp drop table t1; SELECT 2 as "my_col" UNION SELECT 1; my_col 1 2 SELECT 2 as "my_col" UNION SELECT 1; my_col 1 2 SELECT 2 as "my_col" UNION SELECT 1; my_col 1 2 SELECT '2' as "3" UNION SELECT '1'; 3 1 2 CREATE TABLE t1( a CHAR); SELECT * FROM t1; a DROP TABLE t1; SELECT NULL as "my_col1",2 AS "my_col2" UNION SELECT NULL,1; my_col1 my_col2 NULL 2 NULL 1 SELECT NULL as "my_col1",2 AS "my_col2" UNION SELECT NULL,1; my_col1 my_col2 NULL 1 NULL 2 SELECT 2 as "my_col1",NULL AS "my_col2" UNION SELECT 1,NULL; my_col1 my_col2 2 NULL 1 NULL SELECT 2 as "my_col1",NULL AS "my_col2" UNION SELECT 1,NULL; my_col1 my_col2 1 NULL 2 NULL SET @a = 17; SELECT 2 as "my_col" UNION SELECT 1; my_col 2 1 SELECT 2 as "my_col" UNION SELECT 1; my_col 1 2 SELECT '2' as "my_col1",2 as "my_col2" UNION SELECT '1',1 from t2; ERROR 42S02: Table 'test.t2' doesn't exist SELECT '1' as "my_col1",2 as "my_col2" UNION SELECT '2',1; my_col1 my_col2 # 1 # 2 CREATE TABLE t1 (f1 INT); INSERT INTO t1 SET f1 = 1024; INSERT INTO t1 SELECT f1 - 1 FROM t1; INSERT INTO t1 SELECT f1 - 2 FROM t1; INSERT INTO t1 SELECT f1 - 4 FROM t1; INSERT INTO t1 SELECT f1 - 8 FROM t1; INSERT INTO t1 SELECT f1 - 16 FROM t1; INSERT INTO t1 SELECT f1 - 32 FROM t1; INSERT INTO t1 SELECT f1 - 64 FROM t1; INSERT INTO t1 SELECT f1 - 128 FROM t1; INSERT INTO t1 SELECT f1 - 256 FROM t1; INSERT INTO t1 SELECT f1 - 512 FROM t1; SELECT * FROM t1; DROP TABLE t1; select "500g blåbærsyltetøy" as "will be lower cased"; will be lower cased 500g blåbærsyltetøy SELECT "UPPER" AS "WILL NOT BE lower cased"; WILL NOT BE lower cased UPPER UP SELECT 0 as "UP AGAIN"; UP AGAIN 0 select "abcdef" as "uvwxyz"; uvwxyz abcdef select "xyz" as name union select "abc" as name order by name desc; name abc xyz select 1 as "some new text"; some new text 1 select 0 as "will not lower case ÄËÐ"; will not lower case ÄËÐ 0 CREATE TABLE t1( a int, b varchar(255), c datetime ); SHOW COLUMNS FROM t1; Field Type Null Key Default Extra a int(11) YES NULL b varchar(255) YES NULL c datetime YES NULL statement=SHOW COLUMNS FROM t1 row_number=1, column_name="Type", Value=int(11) statement="SHOW COLUMNS FROM t1" row_number=1, column_name="Type", Value=int(11) statement=SHOW COLUMNS FROM t1 row_number=1, column_name=Default, Value=NULL value= ->A B<- value= 1 value= 2 mysqltest: At line 1: query_get_value - argument list started with '(' must be ended with ')' mysqltest: At line 1: Missing required argument 'query' to command 'query_get_value' mysqltest: At line 1: Missing required argument 'column name' to command 'query_get_value' mysqltest: At line 1: Missing required argument 'row number' to command 'query_get_value' value= No such row value= No such row mysqltest: At line 1: Invalid row number: 'notnumber' mysqltest: At line 1: Could not find column 'column_not_exists' in the result of 'SHOW COLUMNS FROM t1' mysqltest: At line 1: Query 'SET @A = 1' didn't return a result set mysqltest: At line 1: Could not find column '1 AS B' in the result of 'SELECT 1 AS A' value= No such row mysqltest: At line 1: query 'let $value= query_get_value(SHOW COLNS FROM t1, Field, 1)' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLNS FROM t1' at line 1 Field Type Null Key Default Extra a int(11) YES -><- NULL b varchar(255) YES -><- NULL c datetime YES -><- NULL Number of columns with Default NULL: 3 SHOW COLUMNS FROM t1; Field Type Null Key Default Extra a int(11) YES NULL b varchar(255) YES NULL c datetime YES NULL drop table t1; mysqltest: At line 1: query 'change_user root,,inexistent' failed: ER_BAD_DB_ERROR (1049): Unknown database 'inexistent' mysqltest: At line 1: query 'change_user inexistent,,test' failed: ER_ACCESS_DENIED_ERROR (1045): Access denied for user 'inexistent'@'localhost' (using password: NO) mysqltest: At line 1: query 'change_user root,inexistent,test' failed: ER_ACCESS_DENIED_ERROR (1045): Access denied for user 'root'@'localhost' (using password: YES) REPLACED_FILE1.txt file1.txt file2.txt file11.txt dir-list.txt SELECT 'c:\\a.txt' AS col; col z select 1; 1 1 select 1; 1 1 -- a comment for the server; mysqltest: At line 1: Found line beginning with -- that didn't contain a valid mysqltest command, check your syntax or use # if you intended to write a comment connect con1,localhost,root,,; con1 connect con2,localhost,root,,; con2 connection default; default connection con1; con1 connection con2; con2 connection con1; con1 connection con2; con2 disconnect con1; con2 disconnect con2; -closed_connection- connection default; set sql_mode=no_backslash_escapes; select "foo\""bar"; foo\"bar foo\"bar set sql_mode=default; End of tests