diff options
| author | Sergei Golubchik <serg@mysql.com> | 2008-11-29 00:27:13 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mysql.com> | 2008-11-29 00:27:13 +0100 |
| commit | f1906c62d563fa1502e68a7d9854313560474be9 (patch) | |
| tree | a78968c5920197f27eb1be86ae94e1dcbdc020fa /mysql-test/r/fulltext.result | |
| parent | 255f8feb4c1120af264d9b686dbde8f65da4e4eb (diff) | |
| download | mariadb-git-f1906c62d563fa1502e68a7d9854313560474be9.tar.gz | |
Bug#34374: mysql generates incorrect warning
an item was evaluated unnecessary, fix that by checking preconditions before evaluating the item
sql/sql_select.cc:
an item was evaluated unnecessary, fix that by checking preconditions before evaluating the item
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 2fc00073448..0a824d2e3de 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -494,3 +494,11 @@ 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 |