~jaypipes/drizzle/transaction_log

« back to all changes in this revision

Viewing changes to plugin/show_schema_proto/tests/r/basic.result

• browse files at revision 1206
• compare with another revision
• download diff
• download tarball
• view history from revision 1206

Show diffs side-by-side

added

removed

plugin/show_schema_proto/tests/r/basic.result

 

1

SELECT SHOW_SCHEMA_PROTO('not_exists');

 

2

ERROR 42000: Unknown database 'not_exists'

 

3

CREATE DATABASE foobar COLLATE = utf8_bin;

 

4

SELECT SHOW_SCHEMA_PROTO('foobar');

 

5

SHOW_SCHEMA_PROTO('foobar')

 

6

name: "foobar"

 

7

collation: "utf8_bin"

 

8

 

 

9

DROP DATABASE foobar;

 

10

CREATE DATABASE foobar;

 

11

SELECT SHOW_SCHEMA_PROTO('foobar');

 

12

SHOW_SCHEMA_PROTO('foobar')

 

13

name: "foobar"

 

14

 

 

15

ALTER DATABASE foobar COLLATE = utf8_bin;

 

16

SELECT SHOW_SCHEMA_PROTO('foobar');

 

17

SHOW_SCHEMA_PROTO('foobar')

 

18

name: "foobar"

 

19

collation: "utf8_bin"

 

20

 

 

21

DROP DATABASE foobar;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1