bk commit into 5.0 tree (jani:1.2105) BUG#18712

[jani]

Below is the list of changes that have just been committed into a local
5.0 repository of jani. When jani 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://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.2105 06/05/04 17:05:21 jani@stripped +2 -0
  Added test case for Bug#18712: Truncation problem. The test
  is only to make sure that this will not be fixed, as it is
  intended behaviour. Documentation will be improved accordingly.

  mysql-test/t/select.test
    1.99 06/05/04 17:05:16 jani@stripped +15 -0
    Added test case for Bug#18712: Truncation problem. The test
    is only to make sure that this will not be fixed, as it is
    intended behaviour. Documentation will be improved accordingly.

  mysql-test/r/select.result
    1.121 06/05/04 17:05:16 jani@stripped +21 -0
    Added test case for Bug#18712: Truncation problem. The test
    is only to make sure that this will not be fixed, as it is
    intended behaviour. Documentation will be improved accordingly.

# 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:	jani
# Host:	ua141d10.elisa.omakaista.fi
# Root:	/home/my/bk/mysql-5.0

--- 1.120/mysql-test/r/select.result	2006-04-01 10:11:59 +03:00
+++ 1.121/mysql-test/r/select.result	2006-05-04 17:05:16 +03:00
@@ -3390,3 +3390,24 @@
 1	SIMPLE	t2	const	PRIMARY	PRIMARY	4	const	1	
 1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	2	Using where
 DROP TABLE t1,t2;
+CREATE TABLE t1 (i TINYINT UNSIGNED NOT NULL);
+INSERT t1 SET i = 0;
+UPDATE t1 SET i = -1;
+Warnings:
+Warning	1264	Out of range value adjusted for column 'i' at row 1
+SELECT * FROM t1;
+i
+0
+UPDATE t1 SET i = CAST(i - 1 AS SIGNED);
+Warnings:
+Warning	1264	Out of range value adjusted for column 'i' at row 1
+SELECT * FROM t1;
+i
+0
+UPDATE t1 SET i = i - 1;
+Warnings:
+Warning	1264	Out of range value adjusted for column 'i' at row 1
+SELECT * FROM t1;
+i
+255
+DROP TABLE t1;

--- 1.98/mysql-test/t/select.test	2006-04-01 08:26:11 +03:00
+++ 1.99/mysql-test/t/select.test	2006-05-04 17:05:16 +03:00
@@ -2871,3 +2871,18 @@
 
 
 DROP TABLE t1,t2;
+
+#
+# Bug#18712: Truncation problem (needs just documenting and test
+# cases to prevent fixing this accidently. It is intended behaviour)
+#
+
+CREATE TABLE t1 (i TINYINT UNSIGNED NOT NULL);
+INSERT t1 SET i = 0;
+UPDATE t1 SET i = -1;
+SELECT * FROM t1;
+UPDATE t1 SET i = CAST(i - 1 AS SIGNED);
+SELECT * FROM t1;
+UPDATE t1 SET i = i - 1;
+SELECT * FROM t1;
+DROP TABLE t1;