【讨论中】同一个语句 mysql5.6 与 mysql5.5 问题

gron

公司使用drupal，数据库用mysql5.6 运行一条语句后查不到记录，实际有4条符合记录的。可在用mysql 5.5就能查出来。哪位遇到类似情况，请指教了！

语句如下：

SELECT users_node.picture AS users_node_picture, users_node.uid AS users_node_uid, users_node.name AS users_node_name, users_node.mail AS users_node_mail, node.uid AS node_uid, node.nid AS nid, node.title AS node_title, node.created AS node_created, flag_content.content_id AS flag_content_content_id, 'node' AS field_data_field_image_node_entity_type, 'node' AS field_data_body_node_entity_type FROM node node LEFT JOIN users users_node ON node.uid = users_node.uid LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = '1' AND flag_content_node.uid = '1') LEFT JOIN flag_content flag_content ON node.nid = flag_content.content_id AND (flag_content.fid = '1' AND flag_content.uid = '1' AND flag_content.sid = '0') WHERE (( (node.nid IN  (SELECT tn.nid AS nid FROM  taxonomy_index tn LEFT OUTER JOIN taxonomy_term_hierarchy th ON th.tid = tn.tid LEFT OUTER JOIN taxonomy_term_hierarchy th1 ON th.parent = th1.tid WHERE ( (tn.tid = '154') OR (th1.tid = '154')))) )AND(((node.status = '1') AND (node.type IN  ('article')))))ORDER BY node_created DESC LIMIT 5 OFFSET 0;


还有就是把tid=154 换成tid=4就可以查到记录！

小版主杀手

drupal?
不能把 确认系每个环节

rucypli

把sql拆开小sql  慢慢对比

cenalulu

我更相信是5.6和5.5里存的数据不一样导致查询结果不一致

gron

数据是一样的，从5.6导到5.5就能查到。目前已经换版本，问题解决了！还没查到问题原因！