1
drop table if exists t1;
2
create table t1(a int);
3
insert into t1 values(1);
4
ERROR at line 9: DELIMITER must be followed by a 'delimiter' character or string
6
Test default delimiter ;
10
Test delimiter without arg
32
Test delimiter delimiter
42
Test delimiter : from command line
46
Test delimiter :; from command line
50
Test 'go' command(vertical output) G
51
*************************** 1. row ***************************
58
create table t1(a int);
64
+----------------------+------------+--------+
65
| concat('>',col1,'<') | col2 | col3 |
66
+----------------------+------------+--------+
68
| >a < | 0123456789 | 4 |
70
+----------------------+------------+--------+
81
+------+------+---------------------------+
83
+------+------+---------------------------+
85
| NULL | NULL | <-----------------------> |
86
| NULL | NULL | <----- |
87
| NULL | NULL | Τη γλώσσα |
88
| NULL | NULL | ᛖᚴ ᚷᛖᛏ |
89
+------+------+---------------------------+
92
Field Type Null Key Default Extra
101
+-------+---------+------+-----+---------+-------+
102
| Field | Type | Null | Key | Default | Extra |
103
+-------+---------+------+-----+---------+-------+
104
| i | int(11) | YES | | NULL | |
105
| j | int(11) | NO | | NULL | |
106
| k | int(11) | YES | | NULL | |
107
+-------+---------+------+-----+---------+-------+
126
create table t1(a int, b varchar(255), c int);
127
Field Type Null Key Default Extra
129
b varchar(255) YES NULL
131
Field Type Null Key Default Extra
133
b varchar(255) YES NULL
138
ERROR 1064 (42000) at line 3: 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
139
ERROR at line 1: USE must be followed by a database name
144
create table t17583 (a int);
145
insert into t17583 (a) values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
146
insert into t17583 select a from t17583;
147
insert into t17583 select a from t17583;
148
insert into t17583 select a from t17583;
149
insert into t17583 select a from t17583;
150
insert into t17583 select a from t17583;
151
insert into t17583 select a from t17583;
152
insert into t17583 select a from t17583;
153
select count(*) from t17583;
157
Test connect without db- or host-name => reconnect
158
Test connect with dbname only => new dbname, old hostname
159
ERROR 1064 (42000) at line 1: 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 'connecttest' at line 1
160
Test connect with _invalid_ dbname only => new invalid dbname, old hostname
161
ERROR 1049 (42000) at line 1: Unknown database 'invalid'
162
ERROR 1049 (42000) at line 1: Unknown database 'invalid'
163
Test connect with dbname + hostname
164
Test connect with dbname + _invalid_ hostname
165
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
166
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
167
The commands reported in the bug report
168
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyril has found a bug :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno)
170
ERROR 1102 (42000) at line 1: Incorrect database name 'test_really_long_dbnamexxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
172
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyrils_superlonghostnameXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno)
175
ERROR at line 1: DELIMITER cannot contain a backslash character
176
ERROR at line 1: DELIMITER cannot contain a backslash character
181
This is a file starting with UTF8 BOM 0xEFBBBF
182
This is a file starting with UTF8 BOM 0xEFBBBF
189
@z:='1' @z=database()
201
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
203
WARNING: --server-arg option not supported in this configuration.
204
Warning (Code 1286): Unknown table engine 'nonexistent'
205
Warning (Code 1266): Using storage engine MyISAM for table 't2'
206
Warning (Code 1286): Unknown table engine 'nonexistent2'
207
Warning (Code 1266): Using storage engine MyISAM for table 't2'
208
Error (Code 1050): Table 't2' already exists
210
<TABLE BORDER=1><TR><TH><</TH></TR><TR><TD>< & ></TD></TR></TABLE>create table t1 (a char(5));
211
insert into t1 values ('\0b\0');
221
*************************** 1. row ***************************
223
<TABLE BORDER=1><TR><TH>a</TH></TR><TR><TD> b </TD></TR></TABLE><?xml version="1.0"?>
225
<resultset statement="select a from t1
226
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
228
<field name="a"> b </field>
233
Bug #47147: mysql client option --skip-column-names does not apply to vertical output
235
*************************** 1. row ***************************
239
# Bug #54899: --one-database option cannot handle DROP/CREATE DATABASE
242
CREATE DATABASE connected_db;
245
Tables_in_connected_db
246
table_in_connected_db
247
DROP DATABASE connected_db;
250
# Testing --one-database option
252
CREATE DATABASE connected_db;
253
SHOW TABLES IN connected_db;
254
Tables_in_connected_db
261
DROP DATABASE connected_db;
265
SHOW TABLES IN test1;
270
# Checking --one-database option followed by the execution of
273
CREATE DATABASE connected_db;
274
SHOW TABLES IN connected_db;
275
Tables_in_connected_db
284
DROP DATABASE connected_db;
287
# Checking --one-database option with no database specified
294
# Checking --one-database option with non_existent_db
295
# specified with USE command
297
CREATE DATABASE connected_db;
298
SHOW TABLES IN connected_db;
299
Tables_in_connected_db
300
table_in_connected_db
302
SHOW TABLES IN connected_db;
303
Tables_in_connected_db
304
table_in_connected_db
305
DROP DATABASE connected_db;