summaryrefslogtreecommitdiff
path: root/mysql-test/r/union.result
diff options
context:
space:
mode:
authormonty@mysql.com <>2005-04-04 16:43:25 +0300
committermonty@mysql.com <>2005-04-04 16:43:25 +0300
commit5ba3f707f773f1f6a5e2c9cb948c03e68d527668 (patch)
tree3ad1b7dadf9b015e59e0f817db58b9dbc155cb5e /mysql-test/r/union.result
parent9616c9a80d6490ac33bc80c3c9444e8d2bf726e5 (diff)
downloadmariadb-git-5ba3f707f773f1f6a5e2c9cb948c03e68d527668.tar.gz
Don't use -lsupc++ with gcc 3.3 and below as this gives linking problems when linking staticly
Fix that mysql.proc works with new VARCHAR fields Give warnings for wrong zero dates
Diffstat (limited to 'mysql-test/r/union.result')
-rw-r--r--mysql-test/r/union.result17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result
index 8c8e12d8838..c5295048126 100644
--- a/mysql-test/r/union.result
+++ b/mysql-test/r/union.result
@@ -1235,3 +1235,20 @@ show columns from t2;
Field Type Null Key Default Extra
a varchar(3) YES NULL
drop table t2, t1;
+create table t1 (a varchar(5));
+create table t2 select * from t1 union select 'abcdefghijkl';
+show create table t2;
+Table Create Table
+t2 CREATE TABLE `t2` (
+ `a` varchar(12) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1
+select row_format from information_schema.TABLES where table_schema="test" and table_name="t2";
+row_format
+Dynamic
+alter table t2 ROW_FORMAT=fixed;
+show create table t2;
+Table Create Table
+t2 CREATE TABLE `t2` (
+ `a` varchar(12) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED
+drop table t1,t2;