summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--Docs/glibc-2.2.5.patch49
-rw-r--r--Docs/manual.texi118
-rw-r--r--mysql-test/t/func_like.test2
3 files changed, 87 insertions, 82 deletions
diff --git a/Docs/glibc-2.2.5.patch b/Docs/glibc-2.2.5.patch
index 801984c84f7..ef5d40b6899 100644
--- a/Docs/glibc-2.2.5.patch
+++ b/Docs/glibc-2.2.5.patch
@@ -1,8 +1,8 @@
-diff -r -c --exclude=*.info* glibc-2.2.4/linuxthreads/internals.h glibc-2.2.4-new/linuxthreads/internals.h
-*** glibc-2.2.4/linuxthreads/internals.h Mon Jul 23 20:54:13 2001
---- glibc-2.2.4-new/linuxthreads/internals.h Tue Apr 16 15:08:03 2002
+diff -r -c --exclude='*.info*' glibc-2.2.5.org/linuxthreads/internals.h glibc-2.2.5/linuxthreads/internals.h
+*** glibc-2.2.5.org/linuxthreads/internals.h Thu Nov 29 08:44:16 2001
+--- glibc-2.2.5/linuxthreads/internals.h Tue May 21 10:51:53 2002
***************
-*** 339,345 ****
+*** 343,349 ****
THREAD_SELF implementation is used, this must be a power of two and
a multiple of PAGE_SIZE. */
#ifndef STACK_SIZE
@@ -10,7 +10,7 @@ diff -r -c --exclude=*.info* glibc-2.2.4/linuxthreads/internals.h glibc-2.2.4-ne
#endif
/* The initial size of the thread stack. Must be a multiple of PAGE_SIZE. */
---- 339,345 ----
+--- 343,349 ----
THREAD_SELF implementation is used, this must be a power of two and
a multiple of PAGE_SIZE. */
#ifndef STACK_SIZE
@@ -18,9 +18,9 @@ diff -r -c --exclude=*.info* glibc-2.2.4/linuxthreads/internals.h glibc-2.2.4-ne
#endif
/* The initial size of the thread stack. Must be a multiple of PAGE_SIZE. */
-diff -r -c --exclude=*.info* glibc-2.2.4/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h glibc-2.2.4-new/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h
-*** glibc-2.2.4/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h Fri Jun 9 22:17:35 2000
---- glibc-2.2.4-new/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h Tue Apr 16 15:10:38 2002
+diff -r -c --exclude='*.info*' glibc-2.2.5.org/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h glibc-2.2.5/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h
+*** glibc-2.2.5.org/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h Thu Jun 8 21:49:49 2000
+--- glibc-2.2.5/linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h Tue May 21 10:52:58 2002
***************
*** 64,70 ****
/* The number of threads per process. */
@@ -38,21 +38,21 @@ diff -r -c --exclude=*.info* glibc-2.2.4/linuxthreads/sysdeps/unix/sysv/linux/bi
/* Maximum amount by which a process can descrease its asynchronous I/O
priority level. */
-diff -r -c --exclude=*.info* glibc-2.2.4/nss/nsswitch.c glibc-2.2.4-new/nss/nsswitch.c
-*** glibc-2.2.4/nss/nsswitch.c Mon Jul 23 20:54:48 2001
---- glibc-2.2.4-new/nss/nsswitch.c Fri May 3 04:17:44 2002
+diff -r -c --exclude='*.info*' glibc-2.2.5.org/nss/nsswitch.c glibc-2.2.5/nss/nsswitch.c
+*** glibc-2.2.5.org/nss/nsswitch.c Tue Jul 17 10:21:36 2001
+--- glibc-2.2.5/nss/nsswitch.c Tue May 21 10:59:55 2002
***************
*** 496,501 ****
--- 496,502 ----
{
service_user *new_service;
const char *name;
-+ int name_alloc_len;
++ int name_alloc_len;
while (isspace (line[0]))
++line;
***************
-522
+*** 510,522 ****
if (name == line)
return result;
@@ -66,7 +66,7 @@ diff -r -c --exclude=*.info* glibc-2.2.4/nss/nsswitch.c glibc-2.2.4-new/nss/nssw
/* Set default actions. */
new_service->actions[2 + NSS_STATUS_TRYAGAIN] = NSS_ACTION_CONTINUE;
---- 511,533 ----
+--- 511,534 ----
if (name == line)
return result;
@@ -74,12 +74,12 @@ diff -r -c --exclude=*.info* glibc-2.2.4/nss/nsswitch.c glibc-2.2.4-new/nss/nssw
+
+ #ifdef DO_STATIC_NSS
+ if (!((name_alloc_len == 6 && strncmp(name,"files",5) == 0) ||
-+ (name_alloc_len == 4 && strncmp(name,"dns",3) == 0)))
++ (name_alloc_len == 4 && strncmp(name,"dns",3) == 0)))
+ {
-+ name = (char*) "files";
-+ name_alloc_len=6;
++ name = (char*) "files";
++ name_alloc_len = 6;
+ }
-+ #endif
++ #endif
new_service = (service_user *) malloc (sizeof (service_user)
! + name_alloc_len);
@@ -87,12 +87,13 @@ diff -r -c --exclude=*.info* glibc-2.2.4/nss/nsswitch.c glibc-2.2.4-new/nss/nssw
return result;
! *((char *) __mempcpy (new_service->name, name, name_alloc_len-1)) = '\0';
+!
/* Set default actions. */
new_service->actions[2 + NSS_STATUS_TRYAGAIN] = NSS_ACTION_CONTINUE;
-diff -r -c --exclude=*.info* glibc-2.2.4/time/Makefile glibc-2.2.4-new/time/Makefile
-*** glibc-2.2.4/time/Makefile Fri Aug 10 22:12:07 2001
---- glibc-2.2.4-new/time/Makefile Tue Apr 16 15:11:09 2002
+diff -r -c --exclude='*.info*' glibc-2.2.5.org/time/Makefile glibc-2.2.5/time/Makefile
+*** glibc-2.2.5.org/time/Makefile Fri Aug 10 01:59:41 2001
+--- glibc-2.2.5/time/Makefile Tue May 21 11:01:11 2002
***************
*** 37,44 ****
@@ -112,9 +113,9 @@ diff -r -c --exclude=*.info* glibc-2.2.4/time/Makefile glibc-2.2.4-new/time/Make
-DTZDEFRULES='"$(posixrules-file)"'
CFLAGS-tzfile.c = $(tz-cflags)
-diff -r -c --exclude=*.info* glibc-2.2.4/timezone/Makefile glibc-2.2.4-new/timezone/Makefile
-*** glibc-2.2.4/timezone/Makefile Mon Jul 23 20:58:05 2001
---- glibc-2.2.4-new/timezone/Makefile Tue Apr 16 15:11:09 2002
+diff -r -c --exclude='*.info*' glibc-2.2.5.org/timezone/Makefile glibc-2.2.5/timezone/Makefile
+*** glibc-2.2.5.org/timezone/Makefile Thu Aug 30 00:45:25 2001
+--- glibc-2.2.5/timezone/Makefile Tue May 21 11:01:57 2002
***************
*** 159,166 ****
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 67b8fef35eb..2ce448783e7 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -812,7 +812,7 @@ limits. Here are some examples:
@item Linux-Intel 32 bit @tab 2G, 4G or more, depends on Linux version
@item Linux-Alpha @tab 8T (?)
@item Solaris 2.5.1 @tab 2G (possible 4G with patch)
-@item Solaris 2.6 @tab 4G
+@item Solaris 2.6 @tab 4G (can be changed with flag)
@item Solaris 2.7 Intel @tab 4G
@item Solaris 2.7 UltraSPARC @tab 512G
@end multitable
@@ -26723,11 +26723,11 @@ In the first statement, the @code{LIKE} value begins with a wildcard
character. In the second statement, the @code{LIKE} value is not a
constant.
-MySQL 4.0 does another optimization on @code{LIKE}. If you are using
-@code{... LIKE "%string%"} and @code{string} is longer than 3 characters
-then MySQL will use the turbo-boyer-moore algorithm to once initialize
-the pattern for the string and then use this pattern to quickly search
-after the given string.
+MySQL 4.0 does another optimization on @code{LIKE}. If you use
+@code{... LIKE "%string%"} and @code{string} is longer than 3 characters,
+MySQL will use the @code{Turbo Boyer-Moore} algorithm to initialise the
+pattern for the string and then use this pattern to perform the search
+quicker.
@findex IS NULL, and indexes
@cindex indexes, and @code{IS NULL}
@@ -32499,8 +32499,9 @@ mysql> SELECT UNIX_TIMESTAMP('1997-10-04 22:23:00');
When @code{UNIX_TIMESTAMP} is used on a @code{TIMESTAMP} column, the function
will return the internal timestamp value directly, with no implicit
``string-to-unix-timestamp'' conversion.
-If you give @code{UNIX_TIMESTAMP()} a wrong or out-of-range date, it will
-return 0.
+If you pass an out-of-range date to @code{UNIX_TIMESTAMP()} it will
+return 0, but please note that only basic checking is performed
+(year 1970-2037, month 01-12, day 01-31).
If you want to subtract @code{UNIX_TIMESTAMP()} columns, you may want to
cast the result to signed integers. @xref{Cast Functions}.
@@ -49302,7 +49303,7 @@ Our TODO section contains what we plan to have in 4.0. @xref{TODO MySQL 4.0}.
@menu
* News-4.0.2:: Changes in release 4.0.2
-* News-4.0.1:: Changes in release 4.0.1
+* News-4.0.1:: Changes in release 4.0.1 (23 Dec 2001)
* News-4.0.0:: Changes in release 4.0.0
@end menu
@@ -49311,7 +49312,8 @@ Our TODO section contains what we plan to have in 4.0. @xref{TODO MySQL 4.0}.
@itemize @bullet
@item
-Use turbo-boyer-moore to speed up @code{LIKE "%keyword%"} searches.
+Use @code{Turbo Boyer-Moore} algorithm to speed up @code{LIKE "%keyword%"}
+searches.
@item
Fixed bug in @code{DROP DATABASE} with symlink.
@item
@@ -49507,7 +49509,7 @@ GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
@end itemize
@node News-4.0.1, News-4.0.0, News-4.0.2, News-4.0.x
-@appendixsubsec Changes in release 4.0.1
+@appendixsubsec Changes in release 4.0.1 (23 Dec 2001)
@itemize @bullet
@item
@@ -49739,36 +49741,36 @@ not yet 100% confident in this code.
@menu
* News-3.23.51:: Changes in release 3.23.51
-* News-3.23.50:: Changes in release 3.23.50
+* News-3.23.50:: Changes in release 3.23.50 (21 Apr 2002)
* News-3.23.49:: Changes in release 3.23.49
-* News-3.23.48:: Changes in release 3.23.48
-* News-3.23.47:: Changes in release 3.23.47
-* News-3.23.46:: Changes in release 3.23.46
-* News-3.23.45:: Changes in release 3.23.45
-* News-3.23.44:: Changes in release 3.23.44
+* News-3.23.48:: Changes in release 3.23.48 (07 Feb 2002)
+* News-3.23.47:: Changes in release 3.23.47 (27 Dec 2001)
+* News-3.23.46:: Changes in release 3.23.46 (29 Nov 2001)
+* News-3.23.45:: Changes in release 3.23.45 (22 Nov 2001)
+* News-3.23.44:: Changes in release 3.23.44 (31 Oct 2001)
* News-3.23.43:: Changes in release 3.23.43
-* News-3.23.42:: Changes in release 3.23.42
-* News-3.23.41:: Changes in release 3.23.41
+* News-3.23.42:: Changes in release 3.23.42 (08 Sep 2001)
+* News-3.23.41:: Changes in release 3.23.41 (11 Aug 2001)
* News-3.23.40:: Changes in release 3.23.40
-* News-3.23.39:: Changes in release 3.23.39
-* News-3.23.38:: Changes in release 3.23.38
-* News-3.23.37:: Changes in release 3.23.37
-* News-3.23.36:: Changes in release 3.23.36
-* News-3.23.35:: Changes in release 3.23.35
+* News-3.23.39:: Changes in release 3.23.39 (12 Jun 2001)
+* News-3.23.38:: Changes in release 3.23.38 (09 May 2001)
+* News-3.23.37:: Changes in release 3.23.37 (17 Apr 2001)
+* News-3.23.36:: Changes in release 3.23.36 (27 Mar 2001)
+* News-3.23.35:: Changes in release 3.23.35 (15 Mar 2001)
* News-3.23.34a:: Changes in release 3.23.34a
-* News-3.23.34:: Changes in release 3.23.34
-* News-3.23.33:: Changes in release 3.23.33
-* News-3.23.32:: Changes in release 3.23.32
-* News-3.23.31:: Changes in release 3.23.31
-* News-3.23.30:: Changes in release 3.23.30
-* News-3.23.29:: Changes in release 3.23.29
-* News-3.23.28:: Changes in release 3.23.28
-* News-3.23.27:: Changes in release 3.23.27
+* News-3.23.34:: Changes in release 3.23.34 (10 Mar 2001)
+* News-3.23.33:: Changes in release 3.23.33 (09 Feb 2001)
+* News-3.23.32:: Changes in release 3.23.32 (22 Jan 2001)
+* News-3.23.31:: Changes in release 3.23.31 (17 Jan 2001)
+* News-3.23.30:: Changes in release 3.23.30 (04 Jan 2001)
+* News-3.23.29:: Changes in release 3.23.29 (16 Dec 2000)
+* News-3.23.28:: Changes in release 3.23.28 (22 Nov 2000)
+* News-3.23.27:: Changes in release 3.23.27 (24 Oct 2000)
* News-3.23.26:: Changes in release 3.23.26
* News-3.23.25:: Changes in release 3.23.25
-* News-3.23.24:: Changes in release 3.23.24
+* News-3.23.24:: Changes in release 3.23.24 (08 Sep 2000)
* News-3.23.23:: Changes in release 3.23.23
-* News-3.23.22:: Changes in release 3.23.22
+* News-3.23.22:: Changes in release 3.23.22 (31 Jul 2000)
* News-3.23.21:: Changes in release 3.23.21
* News-3.23.20:: Changes in release 3.23.20
* News-3.23.19:: Changes in release 3.23.19
@@ -49795,6 +49797,7 @@ not yet 100% confident in this code.
@node News-3.23.51, News-3.23.50, News-3.23.x, News-3.23.x
@appendixsubsec Changes in release 3.23.51
+
@itemize @bullet
@item
Fixed bug in @code{CONCAT_WS()} that cut the result.
@@ -49838,7 +49841,8 @@ Linux-x86 binaries.
@end itemize
@node News-3.23.50, News-3.23.49, News-3.23.51, News-3.23.x
-@appendixsubsec Changes in release 3.23.50
+@appendixsubsec Changes in release 3.23.50 (21 Apr 2002)
+
@itemize @bullet
@item
Fixed problem with @code{crash-me} and @code{gcc} 3.0.4.
@@ -49927,7 +49931,7 @@ Fixed shutdown problem on NT.
@end itemize
@node News-3.23.48, News-3.23.47, News-3.23.49, News-3.23.x
-@appendixsubsec Changes in release 3.23.48
+@appendixsubsec Changes in release 3.23.48 (07 Feb 2002)
@itemize @bullet
@item
@@ -49986,7 +49990,7 @@ this situation.
@end itemize
@node News-3.23.47, News-3.23.46, News-3.23.48, News-3.23.x
-@appendixsubsec Changes in release 3.23.47
+@appendixsubsec Changes in release 3.23.47 (27 Dec 2001)
@itemize @bullet
@item
@@ -50018,7 +50022,7 @@ Fixed bug when using @code{t1 LEFT JOIN t2 ON t2.key=constant}.
@end itemize
@node News-3.23.46, News-3.23.45, News-3.23.47, News-3.23.x
-@appendixsubsec Changes in release 3.23.46
+@appendixsubsec Changes in release 3.23.46 (29 Nov 2001)
@itemize @bullet
@item
@@ -50047,7 +50051,7 @@ Fixed bug in replication on Mac OS X.
@end itemize
@node News-3.23.45, News-3.23.44, News-3.23.46, News-3.23.x
-@appendixsubsec Changes in release 3.23.45
+@appendixsubsec Changes in release 3.23.45 (22 Nov 2001)
@itemize @bullet
@item
@@ -50084,7 +50088,7 @@ Fixed bug in @code{TIME_TO_SEC()} when using negative values.
@end itemize
@node News-3.23.44, News-3.23.43, News-3.23.45, News-3.23.x
-@appendixsubsec Changes in release 3.23.44
+@appendixsubsec Changes in release 3.23.44 (31 Oct 2001)
@itemize @bullet
@item
@@ -50207,7 +50211,7 @@ Fixed bug in @code{--safe-user-create}.
@end itemize
@node News-3.23.42, News-3.23.41, News-3.23.43, News-3.23.x
-@appendixsubsec Changes in release 3.23.42
+@appendixsubsec Changes in release 3.23.42 (08 Sep 2001)
@itemize @bullet
@item
@@ -50265,7 +50269,7 @@ other threads.
@end itemize
@node News-3.23.41, News-3.23.40, News-3.23.42, News-3.23.x
-@appendixsubsec Changes in release 3.23.41
+@appendixsubsec Changes in release 3.23.41 (11 Aug 2001)
@itemize @bullet
@item
@@ -50365,7 +50369,7 @@ type. @code{GEMINI} is not released under an @code{Open Source} license.
@node News-3.23.39, News-3.23.38, News-3.23.40, News-3.23.x
-@appendixsubsec Changes in release 3.23.39
+@appendixsubsec Changes in release 3.23.39 (12 Jun 2001)
@itemize @bullet
@item
@@ -50408,7 +50412,7 @@ Fixed problem with @code{MERGE} tables and big tables (> 4G) when using
@node News-3.23.38, News-3.23.37, News-3.23.39, News-3.23.x
-@appendixsubsec Changes in release 3.23.38
+@appendixsubsec Changes in release 3.23.38 (09 May 2001)
@itemize @bullet
@item
@@ -50460,7 +50464,7 @@ Fixed bug with @code{LOCK TABLE} and @code{BDB} tables.
@node News-3.23.37, News-3.23.36, News-3.23.38, News-3.23.x
-@appendixsubsec Changes in release 3.23.37
+@appendixsubsec Changes in release 3.23.37 (17 Apr 2001)
@itemize @bullet
@item
@@ -50526,7 +50530,7 @@ Added @code{--skip-safemalloc} option to @code{mysqld}.
@node News-3.23.36, News-3.23.35, News-3.23.37, News-3.23.x
-@appendixsubsec Changes in release 3.23.36
+@appendixsubsec Changes in release 3.23.36 (27 Mar 2001)
@itemize @bullet
@item
@@ -50567,7 +50571,7 @@ Changed some macros to be able to use fast mutex with @code{glibc} 2.2.
@node News-3.23.35, News-3.23.34a, News-3.23.36, News-3.23.x
-@appendixsubsec Changes in release 3.23.35
+@appendixsubsec Changes in release 3.23.35 (15 Mar 2001)
@itemize @bullet
@item
@@ -50596,7 +50600,7 @@ to be compiled.
@node News-3.23.34, News-3.23.33, News-3.23.34a, News-3.23.x
-@appendixsubsec Changes in release 3.23.34
+@appendixsubsec Changes in release 3.23.34 (10 Mar 2001)
@itemize @bullet
@item
@@ -50672,7 +50676,7 @@ where @code{bar} is a column reference, an error was not properly generated.
@node News-3.23.33, News-3.23.32, News-3.23.34, News-3.23.x
-@appendixsubsec Changes in release 3.23.33
+@appendixsubsec Changes in release 3.23.33 (09 Feb 2001)
@itemize @bullet
@item
@@ -50764,7 +50768,7 @@ the disk cache.
@node News-3.23.32, News-3.23.31, News-3.23.33, News-3.23.x
-@appendixsubsec Changes in release 3.23.32
+@appendixsubsec Changes in release 3.23.32 (22 Jan 2001)
@itemize @bullet
@item
@@ -50806,7 +50810,7 @@ Added @code{MASTER_POS_WAIT()}.
@node News-3.23.31, News-3.23.30, News-3.23.32, News-3.23.x
-@appendixsubsec Changes in release 3.23.31
+@appendixsubsec Changes in release 3.23.31 (17 Jan 2001)
@itemize @bullet
@item
@@ -50862,7 +50866,7 @@ Added @code{Threads_created} status variable to @code{mysqld}.
@node News-3.23.30, News-3.23.29, News-3.23.31, News-3.23.x
-@appendixsubsec Changes in release 3.23.30
+@appendixsubsec Changes in release 3.23.30 (04 Jan 2001)
@itemize @bullet
@item
@@ -50925,7 +50929,7 @@ Fixed bug when running two simultaneous @code{SHOW LOGS} queries.
@node News-3.23.29, News-3.23.28, News-3.23.30, News-3.23.x
-@appendixsubsec Changes in release 3.23.29
+@appendixsubsec Changes in release 3.23.29 (16 Dec 2000)
@itemize @bullet
@item
@@ -51054,7 +51058,7 @@ read by @code{mysql_options()}.
@node News-3.23.28, News-3.23.27, News-3.23.29, News-3.23.x
-@appendixsubsec Changes in release 3.23.28
+@appendixsubsec Changes in release 3.23.28 (22 Nov 2000)
@itemize @bullet
@item
@@ -51177,7 +51181,7 @@ new table with the rows in a specific order.
@node News-3.23.27, News-3.23.26, News-3.23.28, News-3.23.x
-@appendixsubsec Changes in release 3.23.27
+@appendixsubsec Changes in release 3.23.27 (24 Oct 2000)
@itemize @bullet
@item
@@ -51367,7 +51371,7 @@ Added file mutexes to make @code{pwrite()} safe on Windows.
@node News-3.23.24, News-3.23.23, News-3.23.25, News-3.23.x
-@appendixsubsec Changes in release 3.23.24
+@appendixsubsec Changes in release 3.23.24 (08 Sep 2000)
@itemize @bullet
@item
@@ -51503,7 +51507,7 @@ Full-text search via the @code{MATCH()} function and @code{FULLTEXT} index type
@node News-3.23.22, News-3.23.21, News-3.23.23, News-3.23.x
-@appendixsubsec Changes in release 3.23.22
+@appendixsubsec Changes in release 3.23.22 (31 Jul 2000)
@itemize @bullet
@item
diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test
index 6c0313d0437..09746fcc817 100644
--- a/mysql-test/t/func_like.test
+++ b/mysql-test/t/func_like.test
@@ -11,7 +11,7 @@ select * from t1 where a like "test%";
select * from t1 where a like "te_t";
#
-# The following will test the boyer-more code
+# The following will test the Turbo Boyer-Moore code
#
select * from t1 where a like "%a%";
select * from t1 where a like "%abcd%";
View Lorry Controller Status