diff options
author | unknown <monty@mashka.mysql.fi> | 2003-02-12 21:55:37 +0200 |
---|---|---|
committer | unknown <monty@mashka.mysql.fi> | 2003-02-12 21:55:37 +0200 |
commit | fcb61f5917ee69bba91bd6a926db2eab4ac3eeb5 (patch) | |
tree | 3ac37e452f15c8f05e9d1f338a6050281f838048 /mysql-test/t/help.test | |
parent | 363fd89b92de2fc58e7910f7a27684308656ebda (diff) | |
download | mariadb-git-fcb61f5917ee69bba91bd6a926db2eab4ac3eeb5.tar.gz |
Fixed a lot of wrong memory references as reported by valgrind
Portability fixes
Added new client function: mysql_get_server_version()
New server help code (From Victor Vagin)
Fixed wrong usage of binary()
Disabled RTREE usage for now.
BitKeeper/etc/ignore:
added scripts/fill_help_tables.sql
client/mysql.cc:
Some fixes when using 'help'
cmd-line-utils/libedit/compat.h:
Portability fix
cmd-line-utils/libedit/fgetln.c:
Portability fix
include/mysql.h:
Added new client function: mysql_get_server_version()
libmysql/libmysql.c:
Added new client function: mysql_get_server_version()
libmysqld/libmysqld.c:
Fixed prototype
mysql-test/install_test_db.sh:
Added creation of help tables
mysql-test/r/connect.result:
Added help tables
mysql-test/r/myisam.result:
Test of RTREE index
mysql-test/r/type_ranges.result:
updated results
mysql-test/t/myisam.test:
Test of RTREE index
mysql-test/t/type_ranges.test:
Updated test
mysys/charset.c:
Indentation change
mysys/my_symlink.c:
Removed compiler warning
scripts/fill_help_tables.sh:
Update for new help tables
sql/field.cc:
Indentation changes
sql/filesort.cc:
Optimized character set usage
sql/item_cmpfunc.cc:
Fix wrong usage of binary()
sql/item_cmpfunc.h:
Fix wrong usage of binary()
sql/item_func.cc:
Fix wrong usage of binary()
sql/item_func.h:
Fix wrong usage of binary()
sql/item_strfunc.cc:
Fix wrong usage of binary()
sql/item_sum.cc:
Fix wrong usage of binary()
sql/item_sum.h:
Fix wrong usage of binary()
sql/key.cc:
Indentation change
sql/lex.h:
HELP -> HELP_SYM
sql/mysql_priv.h:
Make get_field() more general
sql/password.c:
Indentation change + variable initialisation moved
sql/sql_acl.cc:
Make get_field() more general
sql/sql_base.cc:
Added comments + assertion for double call to mysql_lock_tables
sql/sql_cache.cc:
Indentation changes
sql/sql_class.h:
Added need_strxnfrm to SORT_FIELD to be able to optimise character set handling in filesort
sql/sql_derived.cc:
Renamed variables
sql/sql_help.cc:
New help functions (from Victor Vagin)
sql/sql_lex.cc:
Removed variables that doesn't have to be initialized for each query
sql/sql_lex.h:
Removed not used variable (olap)
sql/sql_parse.cc:
Fixed (not fatal) access of unitialized memory
Indentation / code cleanup
sql/sql_prepare.cc:
Indentaion cleanup
sql/sql_table.cc:
Disabled RTREE until 5.0
sql/sql_udf.cc:
Make get_field() more general
sql/sql_yacc.yy:
Removed access to uninitialized memory
Always set offset_limit and select_limit when using LIMIT (removed warnings)
Allow usage of 'help week'
sql/table.cc:
Make get_field() more general
More comments
sql/table.h:
Fixded type of TABLE_LIST->derived
sql/time.cc:
Stricter date / datetime handling (to be able to handle timestamps with days and microseconds)
strings/ctype-bin.c:
Added cha
Diffstat (limited to 'mysql-test/t/help.test')
-rw-r--r-- | mysql-test/t/help.test | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/mysql-test/t/help.test b/mysql-test/t/help.test new file mode 100644 index 00000000000..c36b670c6b3 --- /dev/null +++ b/mysql-test/t/help.test @@ -0,0 +1,50 @@ +-- source include/have_innodb.inc + +truncate mysql.help_topic; +truncate mysql.help_category; +truncate mysql.help_relation; + +insert into mysql.help_topic(name,description,example)values('impossible_function_1','description of \n impossible_function1','example of \n impossible_function1'); +SELECT @topic1_id:=LAST_INSERT_ID(); +insert into mysql.help_topic(name,description,example)values('impossible_function_2','description of \n impossible_function2','example of \n impossible_function2'); +SELECT @topic2_id:=LAST_INSERT_ID(); +insert into mysql.help_topic(name,description,example)values('impossible_function_3','description of \n impossible_function3','example of \n impossible_function3'); +SELECT @topic3_id:=LAST_INSERT_ID(); + +insert into mysql.help_category(name)values('impossible_category_1'); +SELECT @category1_id:=LAST_INSERT_ID(); +insert into mysql.help_category(name)values('impossible_category_2'); +SELECT @category2_id:=LAST_INSERT_ID(); + +insert into mysql.help_relation(help_category_id,help_topic_id)values(@category1_id,@topic1_id); +insert into mysql.help_relation(help_category_id,help_topic_id)values(@category1_id,@topic2_id); +insert into mysql.help_relation(help_category_id,help_topic_id)values(@category2_id,@topic2_id); +insert into mysql.help_relation(help_category_id,help_topic_id)values(@category2_id,@topic3_id); + +help 'function_of_my_dream'; +help '%possible_f%'; +help 'impossible_func%'; +help 'impossible_category%'; +help 'impossible_%'; +help '%function_2'; +help '%category_2'; +help 'impossible_function_1'; +help 'impossible_category_1'; + +alter table mysql.help_topic type=innodb; +alter table mysql.help_category type=innodb; +alter table mysql.help_relation type=innodb; + +help 'function_of_my_dream'; +help '%ble_f%'; +help 'impossible_func%'; +help 'impossible_category%'; +help 'impossible_%'; +help '%function_2'; +help '%category_2'; +help 'impossible_function_1'; +help 'impossible_category_1'; + +alter table mysql.help_topic type=myisam; +alter table mysql.help_category type=myisam; +alter table mysql.help_relation type=myisam; |