summaryrefslogtreecommitdiff
path: root/mysql-test/r/show_check.result
diff options
context:
space:
mode:
authorram@gw.mysql.r18.ru <>2004-10-11 19:17:13 +0500
committerram@gw.mysql.r18.ru <>2004-10-11 19:17:13 +0500
commit725fd87d39832e04b6d413a4b45080e27b8d8fd5 (patch)
tree1af69f550bec6b51a84b2d24dbdc2b7de21d794a /mysql-test/r/show_check.result
parentf317cafc5921050198b980c8418461a0fe79e4b6 (diff)
downloadmariadb-git-725fd87d39832e04b6d413a4b45080e27b8d8fd5.tar.gz
An addition (see ChangeSet
1.2082 04/10/11 18:38:48 ram@gw.mysql.r18.ru +3 -0 A fix (bug #5615 type of aggregate function column wrong when using group by).) Shouldn't it be 'int(11) not null' == the same as in the t1?
Diffstat (limited to 'mysql-test/r/show_check.result')
-rw-r--r--mysql-test/r/show_check.result4
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result
index 8256c8d692a..5ea17c93f48 100644
--- a/mysql-test/r/show_check.result
+++ b/mysql-test/r/show_check.result
@@ -250,9 +250,11 @@ type_bool type_tiny type_short type_mediumint type_bigint type_decimal type_nume
drop table t1;
create table t1 (a int not null);
create table t2 select max(a) from t1;
+Warnings:
+Warning 1263 Data truncated; NULL supplied to NOT NULL column 'max(a)' at row 1
show columns from t2;
Field Type Null Key Default Extra
-max(a) bigint(20) YES NULL
+max(a) int(11) 0
drop table t1,t2;
create table t1 (c decimal, d double, f float, r real);
show columns from t1;