diff options
author | Sergei Golubchik <sergii@pisem.net> | 2014-05-06 13:57:56 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2014-05-06 13:57:56 +0200 |
commit | 4a84ee1c25045ba1ee4bd23cba3772b90545d3d1 (patch) | |
tree | 42af0798be22fd47a555bdfc77f5d37085565049 /mysql-test/suite/innodb_fts | |
parent | b968363aac2bf75d014482f8405e6a9fed73ccd6 (diff) | |
download | mariadb-git-4a84ee1c25045ba1ee4bd23cba3772b90545d3d1.tar.gz |
after InnoDB/XtraDB 5.6.16 merge
Diffstat (limited to 'mysql-test/suite/innodb_fts')
-rw-r--r-- | mysql-test/suite/innodb_fts/r/innodb_fts_misc_1.result | 14 |
1 files changed, 12 insertions, 2 deletions
diff --git a/mysql-test/suite/innodb_fts/r/innodb_fts_misc_1.result b/mysql-test/suite/innodb_fts/r/innodb_fts_misc_1.result index 0f50d6943a8..9f5c1f271fc 100644 --- a/mysql-test/suite/innodb_fts/r/innodb_fts_misc_1.result +++ b/mysql-test/suite/innodb_fts/r/innodb_fts_misc_1.result @@ -44,6 +44,7 @@ id2 3 SELECT id1 FROM t1 WHERE MATCH (a1,b1) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN BOOLEAN MODE) ; id1 +1 3 6 2 @@ -51,6 +52,7 @@ id1 5 SELECT id2 FROM t2 WHERE MATCH (a2,b2) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN BOOLEAN MODE) ; id2 +1 3 6 2 @@ -89,12 +91,14 @@ SELECT id1 FROM t1 WHERE MATCH (a1,b1) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN id1 SELECT id2 FROM t2 WHERE MATCH (a2,b2) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN BOOLEAN MODE) ; id2 +3 6 SELECT id1 FROM t1 WHERE MATCH (a1,b1) AGAINST ('+update +cascade' IN BOOLEAN MODE) ; id1 4 2 6 +1 5 3 SELECT id2 FROM t2 WHERE MATCH (a2,b2) AGAINST ('+update +cascade' IN BOOLEAN MODE) ; @@ -102,10 +106,12 @@ id2 4 2 6 +1 5 3 SELECT id2 FROM t2 WHERE a2 LIKE '%UPDATE CASCADE%'; id2 +1 2 3 4 @@ -212,10 +218,8 @@ SELECT * FROM t2 WHERE MATCH (a2,b2) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN B id2 a2 b2 SELECT * FROM t1 WHERE a1 LIKE '%tutorial%'; id1 a1 b1 -1 MySQL Tutorial DBMS stands for DataBase VÐƷWİ... SELECT * FROM t2 WHERE a2 LIKE '%tutorial%'; id2 a2 b2 -1 MySQL Tutorial DBMS stands for DataBase VÐƷWİ... DROP TABLE t2 , t1; DROP TABLE IF EXISTS t2,t1; SET NAMES utf8; @@ -265,10 +269,12 @@ id2 a2 b2 SELECT * FROM t1 WHERE MATCH (a1,b1) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN BOOLEAN MODE) ; id1 a1 b1 3 Optimizing MySQL In this tutorial we will show ... +1 MySQL Tutorial DBMS stands for DataBase VÐƷWİ... 2 How To Use MySQL Well After you went through a ... SELECT * FROM t2 WHERE MATCH (a2,b2) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN BOOLEAN MODE) ; id2 a2 b2 3 Optimizing MySQL In this tutorial we will show ... +1 MySQL Tutorial DBMS stands for DataBase VÐƷWİ... 2 How To Use MySQL Well After you went through a ... SELECT * FROM t1 WHERE MATCH (a1,b1) AGAINST ('tutorial' WITH QUERY EXPANSION) ; id1 a1 b1 @@ -327,12 +333,14 @@ SELECT * FROM t1 WHERE MATCH (a1,b1) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN B id1 a1 b1 SELECT * FROM t2 WHERE MATCH (a2,b2) AGAINST ('tutorial (+mysql -VÐƷWİ)' IN BOOLEAN MODE) ; id2 a2 b2 +3 changing column - on UPDATE cascade In this tutorial we will show ... 6 changing column - on UPDATE cascade When configured properly, MySQL ... SELECT * FROM t1 WHERE MATCH (a1,b1) AGAINST ('+UPDATE +cascade' IN BOOLEAN MODE) ; id1 a1 b1 4 changing column - on UPDATE cascade to check foreign constraint 2 changing column - on UPDATE cascade to check foreign constraint 6 changing column - on UPDATE cascade to check foreign constraint +1 changing column - on UPDATE cascade to check foreign constraint 5 changing column - on UPDATE cascade to check foreign constraint 3 changing column - on UPDATE cascade to check foreign constraint SELECT * FROM t2 WHERE MATCH (a2,b2) AGAINST ('+UPDATE +cascade' IN BOOLEAN MODE) ; @@ -340,10 +348,12 @@ id2 a2 b2 4 changing column - on UPDATE cascade 1. Never run mysqld as root. 2. ... 2 changing column - on UPDATE cascade After you went through a ... 6 changing column - on UPDATE cascade When configured properly, MySQL ... +1 changing column - on UPDATE cascade DBMS stands for DataBase VÐƷWİ... 5 changing column - on UPDATE cascade In the following database comparison ... 3 changing column - on UPDATE cascade In this tutorial we will show ... SELECT * FROM t2 WHERE a2 LIKE '%UPDATE CASCADE%'; id2 a2 b2 +1 changing column - on UPDATE cascade DBMS stands for DataBase VÐƷWİ... 2 changing column - on UPDATE cascade After you went through a ... 3 changing column - on UPDATE cascade In this tutorial we will show ... 4 changing column - on UPDATE cascade 1. Never run mysqld as root. 2. ... |