diff options
author | unknown <monty@hundin.mysql.fi> | 2002-06-02 20:46:03 +0300 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2002-06-02 20:46:03 +0300 |
commit | 7cb2e2d1dce2c7466388f4a6ade0614564be82fc (patch) | |
tree | 8de3d7e1875b8751450433ee53331ffb7322e7b5 /Docs/manual.texi | |
parent | 0e5f0023b3405449c8e3371cb67989f1c1fbb3f7 (diff) | |
parent | 32113efe2a7d32bfa5820cda37164436a53719cc (diff) | |
download | mariadb-git-7cb2e2d1dce2c7466388f4a6ade0614564be82fc.tar.gz |
merge with 3.23
BitKeeper/deleted/.del-rpl_empty_master_crash.result:
Delete: mysql-test/r/rpl_empty_master_crash.result
BitKeeper/deleted/.del-rpl_empty_master_crash.test:
Delete: mysql-test/t/rpl_empty_master_crash.test
configure.in:
Auto merged
include/my_net.h:
Auto merged
include/my_pthread.h:
Auto merged
libmysql/libmysql.c:
Auto merged
mysql-test/t/func_math.test:
Auto merged
mysys/my_gethostbyname.c:
Auto merged
sql/ha_innodb.cc:
Auto merged
sql/item_func.cc:
Auto merged
Diffstat (limited to 'Docs/manual.texi')
-rw-r--r-- | Docs/manual.texi | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index 305ed69fce0..4362aaa3569 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -31379,6 +31379,17 @@ mysql> SELECT 'David!' LIKE 'David_'; -> 1 mysql> SELECT 'David!' LIKE '%D%v%'; -> 1 +mysql> select TRUNCATE(-1,999,1); + -> -1.9 +@end example + +Starting from MySQL 3.23.51 all numbers are rounded towards zero. + +If @code{D} is negative, then the whole part of the number is zeroed out: + +@example +mysql> select truncate(122,-2); + -> 100 @end example To test for literal instances of a wildcard character, precede the character @@ -47075,6 +47086,11 @@ the following things: @itemize @bullet @item +Cleaned up @code{NULL} handling for default values in @code{DESCRIBE +table_name}. +@item +Fixed @code{truncate()} to round up negative values to the nearest integer. +@item Take down the @code{mysqld} daemon with @code{mysqladmin shutdown}, run @code{myisamchk --silent --force */*.MYI} on all tables, and restart the @code{mysqld} daemon. This will ensure that you are running from a clean |