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 ...".
没有合适的资源?快使用搜索试试~ 我知道了~
MySQL5.1官方下载
共2000个文件
test:1358个
result:1292个
inc:387个
需积分: 26 100 下载量 106 浏览量
2019-03-27
14:00:38
上传
评论 2
收藏 139.02MB ZIP 举报
温馨提示
MySQL(发音为"my ess cue el",不是"my sequel")是一种开放源代码的关系型数据库管理系统(RDBMS),MySQL数据库系统使用最常用的数据库管理语言--结构化查询语言(SQL)进行数据库管理。 好好学习,天天向上
资源推荐
资源详情
资源评论
收起资源包目录
MySQL5.1官方下载 (2000个子文件)
binlog_old_version_4_1.000001 146KB
bug33029-slave-relay-bin.000001 4KB
binlog_transaction.000001 2KB
bug16266.000001 532B
trunc_binlog.000001 174B
bug40482-bin.000001 172B
master-bin.000001 98B
corrupt-relay-bin.000624 89KB
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
ToadCommon.dll_uest.Toad.DataReport.FormattingExtension.zh-CN.aeh 14KB
ToadDataCompareAndSync.dll_ataCompareAndSync.Plugin.MigrationImages.zh-CN.aeh 3KB
Makefile.am 2KB
Makefile.am 998B
bug47012.ARM 19B
bug47012.ARZ 22B
ngenUninstall.bat 149B
ToadWithProfiling.bat 22B
postgres.benchmark 3KB
FrontBase.benchmark 1KB
mysql.benchmark 1KB
update-full-row.binlog 614B
update-partial-row.binlog 606B
write-partial-row.binlog 596B
write-full-row.binlog 571B
schemaUsers.bmp 644B
safe_process_win.cc 11KB
safe_process.cc 7KB
safe_kill_win.cc 3KB
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 2KB
Toad.chm 1.14MB
MySQL-Front.chm 117KB
TSOptions.chm 106KB
CompNSync.chm 81KB
TS10.chm 78KB
JobScheduler.chm 54KB
ddl.cln 113B
cmake_install.cmake 1KB
startup.cmd 438B
shutdown.cmd 312B
client.cmd 299B
setEnv.cmd 106B
my.cnf 2KB
rpl_1slave_base.cnf 1KB
default_ndbd.cnf 836B
ndb_config_mycnf2.cnf 641B
default_my.cnf 597B
default_mysqld.cnf 527B
rpl_ndb_circular_2ch.cnf 515B
my.cnf 492B
my.cnf 475B
my.cnf 312B
rpl_circular_for_4_hosts.cnf 306B
ndb_config_mycnf1.cnf 260B
rpl_rotate_logs.cnf 67B
bug15328.cnf 44B
rpl_000015.cnf 33B
combinations 83B
combinations 83B
combinations 83B
Toad.exe.config 23KB
Quest.DataCompare.config 751B
COPYING 19KB
COPYING 19KB
Empress.crash-me 5KB
Access.crash-me 2KB
postgres.crash-me 1KB
Adabas.crash-me 1KB
Informix.crash-me 1KB
general_log.CSM 35B
slow_log.CSM 35B
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
weixin_44365590
- 粉丝: 2
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功