summaryrefslogtreecommitdiff
path: root/mysql-test/main/fulltext_derived_4316.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/fulltext_derived_4316.result')
-rw-r--r--mysql-test/main/fulltext_derived_4316.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/main/fulltext_derived_4316.result b/mysql-test/main/fulltext_derived_4316.result
new file mode 100644
index 00000000000..141202c9842
--- /dev/null
+++ b/mysql-test/main/fulltext_derived_4316.result
@@ -0,0 +1,8 @@
+create table t1 (ft text) engine=myisam;
+insert into t1 values ('test1'),('test2');
+select distinct match(ft) against("test1" in boolean mode) from
+(select distinct ft from t1) as t;
+match(ft) against("test1" in boolean mode)
+1
+0
+drop table t1;