mysql.result 7.31 KB
Newer Older
1 2 3
drop table if exists t1;
create table t1(a int);
insert into t1 values(1);
4
ERROR at line 9: DELIMITER must be followed by a 'delimiter' character or string
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

Test default delimiter ;
a
1

Test delimiter without arg

Test delimiter :
a
1

Test delimiter :
a
1

Test delimiter :;
a
1

Test delimiter //
a
1

Test delimiter MySQL
a
1

Test delimiter delimiter
a
1
35 36 37 38
Tables_in_test
t1
t2
t3
39 40
Tables_in_test
t1
unknown's avatar
unknown committed
41
_
42 43 44
Test delimiter : from command line
a
1
unknown's avatar
unknown committed
45
_
46 47 48
Test delimiter :; from command line
a
1
unknown's avatar
unknown committed
49
_
50 51 52
Test 'go' command(vertical output) G
*************************** 1. row ***************************
a: 1
unknown's avatar
unknown committed
53
_
54 55 56 57
Test  'go' command g
a
1
drop table t1;
58 59 60 61 62 63
create table t1(a int);
lock tables t1 write;
database()
test
unlock tables;
drop table t1;
64 65 66
+----------------------+------------+--------+
| concat('>',col1,'<') | col2       | col3   |
+----------------------+------------+--------+
67 68 69
| >a   <               | b          | 123421 |
| >a   <               | 0123456789 |      4 |
| >abcd<               |            |      4 |
70
+----------------------+------------+--------+
unknown's avatar
unknown committed
71 72 73
+-------------------+
| __tañgè Ñãmé      |
+-------------------+
74
| John Doe          |
unknown's avatar
unknown committed
75 76 77 78
+-------------------+
+-------------------+
| John Doe          |
+-------------------+
79
| __tañgè Ñãmé      |
unknown's avatar
unknown committed
80
+-------------------+
81 82 83
+------+------+---------------------------+
| i    | j    | k                         |
+------+------+---------------------------+
84 85 86 87 88
|    1 | NULL | NULL                      |
| NULL | NULL | <-----------------------> |
| NULL | NULL | <-----                    |
| NULL | NULL | Τη γλώσσα                 |
| NULL | NULL | ᛖᚴ ᚷᛖᛏ                    |
89
+------+------+---------------------------+
90 91 92 93
i	j	k
NULL	1	NULL
Field	Type	Null	Key	Default	Extra
i	int(11)	YES		NULL	
94
j	int(11)	NO		NULL	
95
k	int(11)	YES		NULL	
96 97 98
+------+---+------+
| i    | j | k    |
+------+---+------+
99
| NULL | 1 | NULL |
100 101 102 103
+------+---+------+
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
104 105 106
| i     | int(11) | YES  |     | NULL    |       |
| j     | int(11) | NO   |     | NULL    |       |
| k     | int(11) | YES  |     | NULL    |       |
107
+-------+---------+------+-----+---------+-------+
108 109 110 111
i	s1
1	x
2	NULL
3	
112 113 114
+------+------+
| i    | s1   |
+------+------+
115 116 117
|    1 | x    |
|    2 | NULL |
|    3 |      |
118
+------+------+
119 120 121 122 123
unhex('zz')
NULL
+-------------+
| unhex('zz') |
+-------------+
124
| NULL        |
125
+-------------+
126 127 128 129 130 131 132 133 134 135
create table t1(a int, b varchar(255), c int);
Field	Type	Null	Key	Default	Extra
a	int(11)	YES		NULL	
b	varchar(255)	YES		NULL	
c	int(11)	YES		NULL	
Field	Type	Null	Key	Default	Extra
a	int(11)	YES		NULL	
b	varchar(255)	YES		NULL	
c	int(11)	YES		NULL	
drop table t1;
136 137 138 139 140 141 142 143
1
1
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
ERROR at line 1: USE must be followed by a database name
\
\\
';
';
144 145 146 147 148 149 150 151 152 153 154 155 156
create table t17583 (a int);
insert into t17583 (a) values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
select count(*) from t17583;
count(*)
1280
drop table t17583;
157 158 159 160 161 162 163 164
Test connect without db- or host-name => reconnect
Test connect with dbname only => new dbname, old hostname
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
Test connect with _invalid_ dbname only => new invalid dbname, old hostname
ERROR 1049 (42000) at line 1: Unknown database 'invalid'
ERROR 1049 (42000) at line 1: Unknown database 'invalid'
Test connect with dbname + hostname
Test connect with dbname + _invalid_ hostname
165 166
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
167 168 169
The commands reported in the bug report
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyril has found a bug :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno)
Too long dbname
170
ERROR 1102 (42000) at line 1: Incorrect database name 'test_really_long_dbnamexxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
171 172
Too long hostname
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyrils_superlonghostnameXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno)
173 174 175 176
1
1
ERROR at line 1: DELIMITER cannot contain a backslash character
ERROR at line 1: DELIMITER cannot contain a backslash character
unknown's avatar
unknown committed
177 178
1
1
179 180
1
1
181 182
This is a file starting with UTF8 BOM 0xEFBBBF
This is a file starting with UTF8 BOM 0xEFBBBF
183 184 185 186 187 188
delimiter
1
2
2
2
2
189 190
@z:='1'	@z=database()
1	NULL
191 192 193 194
1
1
1
1
195 196 197 198 199 200
COUNT (*)
1
COUNT (*)
1
COUNT (*)
1
Sergey Glukhov's avatar
Sergey Glukhov committed
201
ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
202
End of 5.0 tests
203
WARNING: --server-arg option not supported in this configuration.
204 205
Warning (Code 1286): Unknown table engine 'nonexistent'
Warning (Code 1266): Using storage engine MyISAM for table 't2'
206
Warning (Code 1286): Unknown table engine 'nonexistent2'
207 208 209
Warning (Code 1266): Using storage engine MyISAM for table 't2'
Error (Code 1050): Table 't2' already exists
drop tables t1, t2;
210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232
<TABLE BORDER=1><TR><TH>&lt;</TH></TR><TR><TD>&lt; &amp; &gt;</TD></TR></TABLE>create table t1 (a char(5));
insert into t1 values ('\0b\0');
a
\0b\0
a
\0b\0
+------+
| a    |
+------+
|  b   |
+------+
*************************** 1. row ***************************
a:  b 
<TABLE BORDER=1><TR><TH>a</TH></TR><TR><TD> b </TD></TR></TABLE><?xml version="1.0"?>

<resultset statement="select a from t1
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <row>
	<field name="a"> b </field>
  </row>
</resultset>
drop table t1;

233 234 235 236 237
Bug #47147: mysql client option --skip-column-names does not apply to vertical output

*************************** 1. row ***************************
1

238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308
#
# Bug #54899: --one-database option cannot handle DROP/CREATE DATABASE 
#             commands.
#
CREATE DATABASE connected_db;
USE connected_db;
SHOW TABLES;
Tables_in_connected_db
table_in_connected_db
DROP DATABASE connected_db;

#
# Testing --one-database option
#
CREATE DATABASE connected_db;
SHOW TABLES IN connected_db;
Tables_in_connected_db
t1
SHOW TABLES IN test;
Tables_in_test
t1
USE test;
DROP TABLE t1;
DROP DATABASE connected_db;

SHOW TABLES IN test;
Tables_in_test
SHOW TABLES IN test1;
Tables_in_test1
DROP DATABASE test1;

#
# Checking --one-database option followed by the execution of 
# connect command.
#
CREATE DATABASE connected_db;
SHOW TABLES IN connected_db;
Tables_in_connected_db
t1
t2
SHOW TABLES IN test;
Tables_in_test
t1
t2
DROP TABLE test.t1;
DROP TABLE test.t2;
DROP DATABASE connected_db;

#
# Checking --one-database option with no database specified
# at command-line.
#
SHOW TABLES IN test;
Tables_in_test

#
# Checking --one-database option with non_existent_db 
# specified with USE command
#
SHOW TABLES IN test;
Tables_in_test
table_in_test
DROP DATABASE test;

CREATE DATABASE test;
SHOW TABLES IN test;
Tables_in_test
table_in_test
DROP DATABASE test;
CREATE DATABASE test;

309
End of tests