From 87fd219d67dc6a0630e882d4be6ced589bd3f0f6 Mon Sep 17 00:00:00 2001 From: "monty@hundin.mysql.fi" <> Date: Thu, 13 Dec 2001 02:31:19 +0200 Subject: Fixed sleep time in mysql-test-run Fixed bug in query cache. Cleaned up des_crypt code. --- Docs/manual.texi | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) (limited to 'Docs') diff --git a/Docs/manual.texi b/Docs/manual.texi index f446b0ff925..e979c443763 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -11282,7 +11282,7 @@ mysql> SELECT name, birth, death, +--------+------------+------------+------+ @end example -The query uses @code{death IS NOT NULL} rather than @code{death != NULL} +The query uses @code{death IS NOT NULL} rather than @code{death <> NULL} because @code{NULL} is a special value. This is explained later. @xref{Working with NULL, , Working with @code{NULL}}. @@ -11367,12 +11367,12 @@ The @code{NULL} value can be surprising until you get used to it. Conceptually, @code{NULL} means missing value or unknown value and it is treated somewhat differently than other values. To test for @code{NULL}, you cannot use the arithmetic comparison operators such as @code{=}, @code{<}, -or @code{!=}. To demonstrate this for yourself, try the following query: +or @code{<>}. To demonstrate this for yourself, try the following query: @example -mysql> SELECT 1 = NULL, 1 != NULL, 1 < NULL, 1 > NULL; +mysql> SELECT 1 = NULL, 1 <> NULL, 1 < NULL, 1 > NULL; +----------+-----------+----------+----------+ -| 1 = NULL | 1 != NULL | 1 < NULL | 1 > NULL | +| 1 = NULL | 1 <> NULL | 1 < NULL | 1 > NULL | +----------+-----------+----------+----------+ | NULL | NULL | NULL | NULL | +----------+-----------+----------+----------+ @@ -11395,7 +11395,7 @@ The default truth value from a boolean operation is 1. This special treatment of @code{NULL} is why, in the previous section, it was necessary to determine which animals are no longer alive using -@code{death IS NOT NULL} instead of @code{death != NULL}. +@code{death IS NOT NULL} instead of @code{death <> NULL}. @node Pattern matching, Counting rows, Working with NULL, Retrieving data @@ -11413,7 +11413,7 @@ SQL pattern matching allows you to use @samp{_} to match any single character and @samp{%} to match an arbitrary number of characters (including zero characters). In MySQL, SQL patterns are case insensitive by default. Some examples are shown below. Note that you do not use @code{=} -or @code{!=} when you use SQL patterns; use the @code{LIKE} or @code{NOT +or @code{<>} when you use SQL patterns; use the @code{LIKE} or @code{NOT LIKE} comparison operators instead. To find names beginning with @samp{b}: @@ -46285,6 +46285,8 @@ Our TODO section contains what we plan to have in 4.0. @xref{TODO MySQL 4.0}. @itemize @bullet @item +Fixed problem with @code{GRANT} when using @code{lower_case_table_names == 1}. +@item Changed @code{SELECT ... IN SHARE MODE} to @code{SELECT .. LOCK IN SHARE MODE} (as in MySQL 3.23). @item -- cgit v1.2.1