diff options
| author | Sergei Golubchik <serg@mysql.com> | 2009-10-19 15:13:45 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mysql.com> | 2009-10-19 15:13:45 +0200 |
| commit | ed8aaec764932c336c7d839035dfdf104e137108 (patch) | |
| tree | 1107bd8471bf32f5a6ab23d5cf8fe2eb36b5668e /mysql-test/r/fulltext.result | |
| parent | 6fecc5b7268fb35000ae289ff2c02f5cde7b1309 (diff) | |
| download | mariadb-git-ed8aaec764932c336c7d839035dfdf104e137108.tar.gz | |
Bug#34374 mysql generates incorrect warning
backport to next-mr
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index a5216189d9a..abab18e0e99 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -494,6 +494,14 @@ SELECT a FROM t1 WHERE MATCH a AGAINST ('+city* of*' IN BOOLEAN MODE); a City Of God DROP TABLE t1; +create table t1(a text,b date,fulltext index(a))engine=myisam; +insert into t1 set a='water',b='2008-08-04'; +select 1 from t1 where match(a) against ('water' in boolean mode) and b>='2008-08-01'; +1 +1 +drop table t1; +show warnings; +Level Code Message CREATE TABLE t1 (a VARCHAR(255), b INT, FULLTEXT(a), KEY(b)); INSERT INTO t1 VALUES('test', 1),('test', 1),('test', 1),('test', 1), ('test', 1),('test', 2),('test', 3),('test', 4); |