Create 'main' test directory and move 't' and 'r' there

1 files changed, 0 insertions, 992 deletions

diff --git a/mysql-test/r/mysqltest.result b/mysql-test/r/mysqltest.result
deleted file mode 100644
index fe269152357..00000000000
--- a/mysql-test/r/mysqltest.result
+++ /dev/null
@@ -1,992 +0,0 @@
--1 before test
-<No error> 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: 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 1146: 'Table 'test.t1' doesn't exist', instead of 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 1146: 'Table 'test.t1' doesn't exist', instead of 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 # <whatever> success: $success
-# <whatever> success: 1
-# Execute: echo # <whatever> success: $success ;
-# <whatever> 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: 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 <stdin> at line 1:
-At line 1: Source directives are nesting too deep
-garbage ;
-mysqltest: In included file "MYSQLTEST_VARDIR/tmp/error.sql": 
-included from <stdin> at line 1:
-At line 1: query 'garbage ' failed: 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 beging 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 <stdin> 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: 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: 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 <stdin> 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 <stdin> 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: 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: 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: 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: 1049: Unknown database 'inexistent'
-mysqltest: At line 1: query 'change_user inexistent,,test' failed: 1045: Access denied for user 'inexistent'@'localhost' (using password: NO)
-mysqltest: At line 1: query 'change_user root,inexistent,test' failed: 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