select 0 as "before_use_test" ; before_use_test 0 select otto from (select 1 as otto) as t1; otto 1 select otto from (select 1 as otto) as t1; otto 1 mysqltest: At line 1: query 'select friedrich from (select 1 as otto) as t1' failed: 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 mysqltest: At line 1: query 'select otto from (select 1 as otto) as t1' succeeded - should have failed with sqlstate 42S22... select friedrich from (select 1 as otto) as t1; ERROR 42S22: Unknown column 'friedrich' in 'field list' 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 MySQL server version for the right syntax to use near 'garbage' at line 1 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 MySQL server version for the right syntax to use near 'garbage' at line 1 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 MySQL 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 MySQL server version for the right syntax to use near 'garbage' at line 1 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 MySQL 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 MySQL 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 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 MySQL 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 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 MySQL 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 MySQL 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 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 MySQL 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 MySQL 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 MySQL server version for the right syntax to use near 'garbage' at line 1 execute stmt; ERROR 42S02: Table 'test.t1' doesn't exist 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 MySQL 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 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 MySQL 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 MySQL 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 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 MySQL server version for the right syntax to use near 'garbage' at line 1 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 select 1146 as "after_!errno_masked_error" ; after_!errno_masked_error 1146 mysqltest: At line 1: query 'select 3 from t1' failed with wrong errno 1146: 'Table 'test.t1' doesn't exist', instead of 1000... garbage ; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1 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 mysqltest: At line 1: query 'select 3 from t1' failed with wrong errno 1146: 'Table 'test.t1' doesn't exist', instead of 1064... hello hello ;;;;;;;; # MySQL: -- The mysqltest: At line 1: End of line junk detected: "6" mysqltest: At line 1: End of line junk detected: "6" mysqltest: At line 1: Missing delimiter mysqltest: At line 1: End of line junk detected: "sleep 7 # Another comment " mysqltest: At line 1: Missing delimiter mysqltest: At line 1: Missing delimiter 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: 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 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: command "false" failed 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 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 mysqltest: At line 1: Missing required argument 'filename' to command 'source' mysqltest: At line 1: Could not open file ./non_existingFile mysqltest: In included file "MYSQLTEST_VARDIR/tmp/recursive.sql": At line 1: Source directives are nesting too deep mysqltest: In included file "MYSQLTEST_VARDIR/tmp/error.sql": At line 1: query 'garbage ' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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 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 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 mysqltest: At line 1: Missing argument to sleep mysqltest: At line 1: Missing argument to real_sleep mysqltest: At line 1: Invalid argument to sleep "abc" mysqltest: At line 1: Invalid argument to real_sleep "abc" 1 2 101 hej 1 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: End of line junk detected: "1000" 4 4 -1 -2 99 hej -1 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: End of line junk detected: "1000" mysqltest: At line 1: Missing arguments to system, nothing to do! mysqltest: At line 1: Missing arguments to system, nothing to do! mysqltest: At line 1: system command 'false' failed system command 'NonExistsinfComamdn 2> /dev/null' failed test test2 test3 test4 Counter is greater than 0, (counter=10) Counter is not 0, (counter=0) 1 Testing while with not mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest_while.inc": 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: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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 ' 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: 1049: Unknown database 'illegal_db' mysqltest: At line 1: Illegal argument for port: 'illegal_port' mysqltest: At line 1: Illegal option to connect: SMTP OK mysqltest: The test didn't produce any output mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest.sql": At line 3: connection 'test_con1' not found in connection pool mysqltest: In included file "MYSQLTEST_VARDIR/tmp/mysqltest.sql": At line 2: Connection test_con1 already exists connect(localhost,root,,test,MASTER_PORT,MASTER_SOCKET); show tables; ERROR 3D000: No database selected Output from mysqltest-x.inc Output from mysqltest-x.inc Output from mysqltest-x.inc mysqltest: Could not open ./non_existing_file.inc: errno = 2 failing_statement; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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 MySQL 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: Result length mismatch mysqltest: The test didn't produce any output Failing multi statement 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: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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 MySQL 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 MySQL 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 MySQL 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; mysqltest: At line 1: Missing required argument 'filename' to command 'remove_file' 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 Some data for cat_file command of mysqltest mysqltest: At line 1: Failed to open file non_existing_file 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 '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 'file' 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 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; 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 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: Error running query 'SHOW COLNS FROM t1': 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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; End of tests