summaryrefslogtreecommitdiff
path: root/mysql-test/t/union.test
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/t/union.test
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/t/union.test')
-rw-r--r--mysql-test/t/union.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test
index 95b5d4c6aaf..7d3f52bd7ae 100644
--- a/mysql-test/t/union.test
+++ b/mysql-test/t/union.test
@@ -760,3 +760,15 @@ create table t2 select a from t1 union select c from t1;
create table t2 select a from t1 union select b from t1;
show columns from t2;
drop table t2, t1;
+
+#
+# Test that union with VARCHAR produces dynamic row tables
+#
+
+create table t1 (a varchar(5));
+create table t2 select * from t1 union select 'abcdefghijkl';
+show create table t2;
+select row_format from information_schema.TABLES where table_schema="test" and table_name="t2";
+alter table t2 ROW_FORMAT=fixed;
+show create table t2;
+drop table t1,t2;