summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/features.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/features.result')
-rw-r--r--mysql-test/main/features.result22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/main/features.result b/mysql-test/main/features.result
index 0da2e5fe..f4caba6d 100644
--- a/mysql-test/main/features.result
+++ b/mysql-test/main/features.result
@@ -11,6 +11,8 @@ Feature_dynamic_columns 0
Feature_fulltext 0
Feature_gis 0
Feature_insert_returning 0
+Feature_into_outfile 0
+Feature_into_variable 0
Feature_invisible_columns 0
Feature_json 0
Feature_locale 0
@@ -187,3 +189,23 @@ drop table t1;
show status like "feature_insert_returning";
Variable_name Value
Feature_insert_returning 1
+#
+# Feature into outfile/variables
+#
+create table t1(id1 int);
+insert into t1 values (1),(2);
+select * into outfile '../../tmp/features_outfile.1' from t1;
+select * from t1 into outfile '../../tmp/features_outfile.2';
+select id1 INTO @x from t1 where id1=1;
+select * from t1 where id1=1 into @y;
+select * from t1 where id1=@x;
+id1
+1
+select @x=@y;
+@x=@y
+1
+drop table t1;
+show status like "feature_into_%";
+Variable_name Value
+Feature_into_outfile 4
+Feature_into_variable 2