summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect3.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/subselect3.result')
-rw-r--r--mysql-test/main/subselect3.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/subselect3.result b/mysql-test/main/subselect3.result
index e8e91ec2cc2..710aa00d5aa 100644
--- a/mysql-test/main/subselect3.result
+++ b/mysql-test/main/subselect3.result
@@ -1304,6 +1304,9 @@ set @@optimizer_search_depth=@save_optimizer_search_depth;
set @@optimizer_switch=@save_optimizer_switch;
drop table t0, t1, t2;
set @@optimizer_switch='materialization=off';
+#
+# Primitive SJ-Materialization tests for DECIMAL and DATE
+#
create table t0 (a decimal(4,2));
insert into t0 values (10.24), (22.11);
create table t1 as select * from t0;