大家好!
我在使用HttpDrizzleModule获取mysql数据时,如果不加rds_json或其他数据类型转换指令,返回的结果有缺失
下面是配置:
upstream mysql {
drizzle_server 127.0.0.1:3306 dbname=test user=root protocol=mysql;
}
server {
listen 80;
server_name localhost;
root html;
location / {
drizzle_pass mysql;
drizzle_query "select id,username,age from users";
#rds_json on;
}
}
mysql的数据为:
mysql> select * from users;
+------+----------+------+
| id | username | age |
+------+----------+------+
| 1 | zhangsan | 24 |
| 2 | lisi | 26 |
+------+----------+------+
下面是注释掉rds_json的结果:
[root@localhost ~]# curl -i localhost
HTTP/1.1 200 OK
Server: ngx_openresty/1.2.4.14
Date: Thu, 07 Feb 2013 08:47:16 GMT
Content-Type: application/x-resty-dbd-stream
Transfer-Encoding: chunked
Connection: keep-alive
X-Resty-DBD-Module: ngx_drizzle 0.0.15
agezhangsan242lisi26
下面是开启rds_json的结果:
[root@localhost ~]# curl -i localhost
HTTP/1.1 200 OK
Server: ngx_openresty/1.2.4.14
Date: Thu, 07 Feb 2013 08:46:26 GMT
Content-Type: application/json
Transfer-Encoding: chunked
Connection: keep-alive
X-Resty-DBD-Module: ngx_drizzle 0.0.15
[{"id":1,"username":"zhangsan","age":24},{"id":2,"username":"lisi","age":26}]
在注释掉rds_json时,多了一个age字段,少了第一条记录的1
麻烦大家帮我看下是什么原因呢?
我也知道没有注释掉rds_json这么用的,但是就是对缺失的记录感觉奇怪。