~drizzle-trunk/drizzle/development

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 # <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

mysqltest: At line 1: Error running query 'failing query': 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 '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

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

"hello"

"hello"

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' for reading: 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: 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

More results from queries before failure can be found in MYSQLTEST_VARDIR/log/bug11731.log

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

Content for test_file1

mysqltest: At line 1: File already exist: 'MYSQLTEST_VARDIR/tmp/test_file1.tmp'

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 '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

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;

mysqltest: At line 1: change user failed: Unknown database 'inexistent'

mysqltest: At line 1: change user failed: Access denied for user 'inexistent'@'localhost' (using password: NO)

mysqltest: At line 1: change user failed: Access denied for user 'root'@'localhost' (using password: YES)

End of tests