diff options
author | unknown <anozdrin/alik@station.> | 2007-10-24 11:43:16 +0400 |
---|---|---|
committer | unknown <anozdrin/alik@station.> | 2007-10-24 11:43:16 +0400 |
commit | 9aa43170660afadc7dd62afb93a60590edb89564 (patch) | |
tree | 4a8b9c638cd1d3b8ae979c8d45a233634908bfda /mysql-test/r/select.result | |
parent | 8c98e5e1808725722ac9b355890b41280310331b (diff) | |
parent | 6044965c4fe14785eb7294c68067486f7451a85f (diff) | |
download | mariadb-git-9aa43170660afadc7dd62afb93a60590edb89564.tar.gz |
Merge station.:/mnt/raid/alik/MySQL/devel/5.0-rt
into station.:/mnt/raid/alik/MySQL/devel/5.1-rt
mysql-test/r/select.result:
Auto merged
mysql-test/t/select.test:
Auto merged
sql/sql_table.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/select.result')
-rw-r--r-- | mysql-test/r/select.result | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index ed61cfffa6b..e8d9502e823 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -4081,6 +4081,41 @@ SELECT `x` FROM v3; x 1 DROP VIEW v1, v2, v3; + +# +# Bug#30736: Row Size Too Large Error Creating a Table and +# Inserting Data. +# +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; + +CREATE TABLE t1( +c1 DECIMAL(10, 2), +c2 FLOAT); + +INSERT INTO t1 VALUES (0, 1), (2, 3), (4, 5); + +CREATE TABLE t2( +c3 DECIMAL(10, 2)) +SELECT +c1 * c2 AS c3 +FROM t1; + +SELECT * FROM t1; +c1 c2 +0.00 1 +2.00 3 +4.00 5 + +SELECT * FROM t2; +c3 +0.00 +6.00 +20.00 + +DROP TABLE t1; +DROP TABLE t2; + End of 5.0 tests create table t1(a INT, KEY (a)); INSERT INTO t1 VALUES (1),(2),(3),(4),(5); |