← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

Added code necessary for building plugins dynamically.
Merged in changes from lifeless to allow autoreconf to work.
Touching plugin.ini files now triggers a rebuid - so config/autorun.sh is no
longer required to be run after touching those.
Removed the duplicate plugin names - also removed the issue that getting them
different would silently fail weirdly later.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
125
125
table_name NOT LIKE 'MEMCACHED%'
126
126
GROUP BY TABLE_SCHEMA;
127
127
table_schema    count(*)
128
 
information_schema      23
 
128
information_schema      24
129
129
show create database information_schema;
130
130
Database        Create Database
131
131
information_schema      CREATE DATABASE `information_schema`
213
213
 or column_type = 'varchar(27)')
214
214
group by column_type order by num;
215
215
column_type     group_concat(table_schema, '.', table_name)     num
216
 
varchar(20)     information_schema.PLUGINS      1
 
216
varchar(20)     information_schema.MODULES      1
217
217
varchar(27)     information_schema.COLUMNS      1
218
218
create table t1(f1 char(1) not null, f2 char(9) not null);
219
219
select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from
248
248
AND t.table_name NOT LIKE 'falcon%'
249
249
  AND t.table_name NOT LIKE 'MEMCACHED%';
250
250
table_name      column_name
251
 
INNODB_TRX      trx_id
252
 
INNODB_LOCKS    lock_id
253
 
INNODB_LOCK_WAITS       requesting_trx_id
254
 
INNODB_CMP      page_size
255
 
INNODB_CMP_RESET        page_size
256
 
INNODB_CMPMEM   page_size
257
 
INNODB_CMPMEM_RESET     page_size
258
251
CHARACTER_SETS  CHARACTER_SET_NAME
259
252
COLLATIONS      COLLATION_NAME
260
253
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
261
254
COLUMNS TABLE_SCHEMA
262
 
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
263
255
GLOBAL_STATUS   VARIABLE_NAME
264
256
GLOBAL_VARIABLES        VARIABLE_NAME
 
257
INNODB_CMP      page_size
 
258
INNODB_CMPMEM   page_size
 
259
INNODB_CMPMEM_RESET     page_size
 
260
INNODB_CMP_RESET        page_size
 
261
INNODB_LOCKS    lock_id
 
262
INNODB_LOCK_WAITS       requesting_trx_id
 
263
INNODB_TRX      trx_id
 
264
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
265
MODULES MODULE_NAME
265
266
PLUGINS PLUGIN_NAME
266
267
PROCESSLIST     ID
267
268
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
269
270
SESSION_STATUS  VARIABLE_NAME
270
271
SESSION_VARIABLES       VARIABLE_NAME
271
272
STATISTICS      TABLE_SCHEMA
 
273
TABLES  TABLE_SCHEMA
272
274
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
273
 
TABLES  TABLE_SCHEMA
274
275
SELECT t.table_name, c1.column_name
275
276
FROM information_schema.tables t
276
277
INNER JOIN
288
289
AND t.table_name NOT LIKE 'falcon%'
289
290
  AND t.table_name NOT LIKE 'MEMCACHED%';
290
291
table_name      column_name
291
 
INNODB_TRX      trx_id
292
 
INNODB_LOCKS    lock_id
293
 
INNODB_LOCK_WAITS       requesting_trx_id
294
 
INNODB_CMP      page_size
295
 
INNODB_CMP_RESET        page_size
296
 
INNODB_CMPMEM   page_size
297
 
INNODB_CMPMEM_RESET     page_size
298
292
CHARACTER_SETS  CHARACTER_SET_NAME
299
293
COLLATIONS      COLLATION_NAME
300
294
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
301
295
COLUMNS TABLE_SCHEMA
302
 
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
303
296
GLOBAL_STATUS   VARIABLE_NAME
304
297
GLOBAL_VARIABLES        VARIABLE_NAME
 
298
INNODB_CMP      page_size
 
299
INNODB_CMPMEM   page_size
 
300
INNODB_CMPMEM_RESET     page_size
 
301
INNODB_CMP_RESET        page_size
 
302
INNODB_LOCKS    lock_id
 
303
INNODB_LOCK_WAITS       requesting_trx_id
 
304
INNODB_TRX      trx_id
 
305
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
306
MODULES MODULE_NAME
305
307
PLUGINS PLUGIN_NAME
306
308
PROCESSLIST     ID
307
309
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
309
311
SESSION_STATUS  VARIABLE_NAME
310
312
SESSION_VARIABLES       VARIABLE_NAME
311
313
STATISTICS      TABLE_SCHEMA
 
314
TABLES  TABLE_SCHEMA
312
315
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
313
 
TABLES  TABLE_SCHEMA
314
316
SELECT MAX(table_name) FROM information_schema.tables;
315
317
MAX(table_name)
316
318
TABLE_CONSTRAINTS
366
368
INNODB_LOCK_WAITS       information_schema.INNODB_LOCK_WAITS    1
367
369
INNODB_TRX      information_schema.INNODB_TRX   1
368
370
KEY_COLUMN_USAGE        information_schema.KEY_COLUMN_USAGE     1
 
371
MODULES information_schema.MODULES      1
369
372
PLUGINS information_schema.PLUGINS      1
370
373
PROCESSLIST     information_schema.PROCESSLIST  1
371
374
REFERENTIAL_CONSTRAINTS information_schema.REFERENTIAL_CONSTRAINTS      1
535
538
WHERE table_name NOT LIKE 'MEMCACHED%'
536
539
ORDER BY table_name;
537
540
table_name      column_name
 
541
CHARACTER_SETS  CHARACTER_SET_NAME
 
542
CHARACTER_SETS  DEFAULT_COLLATE_NAME
 
543
CHARACTER_SETS  DESCRIPTION
538
544
CHARACTER_SETS  MAXLEN
539
 
CHARACTER_SETS  DESCRIPTION
540
 
CHARACTER_SETS  DEFAULT_COLLATE_NAME
541
 
CHARACTER_SETS  CHARACTER_SET_NAME
 
545
COLLATIONS      SORTLEN
542
546
COLLATIONS      IS_COMPILED
543
 
COLLATIONS      COLLATION_NAME
544
 
COLLATIONS      SORTLEN
545
547
COLLATIONS      IS_DEFAULT
546
548
COLLATIONS      ID
547
549
COLLATIONS      DESCRIPTION
548
550
COLLATIONS      CHARACTER_SET_NAME
 
551
COLLATIONS      COLLATION_NAME
549
552
COLLATION_CHARACTER_SET_APPLICABILITY   CHARACTER_SET_NAME
550
553
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
551
 
COLUMNS PRIVILEGES
552
 
COLUMNS TABLE_SCHEMA
553
 
COLUMNS TABLE_NAME
554
 
COLUMNS TABLE_CATALOG
555
 
COLUMNS COLUMN_NAME
556
 
COLUMNS ORDINAL_POSITION
557
 
COLUMNS COLUMN_DEFAULT
558
 
COLUMNS IS_NULLABLE
559
 
COLUMNS FORMAT
 
554
COLUMNS CHARACTER_SET_NAME
560
555
COLUMNS COLLATION_NAME
561
 
COLUMNS CHARACTER_SET_NAME
562
 
COLUMNS COLUMN_COMMENT
563
556
COLUMNS COLUMN_TYPE
564
557
COLUMNS COLUMN_KEY
565
558
COLUMNS EXTRA
 
559
COLUMNS PRIVILEGES
 
560
COLUMNS COLUMN_COMMENT
566
561
COLUMNS STORAGE
 
562
COLUMNS FORMAT
567
563
COLUMNS NUMERIC_SCALE
568
564
COLUMNS NUMERIC_PRECISION
569
565
COLUMNS CHARACTER_OCTET_LENGTH
 
566
COLUMNS TABLE_CATALOG
 
567
COLUMNS TABLE_SCHEMA
 
568
COLUMNS TABLE_NAME
 
569
COLUMNS COLUMN_NAME
 
570
COLUMNS ORDINAL_POSITION
 
571
COLUMNS COLUMN_DEFAULT
 
572
COLUMNS IS_NULLABLE
570
573
COLUMNS DATA_TYPE
571
574
COLUMNS CHARACTER_MAXIMUM_LENGTH
572
 
GLOBAL_STATUS   VARIABLE_NAME
573
575
GLOBAL_STATUS   VARIABLE_VALUE
 
576
GLOBAL_STATUS   VARIABLE_NAME
 
577
GLOBAL_VARIABLES        VARIABLE_NAME
574
578
GLOBAL_VARIABLES        VARIABLE_VALUE
575
 
GLOBAL_VARIABLES        VARIABLE_NAME
 
579
INNODB_CMP      uncompress_time
 
580
INNODB_CMP      uncompress_ops
576
581
INNODB_CMP      compress_time
577
 
INNODB_CMP      uncompress_ops
 
582
INNODB_CMP      compress_ops_ok
578
583
INNODB_CMP      compress_ops
579
584
INNODB_CMP      page_size
580
 
INNODB_CMP      uncompress_time
581
 
INNODB_CMP      compress_ops_ok
582
585
INNODB_CMPMEM   relocation_time
583
586
INNODB_CMPMEM   relocation_ops
 
587
INNODB_CMPMEM   pages_free
584
588
INNODB_CMPMEM   pages_used
585
589
INNODB_CMPMEM   page_size
586
 
INNODB_CMPMEM   pages_free
587
590
INNODB_CMPMEM_RESET     relocation_time
588
591
INNODB_CMPMEM_RESET     relocation_ops
589
592
INNODB_CMPMEM_RESET     pages_free
590
593
INNODB_CMPMEM_RESET     pages_used
591
594
INNODB_CMPMEM_RESET     page_size
592
 
INNODB_CMP_RESET        page_size
 
595
INNODB_CMP_RESET        uncompress_time
 
596
INNODB_CMP_RESET        uncompress_ops
 
597
INNODB_CMP_RESET        compress_time
 
598
INNODB_CMP_RESET        compress_ops_ok
593
599
INNODB_CMP_RESET        compress_ops
594
 
INNODB_CMP_RESET        compress_ops_ok
595
 
INNODB_CMP_RESET        compress_time
596
 
INNODB_CMP_RESET        uncompress_ops
597
 
INNODB_CMP_RESET        uncompress_time
 
600
INNODB_CMP_RESET        page_size
 
601
INNODB_LOCKS    lock_data
 
602
INNODB_LOCKS    lock_rec
 
603
INNODB_LOCKS    lock_page
 
604
INNODB_LOCKS    lock_space
598
605
INNODB_LOCKS    lock_index
599
606
INNODB_LOCKS    lock_table
600
607
INNODB_LOCKS    lock_type
 
608
INNODB_LOCKS    lock_mode
601
609
INNODB_LOCKS    lock_trx_id
602
610
INNODB_LOCKS    lock_id
603
 
INNODB_LOCKS    lock_mode
604
 
INNODB_LOCKS    lock_space
605
 
INNODB_LOCKS    lock_page
606
 
INNODB_LOCKS    lock_rec
607
 
INNODB_LOCKS    lock_data
608
611
INNODB_LOCK_WAITS       blocking_lock_id
609
612
INNODB_LOCK_WAITS       blocking_trx_id
610
613
INNODB_LOCK_WAITS       requested_lock_id
611
614
INNODB_LOCK_WAITS       requesting_trx_id
612
 
INNODB_TRX      trx_id
 
615
INNODB_TRX      trx_query
 
616
INNODB_TRX      trx_mysql_thread_id
 
617
INNODB_TRX      trx_weight
 
618
INNODB_TRX      trx_wait_started
 
619
INNODB_TRX      trx_requested_lock_id
 
620
INNODB_TRX      trx_started
613
621
INNODB_TRX      trx_state
614
 
INNODB_TRX      trx_started
615
 
INNODB_TRX      trx_requested_lock_id
616
 
INNODB_TRX      trx_wait_started
617
 
INNODB_TRX      trx_weight
618
 
INNODB_TRX      trx_mysql_thread_id
619
 
INNODB_TRX      trx_query
 
622
INNODB_TRX      trx_id
 
623
KEY_COLUMN_USAGE        ORDINAL_POSITION
 
624
KEY_COLUMN_USAGE        POSITION_IN_UNIQUE_CONSTRAINT
 
625
KEY_COLUMN_USAGE        REFERENCED_TABLE_SCHEMA
 
626
KEY_COLUMN_USAGE        REFERENCED_TABLE_NAME
620
627
KEY_COLUMN_USAGE        REFERENCED_COLUMN_NAME
621
 
KEY_COLUMN_USAGE        REFERENCED_TABLE_NAME
622
 
KEY_COLUMN_USAGE        REFERENCED_TABLE_SCHEMA
623
 
KEY_COLUMN_USAGE        POSITION_IN_UNIQUE_CONSTRAINT
624
 
KEY_COLUMN_USAGE        ORDINAL_POSITION
 
628
KEY_COLUMN_USAGE        COLUMN_NAME
 
629
KEY_COLUMN_USAGE        TABLE_NAME
 
630
KEY_COLUMN_USAGE        TABLE_SCHEMA
 
631
KEY_COLUMN_USAGE        TABLE_CATALOG
 
632
KEY_COLUMN_USAGE        CONSTRAINT_NAME
 
633
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
625
634
KEY_COLUMN_USAGE        CONSTRAINT_CATALOG
626
 
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
627
 
KEY_COLUMN_USAGE        CONSTRAINT_NAME
628
 
KEY_COLUMN_USAGE        TABLE_CATALOG
629
 
KEY_COLUMN_USAGE        TABLE_SCHEMA
630
 
KEY_COLUMN_USAGE        TABLE_NAME
631
 
KEY_COLUMN_USAGE        COLUMN_NAME
632
 
PLUGINS PLUGIN_LICENSE
633
 
PLUGINS PLUGIN_DESCRIPTION
634
 
PLUGINS PLUGIN_AUTHOR
635
 
PLUGINS PLUGIN_STATUS
636
 
PLUGINS PLUGIN_VERSION
 
635
MODULES MODULE_LICENSE
 
636
MODULES MODULE_DESCRIPTION
 
637
MODULES MODULE_LIBRARY
 
638
MODULES IS_BUILTIN
 
639
MODULES MODULE_AUTHOR
 
640
MODULES MODULE_VERSION
 
641
MODULES MODULE_NAME
 
642
PLUGINS MODULE_NAME
 
643
PLUGINS IS_ACTIVE
 
644
PLUGINS PLUGIN_TYPE
637
645
PLUGINS PLUGIN_NAME
638
646
PROCESSLIST     INFO
639
647
PROCESSLIST     STATE
659
667
SCHEMATA        DEFAULT_CHARACTER_SET_NAME
660
668
SCHEMATA        SCHEMA_NAME
661
669
SCHEMATA        CATALOG_NAME
 
670
SESSION_STATUS  VARIABLE_NAME
662
671
SESSION_STATUS  VARIABLE_VALUE
663
 
SESSION_STATUS  VARIABLE_NAME
664
 
SESSION_VARIABLES       VARIABLE_NAME
665
672
SESSION_VARIABLES       VARIABLE_VALUE
 
673
SESSION_VARIABLES       VARIABLE_NAME
 
674
STATISTICS      INDEX_COMMENT
 
675
STATISTICS      COMMENT
 
676
STATISTICS      INDEX_TYPE
 
677
STATISTICS      NULLABLE
 
678
STATISTICS      PACKED
 
679
STATISTICS      SUB_PART
666
680
STATISTICS      CARDINALITY
667
 
STATISTICS      SUB_PART
668
 
STATISTICS      PACKED
669
 
STATISTICS      NULLABLE
670
 
STATISTICS      INDEX_TYPE
671
 
STATISTICS      COMMENT
672
 
STATISTICS      INDEX_COMMENT
673
681
STATISTICS      COLLATION
674
682
STATISTICS      COLUMN_NAME
675
683
STATISTICS      TABLE_CATALOG
679
687
STATISTICS      INDEX_SCHEMA
680
688
STATISTICS      INDEX_NAME
681
689
STATISTICS      SEQ_IN_INDEX
682
 
TABLES  AVG_ROW_LENGTH
683
 
TABLES  DATA_LENGTH
684
 
TABLES  MAX_DATA_LENGTH
685
 
TABLES  INDEX_LENGTH
686
690
TABLES  DATA_FREE
687
691
TABLES  AUTO_INCREMENT
688
692
TABLES  CREATE_TIME
691
695
TABLES  TABLE_COLLATION
692
696
TABLES  CHECKSUM
693
697
TABLES  CREATE_OPTIONS
694
 
TABLES  TABLE_ROWS
695
 
TABLES  ROW_FORMAT
696
698
TABLES  TABLE_COMMENT
 
699
TABLES  INDEX_LENGTH
 
700
TABLES  MAX_DATA_LENGTH
 
701
TABLES  DATA_LENGTH
697
702
TABLES  TABLE_CATALOG
698
703
TABLES  TABLE_SCHEMA
699
704
TABLES  TABLE_NAME
700
705
TABLES  TABLE_TYPE
701
706
TABLES  ENGINE
702
707
TABLES  VERSION
 
708
TABLES  ROW_FORMAT
 
709
TABLES  TABLE_ROWS
 
710
TABLES  AVG_ROW_LENGTH
703
711
TABLE_CONSTRAINTS       TABLE_NAME
704
712
TABLE_CONSTRAINTS       TABLE_SCHEMA
705
713
TABLE_CONSTRAINTS       CONSTRAINT_NAME
1063
1071
information_schema      INNODB_LOCK_WAITS
1064
1072
information_schema      INNODB_TRX
1065
1073
information_schema      KEY_COLUMN_USAGE
 
1074
information_schema      MODULES
1066
1075
information_schema      PLUGINS
1067
1076
information_schema      PROCESSLIST
1068
1077
information_schema      REFERENTIAL_CONSTRAINTS