为什么mysql中搜索结果为空？

在mysql中搜索的结果为空，请问可能的原因有哪些?

服务器环境如下：

1. SphinxSE 正常安装
mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| SPHINX     | YES     | Sphinx storage engine 0.9.9                                    | NO           | NO   | NO         |
| FEDERATED  | YES     | Federated MySQL storage engine                                 | NO           | NO   | NO         |
| ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

2. 命令行下搜索结果正常

[root@localhost bin]# ./search test
words:
1. 'test': 181 documents, 504 hits

3. 新建了一个表
CREATE TABLE `sphinx_posts` (
  `id` int(10) unsigned NOT NULL,
  `weight` int(11) NOT NULL,
  `query` varchar(3072) NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `post_subject` varchar(255) DEFAULT NULL,
  KEY `query` (`query`(1024))
) ENGINE=SPHINX CONNECTION="sphinx://127.0.0.1:3312/my_index" DEFAULT CHARSET=utf8;

其中 my_index 是前面search 里用到的index名字

4. 最后希望在mysql 的 sphinx_posts 这个表里搜索，却总是无法得到结果：

mysql> SELECT * FROM sphinx_posts WHERE query="test";
Empty set (0.00 sec)


希望大家给指点下，谢谢！

查询之后，马上执行：SHOW ENGINE SPHINX STATUS;

结果返回什么？

都是空的值

mysql> SELECT * FROM sphinx_posts WHERE query="test";
Empty set (0.00 sec)

mysql> SHOW ENGINE SPHINX STATUS;
Empty set (0.00 sec)

mysql> SHOW ENGINE SPHINX STATUS;
Empty set (0.00 sec)

mysql> SHOW STATUS LIKE 'sphinx_%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| sphinx_time        |       |
| sphinx_total       |       |
| sphinx_total_found |       |
| sphinx_word_count  |       |
| sphinx_words       |       |
+--------------------+-------+
5 rows in set (0.00 sec)

mysql>

不懂是不是数据库使用的索引名称不对？要不要设定索引的名字？

./search -i my_index test
结果如何？


另外mysql版本和coreseek/sphinx版本是什么？

多谢 Honest 关注，Coreseek 版本 3.1，下面是search的结果

[root@localhost bin]# ./search -i my_index test
Coreseek Full Text Server 3.1
Copyright (c) 2006-2008 coreseek.com
using config file '/usr/local/sphinx/etc/csft.conf'...
index 'my_index': query 'test ': returned 183 matches of 183 total in 0.006 sec

displaying matches:
1. document=892, weight=1, forum_id=8, topic_id=219, poster_id=60, topic_first_post=0, post_time=Wed Oct 19 10:57:06 2005, post_subject=9520, topic_last_post_time=Sat Apr 15 17:49:50 2006, deleted=0
        post_id=892
        topic_id=219
        forum_id=8
.....  (搜索结果省略)

words:
1. 'test': 183 documents, 510 hits

（备注：因为数据源是产品数据库，搜索结果与前面帖子里的值有所不同）

请升级到3.2.13版本测试，在看看结果如何，谢谢！