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 ...".
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
arm架构mysql5.7.44,mysql-5.7.44-linux-aarch64.tar.gz (2000个子文件)
libmysqlclient.so.20 7.37MB
libmysqlclient.so.20.3.31 7.37MB
libmysqld.a 541.15MB
libmysqlclient.a 20.11MB
libmysqlservices.a 44KB
default_mysqld.cnf 3KB
default_mysqld_autosize.cnf 2KB
default_ndbd.cnf 2KB
default_my.cnf 544B
openssl3_legacy_tls.cnf 384B
default_client.cnf 367B
ssl_deprecated_tls_versions.cnf 80B
m_i_db_config.cnf 38B
disabled.def 1KB
plugin.defs 5KB
README.gcov 655B
mysqld_ername.h 123KB
psi.h 85KB
mysqld_error.h 45KB
my_sys.h 39KB
mysql_file.h 39KB
m_ctype.h 34KB
mysql_thread.h 33KB
mysql_socket.h 33KB
mysql.h 29KB
plugin.h 26KB
plugin.h 26KB
mysql_com.h 25KB
my_global.h 23KB
plugin_audit.h 18KB
plugin_audit.h 18KB
sql_state.h 15KB
service_command.h 14KB
my_config.h 12KB
plugin_trace.h 12KB
m_string.h 11KB
my_dbug.h 10KB
service_parser.h 10KB
sql_common.h 8KB
plugin_ftparser.h 8KB
plugin_ftparser.h 8KB
keycache.h 8KB
mysql_transaction.h 7KB
client_plugin.h 7KB
mysql_statement.h 7KB
my_getopt.h 7KB
plugin_keyring.h 7KB
plugin_keyring.h 7KB
thread_pool_priv.h 6KB
thr_rwlock.h 6KB
my_byteorder.h 6KB
plugin_group_replication.h 6KB
plugin_group_replication.h 6KB
thr_mutex.h 6KB
my_compiler.h 6KB
plugin_auth.h 6KB
service_mysql_string.h 6KB
service_srv_session_info.h 6KB
decimal.h 5KB
service_ssl_wrapper.h 5KB
thr_cond.h 5KB
plugin_auth_common.h 5KB
service_rules_table.h 5KB
service_srv_session.h 5KB
my_thread.h 5KB
mysql_stage.h 5KB
group_replication_priv.h 5KB
errmsg.h 5KB
psi_memory.h 5KB
service_locking.h 5KB
service_thd_alloc.h 5KB
service_security_context.h 4KB
mysql_table.h 4KB
service_thd_wait.h 4KB
psi_base.h 4KB
mysql_ps.h 4KB
big_endian.h 4KB
little_endian.h 4KB
service_my_snprintf.h 4KB
mysqlx_ername.h 4KB
mysql_mdl.h 4KB
service_rpl_transaction_write_set.h 4KB
com_data.h 3KB
my_dir.h 3KB
sslopt-vars.h 3KB
mysql_sp.h 3KB
my_xml.h 3KB
sslopt-longopts.h 3KB
mysqlx_error.h 3KB
service_mysql_alloc.h 3KB
service_thread_scheduler.h 3KB
my_alloc.h 3KB
mysql_idle.h 3KB
my_thread_local.h 3KB
typelib.h 3KB
byte_order_generic.h 3KB
byte_order_generic_x86.h 3KB
service_mysql_keyring.h 3KB
service_mysql_password_policy.h 3KB
mysql_time.h 3KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
qq_46056473
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功