summaryrefslogtreecommitdiff
path: root/mysql-test/r/strict.result
diff options
context:
space:
mode:
authorunknown <ramil@mysql.com>2005-07-26 12:18:35 +0500
committerunknown <ramil@mysql.com>2005-07-26 12:18:35 +0500
commit607852cf47e39927d9b96ff419b336ee6823d48a (patch)
tree8b9fa06617c2acc9c5ecdd4d350efb672d2587c1 /mysql-test/r/strict.result
parentc15cab9636f4f2dec2a822a83fb86e3ea84f2d0f (diff)
downloadmariadb-git-607852cf47e39927d9b96ff419b336ee6823d48a.tar.gz
a fix (bug #11546: Bad error message from inserting out of range values, SQL_MODE='tradition').
sql/field.cc: a fix (bug #11546: Bad error message from inserting out of range values, SQL_MODE='tradition'). raise an error in case of strict mode for bit fields.
Diffstat (limited to 'mysql-test/r/strict.result')
-rw-r--r--mysql-test/r/strict.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result
index 49f118b1d96..a742770ae9b 100644
--- a/mysql-test/r/strict.result
+++ b/mysql-test/r/strict.result
@@ -1258,3 +1258,10 @@ select * from t1;
d
2000-10-01
drop table t1;
+set @@sql_mode='traditional';
+create table t1(a bit(2));
+insert into t1 values(b'101');
+ERROR 22001: Data too long for column 'a' at row 1
+select * from t1;
+a
+drop table t1;