MySQL Bugs: #37984: Examples lacking for effects of SQL

Bug #37984	Examples lacking for effects of SQL_MODE changes on partitioning
Submitted:	9 Jul 2008 8:40	Modified:	13 Jul 2008 21:48
Reporter:	Jon Stephens	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	5.1+	OS:	Any
Assigned to:	Jon Stephens	CPU Architecture:	Any
Tags:	partitioning, SQL_MODE

Description:
Email from DavidS, 2008-07-08:

Hi Docs Team,

A customer was requesting examples of how changing the server
SQL mode could affect a partitioned table, as mentioned in these
two places in our Reference Manual:

http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html
http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html

I had a difficult time coming up with some examples, but Peter
Gulutzan was kind enough to point me to an email that he created
that points out several examples... Perhaps we can incorporate some of his examples into our Reference
Manual? 

How to repeat:
See Description.

Suggested fix:
Add a couple of examples showing how Bad Things(TM) can happen if you change SQL_MODE after creating a partitioned table.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.