diff options
author | unknown <paul@central.snake.net> | 2000-10-13 12:33:52 -0500 |
---|---|---|
committer | unknown <paul@central.snake.net> | 2000-10-13 12:33:52 -0500 |
commit | 0f9edca2e4acd938300ded9c3dcf39dc7a675e6d (patch) | |
tree | df8e78de1a223132a303eff90d4e852ac5c3c583 | |
parent | 4d1cdcfe7d0eb7c228bc7f9240f5f6a668a2c379 (diff) | |
download | mariadb-git-0f9edca2e4acd938300ded9c3dcf39dc7a675e6d.tar.gz |
manual.texi Cleanups for recent release notes.
manual.texi Add note to CREATE TABLE section that default values
manual.texi must be constants (cannot be functions).
Docs/manual.texi:
Cleanups for recent release notes.
-rw-r--r-- | Docs/manual.texi | 33 |
1 files changed, 19 insertions, 14 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index d1b4e2d2964..2e6d2ec6fbc 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -17275,6 +17275,10 @@ For string types other than @code{ENUM}, the default value is the empty string. For @code{ENUM}, the default is the first enumeration value. @end itemize +Default values must be constants. This means, for example, that you cannot +set the default for a date column to be the value of a function such as +@code{NOW()} or @code{CURRENT_DATE}. + @item @code{KEY} is a synonym for @code{INDEX}. @@ -21493,7 +21497,7 @@ with @code{myisamchk -ed}. All links may be removed with @code{myisamchk -r}. @node Compressed format, , Dynamic format, MyISAM table formats @subsubsection Compressed table characteristics -This is a read only type that is generated with the optional +This is a read-only type that is generated with the optional @code{myisampack} tool (@code{pack_isam} for @code{ISAM} tables). @itemize @bullet @@ -28012,7 +28016,7 @@ falls back to normal read/write file usage if @code{mmap()} doesn't work. There are currently two limitations with @code{myisampack}: @itemize @bullet @item -After packing, the table is read only. +After packing, the table is read-only. @item @code{myisampack} can also pack @code{BLOB} or @code{TEXT} columns. The older @code{pack_isam} could not do this. @@ -37949,34 +37953,35 @@ use @code{TYPE=} but this usage is deprecated). Fixed mutex bug in the binary replication log - long update queries could be read only in part by the slave if it did it at the wrong time, which was not fatal, but resulted in a performance-degrading reconnect and -a scary message in the error log +a scary message in the error log. @item Changed the format of the binary log - added magic number, server -version, binlog version. Added server id and query error code for each query event +version, binlog version. Added server id and query error code for each +query event. @item -Replication thread from the slave will now kill all the stale threads -from the same server +Replication thread from the slave now will kill all the stale threads +from the same server. @item -Long replication user names were not being handled properly +Long replication user names were not being handled properly. @item -Added --replicate-rewrite-db +Added @code{--replicate-rewrite-db} option to @code{mysqld}. @item -Added --skip-slave-start +Added @code{--skip-slave-start} option to @code{mysqld}. @item -Updates that generated an error code ( such as INSERT INTO foo(some_key) -values (1),(1);) erroneously terminated the slave thread +Updates that generated an error code ( such as @code{INSERT INTO foo(some_key) +values (1),(1)}) erroneously terminated the slave thread. @item Added optimization of queries where @code{DISTINCT} is only used on columns from some of the tables. @item -Allow floating point numbers where there are no sign after the exponent +Allow floating point numbers where there is no sign after the exponent (like 1e1). @item @code{SHOW GRANTS} didn't always show all column grants. @item Added @code{--default-extra-file=#} to all @strong{MySQL} clients. @item -Columns referenced in @code{INSERT} are are now properly initialized. +Columns referenced in @code{INSERT} statements now are initialized properly. @item @code{UPDATE} didn't always work when used with a range on a timestamp that was part of the key that was used to find rows. @@ -38092,7 +38097,7 @@ be repaired! Fixed small memory leak introduced from 3.23.22 when creating a temporary table. @item -Fixed problem with BDB tables and reading on unique (not primary) key. +Fixed problem with BDB tables and reading on a unique (not primary) key. @item Restored the win1251 character set (it's now only marked deprecated). @end itemize |