Below is the list of changes that have just been committed into a local
mysqldoc repository of jon. When jon does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.3428 05/08/31 19:24:09 jon@stripped +2 -0
introduction.xml: Clean up diffs between refman and refman-5.0/5.1.
refman-4.1/Makefile.bak
1.1 05/08/31 19:24:06 jon@stripped +197 -0
New BitKeeper file ``refman-4.1/Makefile.bak''
refman/introduction.xml
1.36 05/08/31 19:24:06 jon@stripped +75 -45
Clean up diffs between refman and refman-5.0/5.1.
refman-4.1/Makefile.bak
1.0 05/08/31 19:24:06 jon@stripped +0 -0
BitKeeper file /home/jon/bk/mysqldoc-copy/refman-4.1/Makefile.bak
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: jon
# Host: gigan.
# Root: /home/jon/bk/mysqldoc-copy
--- New file ---
+++ refman-4.1/Makefile.bak 05/08/31 19:24:06
# Makefile for MySQL Reference Manual
# Formats we need for docsrva
# chm
# html-chapter
# html-section
# html-web
# html (using html-dir)
# info
# pdf-a4
# pdf
# txt
# xhtml (using xhtml-dir)
# fragment files
# Location of repository root relative to current directory
REPO_ROOT = ..
# Location of directory containing Makefile components
MAKE_DIR = $(REPO_ROOT)/make.d
all::
@echo "You must say what you want to do."
@echo "Some commands supported by this Makefile:"
@echo " make clean"
@echo " make doc_name.html"
@echo " make doc_name.pdf"
@echo " make doc_name.txt"
depend:: manual.depend
# Dependency list for MySQL Reference Manual
# This variable is updated by "make depend"
MANUAL_SRCS = manual.xml preface.xml introduction.xml installing.xml tutorial.xml using-mysql-programs.xml mysql-database-administration.xml replication.xml mysql-optimization.xml client-side-scripts.xml language-structure.xml reservedwords.xml charset.xml column-types.xml functions.xml sql-syntax.xml storage-engines.xml innodb.xml ndbcluster.xml images/cluster-components-1.png images/multi-comp-1.png spatial-extensions-in-mysql.xml mysql-apis.xml mysql-connectors.xml connector-odbc.xml images/myarchitecture.png images/mydsn-icon.png images/mydsn.png images/mydsn-setup.png images/mydsn-example.png images/mydsn-test-success.png images/mydsn-test-fail.png images/mydsn-options.png images/mydsn-icon.png images/mydsn.png images/mydsn-trace.png images/myaccess.png images/myaccess-odbc.png images/mydsn-trace.png images/mydll-properties.png images/mydsn-options.png images/myflowchart.png connector-net.xml refman-common/news-connector-net.xml connector-j.xml connector-mxj.xml extendin
g-mysql.xml problems.xml error-handling.xml errmsgs-server.xml errmsgs-client.xml refman-common/credits.xml news.xml refman-common/news-4.1.xml refman-common/news-4.0.xml refman-common/news-3.23.xml refman-common/news-innodb.xml refman-common/news-cluster.xml refman-common/news-myodbc.xml porting.xml refman-common/environment-variables.xml regexp.xml limits.xml restrictions.xml refman-common/gpl-license.xml refman-common/mysql-floss-license-exception.xml
manual-prepped.xml: $(MANUAL_SRCS)
manual-manprepped.xml: $(MANUAL_SRCS)
# Overrides for generic rules
manual.html-section: manual.html-section.d
-$(RM) -r $</images
mkdir $</images
cp images/*.png $</images
touch $@
manual.html-chapter: manual.html-chapter.d
-$(RM) -r $</images
mkdir $</images
cp images/*.png $</images
touch $@
manual.html-web: manual.html-web.d
-$(RM) -r $</images
mkdir $</images
cp images/*.png $</images
touch $@
manual.html-help: manual.html-help.d
-$(RM) -r $</images
mkdir $</images
cp images/*.png $</images
touch $@
manual.html-dir: manual.html-dir.d
-$(RM) -r $</images
mkdir $</images
cp images/*.png $</images
touch $@
manual.xhtml-dir: manual.xhtml-dir.d
-$(RM) -r $</images
mkdir $</images
cp images/*.png $</images
touch $@
mysql.info: manual.info
cp manual.info mysql.info
# Fragment files that need to be generated for inclusion with
# MySQL distributions. Most depend on manual.txt, one depends on XML
# sources.
TEXT_FRAGMENT_FILES = \
INSTALL-SOURCE \
INSTALL-WIN-SOURCE \
INSTALL-BINARY \
COPYING \
EXCEPTIONS-CLIENT \
CHANGELOG \
ReadMe.txt
HTML_FRAGMENT_FILES = \
ReadMe.html
fragment-files: $(TEXT_FRAGMENT_FILES) $(HTML_FRAGMENT_FILES)
INSTALL-SOURCE: manual.txt $(GT)
perl -w $(GT) manual.txt \
"Installing MySQL" \
"MySQL Tutorial" \
> $@
INSTALL-WIN-SOURCE: manual.txt $(GT)
perl -w $(GT) manual.txt \
"Installing MySQL from Source on Windows" \
"Post-Installation Setup and Testing" \
> $@
INSTALL-BINARY: manual.txt $(GT)
perl -w $(GT) manual.txt \
"Installing MySQL on Other Unix-Like Systems" \
"MySQL Installation Using a Source Distribution" \
> $@
COPYING: manual.txt $(GT)
perl -w $(GT) manual.txt \
"GNU General Public License" \
"MySQL FLOSS License Exception" \
> $@
EXCEPTIONS-CLIENT: manual.txt $(GT)
perl -w $(GT) manual.txt \
"MySQL FLOSS License Exception" \
> $@
CHANGELOG: manual.txt $(GT)
perl -w $(GT) manual.txt \
"MySQL Change History" \
"Porting to Other Systems" \
> $@
ReadMe.txt: manual.txt $(GT)
perl -w $(GT) manual.txt \
"Installing MySQL on Mac OS X" \
"Installing MySQL on NetWare" \
> $@
ReadMe.html: $(MANUAL_SRCS)
$(CHAPTERFMT) --no-rebuild mac-os-x-installation.html
mv mac-os-x-installation.html ReadMe.html
#$(RM) mac-os-x-installation.*
clean::
$(RM) $(TEXT_FRAGMENT_FILES)
$(RM) $(HTML_FRAGMENT_FILES)
$(RM) manual.txt
# Manual page generation
# Target processes manual.xml and generates a bunch of
# xxx.1 files in the current directory. These get copied to the
# manpages.d directory and post-processed by fix-manpages.pl.
.PRECIOUS: manpages.d
manpages: manpages.d
touch $@
manpages.d: manual-manprepped.xml
-$(RM) -r $@
mkdir $@
$(FIXUP_MANPAGES) --destdir=manpages.d *.1
clean::
$(RM) -r *.1 manpages manpages.d
# Import standard variables and target rules
# Need xml-html-dir for formatting the manual itself into a subdir,
# but also need xml-html for formatting ReadMe.html
include $(MAKE_DIR)/vars-layout
include $(MAKE_DIR)/vars-shell
include $(MAKE_DIR)/vars-docbook
include $(MAKE_DIR)/xml-valid
include $(MAKE_DIR)/xml-format
include $(MAKE_DIR)/xml-useless
include $(MAKE_DIR)/xml-prep
include $(MAKE_DIR)/xml-html
include $(MAKE_DIR)/xml-html-dir
include $(MAKE_DIR)/xml-html-section
include $(MAKE_DIR)/xml-html-chapter
include $(MAKE_DIR)/xml-html-web
include $(MAKE_DIR)/xml-html-help
include $(MAKE_DIR)/xml-xhtml-dir
include $(MAKE_DIR)/xml-pdf
include $(MAKE_DIR)/xml-txt
include $(MAKE_DIR)/xml-texi
include $(MAKE_DIR)/texi-info
include $(MAKE_DIR)/xml-toc
include $(MAKE_DIR)/xml-man
include $(MAKE_DIR)/xml-remark
include $(MAKE_DIR)/xml-depend
CHAPTERFMT = ./chapterfmt.pl
GT = $(TOOLS_DIR)/generate-text-files.pl
--- 1.35/refman/introduction.xml 2005-08-31 17:17:54 +10:00
+++ 1.36/refman/introduction.xml 2005-08-31 19:24:06 +10:00
@@ -9,9 +9,9 @@
<!ENTITY % versions.entities SYSTEM "versions.ent">
%versions.entities;
]>
-<chapter id='introduction'>
+<chapter id="introduction">
- <title id='title-introduction'>&title-introduction;</title>
+ <title id="title-introduction">&title-introduction;</title>
<indexterm type="concept">
<primary>overview</primary>
@@ -169,7 +169,7 @@
<section id="manual-info">
- <title id='title-manual-info'>&title-manual-info;</title>
+ <title id="title-manual-info">&title-manual-info;</title>
<indexterm type="concept">
<primary>online location of manual</primary>
@@ -215,9 +215,14 @@
</indexterm>
<indexterm type="concept">
- <primary>Texinfo</primary>
+ <primary>DocBook XML</primary>
+ <secondary>documentation source format</secondary>
</indexterm>
+ <remark role="todo">
+ Next paragraph needs to be updated.
+ </remark>
+
<para>
The primary document is a set of
<ulink url="http://docbook.org/">DocBook</ulink> XML files. The
@@ -252,7 +257,7 @@
<para>
The copyright to this manual is owned by the Swedish company MySQL
- AB. MySQL® and the MySQL logo are (registered) trademarks of
+ AB. MySQL® and the MySQL logo are registered trademarks of
MySQL AB. Other trademarks and registered trademarks referred to
in this manual are the property of their respective owners, and
are used for identification purposes only.
@@ -352,10 +357,22 @@
<entry>5.0</entry>
</row>
<row>
+ <entry>Foreign keys</entry>
+ <entry>5.1 (implemented in 3.23 for <literal>InnoDB</literal>)</entry>
+ </row>
+ <row>
<entry>Triggers</entry>
<entry>5.0 and 5.1</entry>
</row>
<row>
+ <entry>Full outer joins</entry>
+ <entry>5.1</entry>
+ </row>
+ <row>
+ <entry>Constraints</entry>
+ <entry>5.1 (implemented in 3.23 for <literal>InnoDB</literal>)</entry>
+ </row>
+ <row>
<entry>Partitioning</entry>
<entry>5.1</entry>
</row>
@@ -384,7 +401,7 @@
<section id="nutshell-4-0-features">
- <title id='title-nutshell-4-0-features'>&title-nutshell-4-0-features;</title>
+ <title id="title-nutshell-4-0-features">&title-nutshell-4-0-features;</title>
<itemizedlist>
@@ -835,7 +852,7 @@
</itemizedlist>
- <emphasis role="bold">Note</emphasis>: These engine
+ <emphasis role="bold">Note</emphasis>: These engines
were implemented at different points in the
development of MySQL 4.1. Please see the indicated
sections for particulars in each case.
@@ -986,23 +1003,28 @@
<listitem>
<para>
- <emphasis role="bold">BIT</emphasis> Data Type: See
- <xref linkend="numeric-types"/>.
+ <emphasis role="bold"><literal>BIT</literal> Data
+ Type</emphasis>: Can be used to store numbers in binary
+ notation. See <xref linkend="numeric-type-overview"/>.
</para>
</listitem>
<listitem>
<para>
- <emphasis role="bold">Cursors</emphasis>: Elementary
- support. See <xref linkend="cursors"/>.
+ <emphasis role="bold">Cursors</emphasis>: Elementary support
+ for server-side cursors. See <xref linkend="cursors"/>.
</para>
</listitem>
<listitem>
<para>
<emphasis role="bold">Data Dictionary (Information
- Schema)</emphasis>: See
- <xref linkend="information-schema"/>.
+ Schema)</emphasis>: The introduction of the
+ <literal>INFORMATION_SCHEMA</literal> database in MySQL 5.0
+ provided a standards-compliant means for accessing the MySQL
+ Server's metadata, that is, data about the databases
+ (schemas) on the server and the objects which they contain.
+ See <xref linkend="information-schema"/>.
</para>
</listitem>
@@ -1016,8 +1038,12 @@
<listitem>
<para>
- <emphasis role="bold">Precision Math</emphasis>: See
- <xref linkend="precision-math"/>.
+ <emphasis role="bold">Precision Math</emphasis>: MySQL 5.0
+ introduced stricter criteria for acceptance or rejection of
+ data, and implemented a new library for fixed-point
+ arithmetic. These contributed to a much higher degree of
+ accuracy for mathematical operations and greater control
+ over invalid values. See <xref linkend="precision-math"/>.
</para>
</listitem>
@@ -1033,7 +1059,9 @@
<listitem>
<para>
- <emphasis role="bold">Stored Procedures</emphasis>: See
+ <emphasis role="bold">Stored Routines</emphasis>: Support
+ for named stored procedures and stored functions was
+ implemented in MySQL 5.0. See
<xref linkend="stored-procedures"/>.
</para>
</listitem>
@@ -1041,15 +1069,18 @@
<listitem>
<para>
<emphasis role="bold">Strict Mode and Standard Error
- Handling</emphasis>: See <xref linkend="server-sql-mode"/>
- and <xref linkend="error-handling"/>.
+ Handling</emphasis>: MySQL 5.0 added a strict mode where by
+ it follows standard SQL in a number of ways in which it did
+ not previously. Support for standard SQLSTATE error messages
+ was also implemented. See <xref linkend="server-sql-mode"/>.
</para>
</listitem>
<listitem>
<para>
- <emphasis role="bold">Triggers</emphasis>: See
- <xref linkend="triggers"/>.
+ <emphasis role="bold">Triggers</emphasis>: MySQL 5.0 added
+ limited support for triggers. See <xref linkend="triggers"/>
+ and <xref linkend="ansi-diff-triggers"/>.
</para>
</listitem>
@@ -1059,13 +1090,14 @@
Type</emphasis>: The maximum effective length of a
<literal>VARCHAR</literal> column was increased to 65,532
bytes, and stripping of trailing whitespace was eliminated.
- See <xref linkend="char"/>.
+ See <xref linkend="string-types"/>.
</para>
</listitem>
<listitem>
<para>
- <emphasis role="bold">Views</emphasis>: See
+ <emphasis role="bold">Views</emphasis>: MySQL 5.0 added
+ support for named, updateable views. See
<xref linkend="views"/> and
<xref linkend="ansi-diff-views"/>.
</para>
@@ -1073,12 +1105,10 @@
</itemizedlist>
-<!--
- <para>
- The News section of this manual includes a more in-depth list of
- MySQL 5.0 features. See <xref linkend="news-5-0-x"/>.
- </para>
- -->
+ <para>
+ For more detailed information on changes in MySQL 5.0, see
+ <xref linkend="news-5-0-x"/>.
+ </para>
<para>
For those wishing to take a look at the bleeding edge of MySQL
@@ -1099,7 +1129,7 @@
<section id="compatibility">
- <title id='title-compatibility'>&title-compatibility;</title>
+ <title id="title-compatibility">&title-compatibility;</title>
<indexterm type="concept">
<primary>compatibility</primary>
@@ -1196,7 +1226,7 @@
<section id="standards">
- <title id='title-standards'>&title-standards;</title>
+ <title id="title-standards">&title-standards;</title>
<para>
We are aiming toward supporting the full ANSI/ISO SQL standard,
@@ -1211,7 +1241,7 @@
<section id="sql-mode">
- <title id='title-sql-mode'>&title-sql-mode;</title>
+ <title id="title-sql-mode">&title-sql-mode;</title>
<para>
The MySQL server can operate in different SQL modes, and can
@@ -1245,7 +1275,7 @@
<section id="ansi-mode">
- <title id='title-ansi-mode'>&title-ansi-mode;</title>
+ <title id="title-ansi-mode">&title-ansi-mode;</title>
<indexterm type="concept">
<primary>running</primary>
@@ -1317,7 +1347,7 @@
<section id="extensions-to-ansi">
- <title id='title-extensions-to-ansi'>&title-extensions-to-ansi;</title>
+ <title id="title-extensions-to-ansi">&title-extensions-to-ansi;</title>
<indexterm type="concept">
<primary>hints</primary>
@@ -1885,7 +1915,7 @@
<section id="differences-from-ansi">
- <title id='title-differences-from-ansi'>&title-differences-from-ansi;</title>
+ <title id="title-differences-from-ansi">&title-differences-from-ansi;</title>
<para>
We try to make MySQL Server follow the ANSI SQL standard and the
@@ -1942,7 +1972,7 @@
<section id="ansi-diff-subqueries">
- <title id='title-ansi-diff-subqueries'>&title-ansi-diff-subqueries;</title>
+ <title id="title-ansi-diff-subqueries">&title-ansi-diff-subqueries;</title>
<para>
MySQL 4.1 supports subqueries and derived tables. A
@@ -1964,7 +1994,7 @@
<section id="ansi-diff-select-into-table">
- <title id='title-ansi-diff-select-into-table'>&title-ansi-diff-select-into-table;</title>
+ <title id="title-ansi-diff-select-into-table">&title-ansi-diff-select-into-table;</title>
<indexterm type="function">
<primary>SELECT INTO TABLE</primary>
@@ -2000,7 +2030,7 @@
<section id="ansi-diff-transactions">
- <title id='title-ansi-diff-transactions'>&title-ansi-diff-transactions;</title>
+ <title id="title-ansi-diff-transactions">&title-ansi-diff-transactions;</title>
<indexterm type="function">
<primary>COMMIT</primary>
@@ -2373,7 +2403,7 @@
<section id="ansi-diff-triggers">
- <title id='title-ansi-diff-triggers'>&title-ansi-diff-triggers;</title>
+ <title id="title-ansi-diff-triggers">&title-ansi-diff-triggers;</title>
<indexterm type="concept">
<primary>stored procedures and triggers</primary>
@@ -2404,7 +2434,7 @@
<section id="ansi-diff-foreign-keys">
- <title id='title-ansi-diff-foreign-keys'>&title-ansi-diff-foreign-keys;</title>
+ <title id="title-ansi-diff-foreign-keys">&title-ansi-diff-foreign-keys;</title>
<indexterm type="concept">
<primary>foreign keys</primary>
@@ -2600,7 +2630,7 @@
<section id="ansi-diff-views">
- <title id='title-ansi-diff-views'>&title-ansi-diff-views;</title>
+ <title id="title-ansi-diff-views">&title-ansi-diff-views;</title>
<indexterm type="concept">
<primary>views</primary>
@@ -2640,7 +2670,7 @@
<section id="ansi-diff-comments">
- <title id='title-ansi-diff-comments'>&title-ansi-diff-comments;</title>
+ <title id="title-ansi-diff-comments">&title-ansi-diff-comments;</title>
<indexterm type="concept">
<primary>comments</primary>
@@ -2767,7 +2797,7 @@
<section id="constraints">
- <title id='title-constraints'>&title-constraints;</title>
+ <title id="title-constraints">&title-constraints;</title>
<indexterm type="function">
<primary>constraints</primary>
@@ -2817,7 +2847,7 @@
<section id="constraint-primary-key">
- <title id='title-constraint-primary-key'>&title-constraint-primary-key;</title>
+ <title id="title-constraint-primary-key">&title-constraint-primary-key;</title>
<indexterm type="concept">
<primary>PRIMARY KEY</primary>
@@ -2875,7 +2905,7 @@
<section id="constraint-invalid-data">
- <title id='title-constraint-invalid-data'>&title-constraint-invalid-data;</title>
+ <title id="title-constraint-invalid-data">&title-constraint-invalid-data;</title>
<indexterm type="concept">
<primary>NOT NULL</primary>
@@ -3074,7 +3104,7 @@
<section id="constraint-enum">
- <title id='title-constraint-enum'>&title-constraint-enum;</title>
+ <title id="title-constraint-enum">&title-constraint-enum;</title>
<para>
<literal>ENUM</literal> and <literal>SET</literal> columns
| Thread |
|---|
| • bk commit - mysqldoc@docsrva tree (jon:1.3428) | jon | 31 Aug |
