elect T0.accusation_des, T0.submit_time, T0.result, T0.handle_time, T1.content, t4.nick_name,t5.content , T6.ask_title, T7.state_name,t8.item_name,t9.school_name,t10.school_name,t12.school_name,t14.school_name FR OM wxcommunity.t_accusation t0 left join wxcommunity.t_comment t1 on T1.commentid=T0.commentid left JOIN wxcommunity.t_ask T2 on T2.askid=T1.askid left JOIN wxcommunity.t_school T9 on T9.schoolid=T2.schoolid left JOIN wxcommunity.t_answer T3 on t1.answer_id=t3.answer_id left JOIN wxcommunity.t_ask t11 on T11.askid=T3.askid left JOIN wxcommunity.t_school t12 on T12.schoolid=T11.schoolid left JOIN wxcommunity.t_member T4 on T4.userid=T0.userid left Join Wxcommunity.t_answer T5 on t5.answer_id=t0.answer_id left JOIN wxcommunity.t_ask t13 on T13.askid=T5.askid left JOIN wxcommunity.t_school t14 on T14.schoolid=T13.schoolid left JOIN wxcommunity.t_ask T6 on T6.askid=T0.askid left JOIN wxcommunity.t_school T10 on T10.schoolid=T6.schoolid left JOIN wxcommunity.t_handle_state T7 on T7.stateid=T0.stateid left JOIN wxcommunity.t_accusation_item T8 on t8.accusation_item_id=t0.accusation_item_id WHERE (T0.askid> 0 or t0.answer_id > 0 or t1.askid > 0 or t1.answer_id > 0)
Summary: 1, the SQL statement with or logical relationship JPA query error, initially determine the JPA itself bug.
2, the above statement in the database directly query (NAVICAT Execute SQL statement) is not a problem, but in Java code to execute Executenativesql () error, the beginning of Mysql-connector-java query error to find out the data, Change a mysql-connector-java5.1.30 can detect the data but still wrong (the query record is always one less). The Mysql-connector-java driver itself is initially judged to be defective in Java code.
MySQL Deposit Data Error Summary