← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/mysql.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/mysql.result
235
235
*************************** 1. row ***************************
236
236
1
237
237
 
 
238
#
 
239
# Bug #54899: --one-database option cannot handle DROP/CREATE DATABASE 
 
240
#             commands.
 
241
#
 
242
CREATE DATABASE connected_db;
 
243
USE connected_db;
 
244
SHOW TABLES;
 
245
Tables_in_connected_db
 
246
table_in_connected_db
 
247
DROP DATABASE connected_db;
 
248
 
 
249
#
 
250
# Testing --one-database option
 
251
#
 
252
CREATE DATABASE connected_db;
 
253
SHOW TABLES IN connected_db;
 
254
Tables_in_connected_db
 
255
t1
 
256
SHOW TABLES IN test;
 
257
Tables_in_test
 
258
t1
 
259
USE test;
 
260
DROP TABLE t1;
 
261
DROP DATABASE connected_db;
 
262
 
 
263
SHOW TABLES IN test;
 
264
Tables_in_test
 
265
SHOW TABLES IN test1;
 
266
Tables_in_test1
 
267
DROP DATABASE test1;
 
268
 
 
269
#
 
270
# Checking --one-database option followed by the execution of 
 
271
# connect command.
 
272
#
 
273
CREATE DATABASE connected_db;
 
274
SHOW TABLES IN connected_db;
 
275
Tables_in_connected_db
 
276
t1
 
277
t2
 
278
SHOW TABLES IN test;
 
279
Tables_in_test
 
280
t1
 
281
t2
 
282
DROP TABLE test.t1;
 
283
DROP TABLE test.t2;
 
284
DROP DATABASE connected_db;
 
285
 
 
286
#
 
287
# Checking --one-database option with no database specified
 
288
# at command-line.
 
289
#
 
290
SHOW TABLES IN test;
 
291
Tables_in_test
 
292
 
 
293
#
 
294
# Checking --one-database option with non_existent_db 
 
295
# specified with USE command
 
296
#
 
297
CREATE DATABASE connected_db;
 
298
SHOW TABLES IN connected_db;
 
299
Tables_in_connected_db
 
300
table_in_connected_db
 
301
 
 
302
SHOW TABLES IN connected_db;
 
303
Tables_in_connected_db
 
304
table_in_connected_db
 
305
DROP DATABASE connected_db;
 
306
 
238
307
End of tests