diff options
| author | unknown <bell@sanja.is.com.ua> | 2005-05-26 17:30:12 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2005-05-26 17:30:12 +0300 |
| commit | 80b0baa7405ddb36637ee7ceeb2b15ff90af6635 (patch) | |
| tree | 621ee4a4707d47203a998927e85bd2b8a6772f00 /mysql-test/r/union.result | |
| parent | 9b8e02741ab73838ffa9dd26dd94a560d9d3d667 (diff) | |
| download | mariadb-git-80b0baa7405ddb36637ee7ceeb2b15ff90af6635.tar.gz | |
fixed problem with long string results of expressions in UNIONS (BUG#10025)
mysql-test/r/union.result:
test for Bug #10025
mysql-test/t/union.test:
test for Bug #10025
sql/item.cc:
set HA_OPTION_PACK_RECORD and change type to MYSQL_TYPE_STRING, to allow correct field creation in case of length more then 255 (creation STRING field with length more then 255)
Diffstat (limited to 'mysql-test/r/union.result')
| -rw-r--r-- | mysql-test/r/union.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index c140ecd26e1..57dfd48b6bd 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -1235,3 +1235,17 @@ show columns from t2; Field Type Null Key Default Extra a varchar(3) YES NULL drop table t2, t1; +CREATE TABLE t1 (a mediumtext); +CREATE TABLE t2 (b varchar(20)); +INSERT INTO t1 VALUES ('a'),('b'); +SELECT left(a,100000000) FROM t1 UNION SELECT b FROM t2; +left(a,100000000) +a +b +create table t3 SELECT left(a,100000000) FROM t1 UNION SELECT b FROM t2; +show create table t3; +Table Create Table +t3 CREATE TABLE `t3` ( + `left(a,100000000)` longtext +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop tables t1,t2,t3; |