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-noinstall-5.1.72-winx64
共5287个文件
test:1944个
result:1872个
inc:458个
需积分: 15 8 下载量 79 浏览量
2018-04-24
14:10:45
上传
评论
收藏 119.21MB ZIP 举报
温馨提示
mysql-noinstall-5.1.72-winx64,下载资源 Windows Server2012中安装MySQL同以往版本安装并没有什么不同。 2.1.从MySQL官方:http://dev.mysql.com/downloads/mysql/5.1.html下载Windows (x86, 64-bit), MSI Installer。 2.2.双击安装包进行安装,我们选择“Custom”模式,将安装目录存放在“D:MySQL”中,数据库文件存放在“D:MySQLdata”中; 2.3.设定默认root管理员的帐号密码,这里由于我们是本地测试,所以设定密码为:123456,如果是用于服务器环境,需要根据情况将密码、端口重设;
资源推荐
资源详情
资源评论
收起资源包目录
mysql-noinstall-5.1.72-winx64 (5287个子文件)
binlog_old_version_4_1.000001 146KB
bug33029-slave-relay-bin.000001 4KB
binlog_transaction.000001 2KB
binlog_savepoint.000001 1014B
bug16266.000001 532B
bug47142_master-bin.000001 386B
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_17.001 147KB
ver_5_1-telco.001 147KB
ver_5_1-wl2325_s.001 146KB
ver_5_1-wl2325_r.001 705B
bug32407.001 368B
Makefile.am 2KB
Makefile.am 1KB
bug47012.ARM 19B
bug46565.ARZ 8KB
bug47012.ARZ 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
safe_process_win.cc 11KB
safe_process.cc 8KB
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 17KB
ddl.cln 113B
cmake_install.cmake 1KB
my.cnf 2KB
default_my.cnf 1KB
rpl_1slave_base.cnf 1KB
default_mysqld.cnf 1KB
rpl_test_framework.cnf 913B
default_ndbd.cnf 836B
ndb_config_mycnf2.cnf 641B
my.cnf 492B
my.cnf 475B
rpl_ndb_circular_2ch.cnf 326B
my.cnf 312B
rpl_circular_for_4_hosts.cnf 311B
ndb_config_mycnf1.cnf 260B
rpl_current_user.cnf 124B
rpl_rotate_logs.cnf 67B
bug15328.cnf 44B
combinations 83B
combinations 83B
COPYING 18KB
COPYING 18KB
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
bug49823.CSM 35B
bug49823.CSV 73B
general_log.CSV 0B
slow_log.CSV 0B
BACKUP-1.1.ctl 33KB
BACKUP-1.2.ctl 33KB
BACKUP-1.1.ctl 33KB
BACKUP-1.2.ctl 33KB
BACKUP-1.1.ctl 12KB
BACKUP-1.2.ctl 12KB
BACKUP-1.2.ctl 8KB
BACKUP-1.1.ctl 8KB
BACKUP-2.1.ctl 3KB
BACKUP-2.2.ctl 3KB
共 5287 条
- 1
- 2
- 3
- 4
- 5
- 6
- 53
资源评论
qq307739391
- 粉丝: 1
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功