summaryrefslogtreecommitdiff
path: root/mysql-test/r/select.result
diff options
context:
space:
mode:
authorunknown <anozdrin/alik@station.>2007-10-24 11:43:16 +0400
committerunknown <anozdrin/alik@station.>2007-10-24 11:43:16 +0400
commit9aa43170660afadc7dd62afb93a60590edb89564 (patch)
tree4a8b9c638cd1d3b8ae979c8d45a233634908bfda /mysql-test/r/select.result
parent8c98e5e1808725722ac9b355890b41280310331b (diff)
parent6044965c4fe14785eb7294c68067486f7451a85f (diff)
downloadmariadb-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.result35
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);