Visitar URL original
解决 LEFT/RIGHT JOIN 在主副表都有条件时 preparedValueList 里的主副表值顺序错误 by zhangtianxiao · Pull Request #70 · APIJSON/APIJSON · GitHub
Skip to content

解决 LEFT/RIGHT JOIN 在主副表都有条件时 preparedValueList 里的主副表值顺序错误 #70

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
TommyLemon merged 1 commit into from
Feb 17, 2019
Merged

解决 LEFT/RIGHT JOIN 在主副表都有条件时 preparedValueList 里的主副表值顺序错误 #70

Changes from all commits
Commits
Show all changes
1 commit
Select commit
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
愚蠢的smallint
  • Loading branch information
@zhangtianxiao
zhangtianxiao authored Feb 17, 2019
commit b2e42ffd2e6225150c619780ee2958f5d12fd365
14 changes: 13 additions & 1 deletion APIJSON-Java-Server/APIJSONORM/src/main/java/zuo/biao/apijson/server/AbstractSQLConfig.java
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -1862,6 +1862,8 @@ public String getJoinString() throws Exception {

if (joinList != null) {
String quote = getQuote();
List<Object> pvl = new ArrayList<>();
boolean changed = false;

String sql = null;
SQLConfig jc;
Expand Down Expand Up @@ -1898,7 +1900,10 @@ public String getJoinString() throws Exception {
+ quote + tn + quote + "." + quote + j.getTargetKey() + quote;
jc.setMain(false).setKeyPrefix(true);

preparedValueList.addAll(jc.getPreparedValueList());
// preparedValueList.addAll(jc.getPreparedValueList());

pvl.addAll(jc.getPreparedValueList());
changed = true;
break;

case "": // FULL JOIN
Expand All @@ -1916,6 +1921,13 @@ public String getJoinString() throws Exception {

joinOns += " \n " + sql;
}


if (changed) {
pvl.addAll(preparedValueList);
preparedValueList = pvl;
}

}

return joinOns;
Expand Down