为什么我的REST API在AWS上返回错误数据，而在本地计算机上不返回？

Question

有趣的bug(?)在我的一些代码中。以下面的查询为例：

String qry2= "select schoolDistrict, COUNT(H) as number from House H where termsSale like \'%VA%\' and closedDate>=\'2019-01-01\' group by schoolDistrict order by number desc";

在我的本地机器上，我获得了正确的数据，例如：

[["3-Widefield",215],["49-Falcon",203],["11-Colorado Springs",152],["20-Academy",131],["2-Harrison",100],["8-Fountain",82],["38-Lewis-Palmer",37],["Re2-Woodland Park",20],["12-Cheyenne Mountain",18],["60-Pueblo",9],["28-Hanover",6],["70-Pueblo",5],["14-Manitou Springs",4],["Re1-Douglas",3],["Rj1-Calhan",3],["22-Ellicott",3],["Re-1-Canon City",2],["Re-2 Fremont",2],["Re-4J-Limon",2],["RE1-Cripple Creek/Victor",2],["Other",2],["60Jt-Miami/Yoder",1],["R-1-Jefferson",1],["23Jt-Peyton",1],["RE-2-Eaton",1],["Re-2-Park",1]]

然而，在我的AWS实例上，当我在上传之后点击API时，我会从数据库中随机获得插入到提要中的数据片段：

[["3-Widefield",729],["49-Falcon",678],["11-Colorado Springs",467],["20-Academy",416],["2-Harrison",314],["8-Fountain",274],["38-Lewis-Palmer",121],["12-Cheyenne Mountain",69],["Re2-Woodland Park",54],["70-Pueblo",33],["Ceiling Fan, Forced Air, Natural Gas",20],["Ceiling Fan, Central Air, Forced Air, Na",19],["28-Hanover",18],["60-Pueblo",17],["14-Manitou Springs",17],["Forced Air, Natural Gas",17],["Central Air, Forced Air, Natural Gas",17],["22-Ellicott",16],["Re1-Douglas",15],["Ceiling Fan, Central Air, Forced Air",13],["23Jt-Peyton",12],["Other",10],["RE1-Cripple Creek/Victor",10],["Forced Air",10],["Central Air, Forced Air",9],["Ceiling Fan, Forced Air",8],["Re-2 Fremont",8],["Rj1-Calhan",7],["60Jt-Miami/Yoder",6],["Re-2-Park",4],["C-1-Elizabeth",4],["100J-Big Sandy",3],["Natural Gas",3],["200-Elbert",3],["Re-1-Canon City",3],["Re-4J-Limon",2],["Central Air",2],["Central Air, Natural Gas",2],["Ceiling Fan, Forced Air, Natural Gas, Wo",1],["Baseboard",1],["28J-Arapahoe",1],["R-1-Jefferson",1],["None",1],["Ceiling Fan, Central Air, Forced Air, Ho",1],["Baseboard, Ceiling Fan, Propane, Radiant",1],["Central Air, Forced Air, Hot Water, Natu",1],["Hot Water, Natural Gas",1],["Ceiling Fan, Natural Gas",1],["Attic Fan, Forced Air, Natural Gas",1],["RE-2-Eaton",1],["Ceiling Fan, Central Air",1],["Ceiling Fan, Electric, Propane, Radiant ",1],["Ceiling Fan, Forced Air, Propane, Wood",1],["Ceiling Fan, Central Air, Natural Gas",1],["Central Air, Hot Water",1]]

有什么想法吗？

Answer 1

会不会是该实例与您的本地实例不在同一时区？

因为在查询中closedDate>=\'2019-01-01\中有这个参数。可能有更多的数据匹配。

Answer 2

我想更新这个问题:事实证明，我确实从一个糟糕的上传中获得了错误的数据。感谢你阅读这个问题！