【討論中】同一個語句 mysql5.6 與 mysql5.5 問題

gron

公司使用drupal，數(shù)據(jù)庫用mysql5.6 運行一條語句后查不到記錄，實際有4條符合記錄的�？稍谟胢ysql 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?
不能把 確認系每個環(huán)節(jié)

rucypli

把sql拆開小sql  慢慢對比

cenalulu

我更相信是5.6和5.5里存的數(shù)據(jù)不一樣導(dǎo)致查詢結(jié)果不一致

gron

數(shù)據(jù)是一樣的，從5.6導(dǎo)到5.5就能查到。目前已經(jīng)換版本，問題解決了！還沒查到問題原因！