← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

Merge Padraig

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
59
59
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
60
60
select * from information_schema.COLLATIONS
61
61
where COLLATION_NAME like 'latin1%';
62
 
COLLATION_NAME  CHARACTER_SET_NAME      ID      IS_DEFAULT      IS_COMPILED     SORTLEN
 
62
COLLATION_NAME  CHARACTER_SET_NAME      DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
63
63
select * from information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
64
64
where COLLATION_NAME like 'latin1%';
65
65
COLLATION_NAME  CHARACTER_SET_NAME
244
244
        )
245
245
AND t.table_name NOT LIKE 'falcon%';
246
246
table_name      column_name
247
 
CHARACTER_SETS  CHARACTER_SET_NAME
248
 
COLLATIONS      COLLATION_NAME
249
 
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
250
247
COLUMNS TABLE_SCHEMA
251
248
GLOBAL_STATUS   VARIABLE_NAME
252
249
GLOBAL_VARIABLES        VARIABLE_NAME
266
263
INNODB_CMP_RESET        page_size
267
264
INNODB_CMPMEM   page_size
268
265
INNODB_CMPMEM_RESET     page_size
 
266
CHARACTER_SETS  CHARACTER_SET_NAME
 
267
COLLATIONS      COLLATION_NAME
 
268
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
269
269
PROCESSLIST     ID
270
270
SELECT t.table_name, c1.column_name
271
271
FROM information_schema.tables t
283
283
        )
284
284
AND t.table_name NOT LIKE 'falcon%';
285
285
table_name      column_name
286
 
CHARACTER_SETS  CHARACTER_SET_NAME
287
 
COLLATIONS      COLLATION_NAME
288
 
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
289
286
COLUMNS TABLE_SCHEMA
290
287
GLOBAL_STATUS   VARIABLE_NAME
291
288
GLOBAL_VARIABLES        VARIABLE_NAME
305
302
INNODB_CMP_RESET        page_size
306
303
INNODB_CMPMEM   page_size
307
304
INNODB_CMPMEM_RESET     page_size
 
305
CHARACTER_SETS  CHARACTER_SET_NAME
 
306
COLLATIONS      COLLATION_NAME
 
307
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
308
308
PROCESSLIST     ID
309
309
SELECT MAX(table_name) FROM information_schema.tables;
310
310
MAX(table_name)
464
464
SELECT info, command, db
465
465
FROM information_schema.processlist
466
466
WHERE id = CONNECTION_ID()      Query   test
 
467
SELECT *
 
468
FROM information_schema.character_sets;
 
469
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
 
470
utf8    utf8_general_ci UTF-8 Unicode   4
 
471
binary  binary          1
 
472
SELECT *
 
473
FROM information_schema.collations;
 
474
COLLATION_NAME  CHARACTER_SET_NAME      DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
 
475
utf8_general_ci utf8    45      0       Yes     1       0
 
476
utf8_bin        utf8    46      0       Yes     1       0
 
477
utf8_unicode_ci utf8    224     0       Yes     8       0
 
478
utf8_icelandic_ci       utf8    225     0       Yes     8       0
 
479
utf8_latvian_ci utf8    226     0       Yes     8       0
 
480
utf8_romanian_ci        utf8    227     0       Yes     8       0
 
481
utf8_slovenian_ci       utf8    228     0       Yes     8       0
 
482
utf8_polish_ci  utf8    229     0       Yes     8       0
 
483
utf8_estonian_ci        utf8    230     0       Yes     8       0
 
484
utf8_spanish_ci utf8    231     0       Yes     8       0
 
485
utf8_swedish_ci utf8    232     0       Yes     8       0
 
486
utf8_turkish_ci utf8    233     0       Yes     8       0
 
487
utf8_czech_ci   utf8    234     0       Yes     8       0
 
488
utf8_danish_ci  utf8    235     0       Yes     8       0
 
489
utf8_lithuanian_ci      utf8    236     0       Yes     8       0
 
490
utf8_slovak_ci  utf8    237     0       Yes     8       0
 
491
utf8_spanish2_ci        utf8    238     0       Yes     8       0
 
492
utf8_roman_ci   utf8    239     0       Yes     8       0
 
493
utf8_persian_ci utf8    240     0       Yes     8       0
 
494
utf8_esperanto_ci       utf8    241     0       Yes     8       0
 
495
utf8_hungarian_ci       utf8    242     0       Yes     8       0
 
496
utf8_sinhala_ci utf8    243     0       Yes     8       0
 
497
binary  binary  63      0       Yes     1       0
 
498
SELECT *
 
499
FROM information_schema.collation_character_set_applicability;
 
500
COLLATION_NAME  CHARACTER_SET_NAME
 
501
utf8_general_ci utf8
 
502
utf8_bin        utf8
 
503
utf8_unicode_ci utf8
 
504
utf8_icelandic_ci       utf8
 
505
utf8_latvian_ci utf8
 
506
utf8_romanian_ci        utf8
 
507
utf8_slovenian_ci       utf8
 
508
utf8_polish_ci  utf8
 
509
utf8_estonian_ci        utf8
 
510
utf8_spanish_ci utf8
 
511
utf8_swedish_ci utf8
 
512
utf8_turkish_ci utf8
 
513
utf8_czech_ci   utf8
 
514
utf8_danish_ci  utf8
 
515
utf8_lithuanian_ci      utf8
 
516
utf8_slovak_ci  utf8
 
517
utf8_spanish2_ci        utf8
 
518
utf8_roman_ci   utf8
 
519
utf8_persian_ci utf8
 
520
utf8_esperanto_ci       utf8
 
521
utf8_hungarian_ci       utf8
 
522
utf8_sinhala_ci utf8
 
523
binary  binary