2008-02-29 Matthias Leich
=========================
1. The testsuite "funcs_1" is mostly intended for additional (compared
to the common regression tests stored in mysql-test/t) checks
of features (VIEWS, INFORMATION_SCHEMA, STORED PROCEDURES,...)
introduced with MySQL 5.0.
2. There were some extensions of this suite when new information_schema
views were introduced. But in most cases the tests for these views
were stored within the regression testsuite (mysql-test/t).
INFORMATION_SCHEMA views introduced with MySQL 5.1
==================================================
ENGINES (partially tested here)
EVENTS (partially tested here)
FILES
GLOBAL_STATUS
GLOBAL_VARIABLES
PARTITIONS
PLUGINS
PROCESSLIST (full tested here)
PROFILING
REFERENTIAL_CONSTRAINTS
SESSION_STATUS
SESSION_VARIABLES
3. Some hints for maintainers of this suite:
- SHOW TABLES ... LIKE '<pattern>'
does a case sensitive comparison between the tablename and
the pattern.
The names of the tables within the informationschema are in uppercase.
So please use something like
SHOW TABLES FOR information_schema LIKE 'TABLES'
when you intend to get the same non empty result set on OS with and
without case sensitive filesystems and default configuration.
- The name of the data dictionary is 'information_schema' (lowercase).
- Server on OS with filesystem with case sensitive filenames
(= The files 'abc' and 'Abc' can coexist.)
+ default configuration
Example of behaviour:
DROP DATABASE information_schema;
ERROR 42000: Access denied for user ... to database 'information_schema'
DROP DATABASE INFORMATION_SCHEMA;
ERROR 42000: Access denied for user ... to database 'INFORMATION_SCHEMA'
- Try to unify results by
--replace_result $engine_type <engine_to_be_tested>
if we could expect that the results for storage engine variants of a
test differ only in the engine names.
This makes future maintenance easier.
- Avoid the use of include/show_msg*.inc.
They produce "SQL" noise which annoys during server debugging and can be
easy replaced by "--echo ...".
mysql-5.6.14+mysql-5.6.17-winx64_免安装+SQLyog_Enterprise （9689个子文件） 
binlog_old_version_4_1.000001 146KB bug33029-slave-relay-bin.000001 4KB binlog_transaction.000001 2KB binlog_savepoint.000001 1014B bug16266.000001 532B trunc_binlog.000001 174B bug40482-bin.000001 172B master-bin.000001 98B bug11747887-bin.000003 729B corrupt-relay-bin.000624 89KB ver_trunk_row_v2.001 148KB ver_5_1_23.001 147KB ver_5_1-telco.001 147KB ver_5_1_17.001 147KB ver_5_1-wl2325_s.001 146KB ver_5_1-wl2325_r.001 705B bug32407.001 368B bug47012.ARM 19B bug48633.ARM 19B bug46565.ARZ 8KB bug48633.ARZ 157B bug47012.ARZ 22B default.weekly.basic 8KB example.bat 294B uname.bat 15B pwd.bat 14B README.bhs 839B update-full-row.binlog 614B update-partial-row.binlog 606B write-partial-row.binlog 596B write-full-row.binlog 571B mysql-4.0.cfg 291KB mysql-4.1.cfg 279KB mysql.cfg 54KB mysql-3.23.cfg 24KB ms-sql.cfg 24KB pg.cfg 23KB db2.cfg 23KB frontbase.cfg 23KB interbase-superserver.cfg 23KB interbase-dialect1.cfg 23KB interbase-dialect3.cfg 23KB oracle.cfg 23KB access.cfg 22KB mimer.cfg 22KB interbase.cfg 21KB access_odbc.cfg 20KB mysql-3.22.cfg 20KB Adabas.cfg 19KB solid.cfg 18KB solid-nt4.cfg 18KB sybase.cfg 18KB Informix.cfg 18KB ms-sql65.cfg 18KB empress.cfg 16KB msql.cfg 10KB ChangeLog 55KB README.checksum 738B ddl.cln 113B default_mysqld.cnf 4KB default_mysqld_autosize.cnf 2KB my.cnf 2KB my.cnf 2KB rpl_1slave_base.cnf 2KB sizing_high.cnf 2KB ndb_rpl_multi_binlog_update.cnf 2KB ndb_rpl_break_3_chain.cnf 2KB my.cnf 2KB sizing_default.cnf 1KB rpl_ipv4_as_ipv6.cnf 1KB rpl_ip_mix2.cnf 1KB rpl_ip_mix.cnf 1KB rpl_ipv6.cnf 1KB sizing_off.cnf 1KB rpl_1slave_base.cnf 1KB default_my.cnf 1KB sizing_med.cnf 1KB sizing_low.cnf 1KB my.cnf 1KB ndb_add_node.cnf 1000B ndb_binlog_variants.cnf 999B default_ndbd.cnf 997B rpl_gtid_stress_failover.cnf 972B rpl_test_framework.cnf 913B ndb_rpl_circular_2ch.cnf 878B my.cnf 828B my.cnf 664B ndb_addnode.cnf 664B ndb_share.cnf 652B ndb_config_mycnf2.cnf 641B ndb_config_mycnf1.cnf 597B ndb_rpl_conflict_epoch.cnf 561B ndb_add_node_mysqld.cnf 550B rpl_row_img.cnf 370B default_client.cnf 367B ndb_blob_big.cnf 353B my.cnf 348B rpl_gtid_failover.cnf 320B rpl_circular_for_4_hosts.cnf 311B cnf_option.cnf 273B共 9689 条
- 1
- 2
- 3
- 4
- 5
- 6
- 97
资源评论
