XiangweiWei created IOTDB-921:
---------------------------------
Summary: The query result set of JDBC will be covered by next query
Key: IOTDB-921
URL: https://issues.apache.org/jira/browse/IOTDB-921
Project: Apache IoTDB
Issue Type: Bug
Reporter: XiangweiWei
Attachments: image-2020-09-27-21-23-32-742.png
```java
public static void main(String[] args) throws ClassNotFoundException,
SQLException {
Class.forName("org.apache.iotdb.jdbc.IoTDBDriver");
try (Connection connection =
DriverManager.getConnection("jdbc:iotdb://127.0.0.1:6667/", "root", "root");
Statement statement = connection.createStatement()) {
try {
statement.execute("SET STORAGE GROUP TO root.sg1");
statement.execute("CREATE TIMESERIES root.sg1.d0.s0 WITH DATATYPE=INT64,
ENCODING=RLE, COMPRESSOR=SNAPPY");
statement.execute("CREATE TIMESERIES root.sg1.d0.s1 WITH DATATYPE=INT64,
ENCODING=RLE, COMPRESSOR=SNAPPY");
statement.execute("CREATE TIMESERIES root.sg1.d1.s0 WITH DATATYPE=INT64,
ENCODING=RLE, COMPRESSOR=SNAPPY");
statement.execute("CREATE TIMESERIES root.sg1.d1.s1 WITH DATATYPE=INT64,
ENCODING=RLE, COMPRESSOR=SNAPPY");
} catch (IoTDBSQLException e) {
System.out.println(e.getMessage());
}
statement.execute("insert into root.sg1.d0(timestamp,s0,s1) values(1,1,1)");
statement.execute("insert into root.sg1.d1(timestamp,s0,s1)
values(1000,1000,1000)");
List<ResultSet> resultSetList = new ArrayList<>();
resultSetList.add(statement.executeQuery("select * from root.sg1.d0 where time
<= 1"));
resultSetList.add(statement.executeQuery("select * from root.sg1.d1 where s0
>= 100"));
for (ResultSet resultSet : resultSetList) {
outputResult(resultSet);
}
} catch (IoTDBSQLException e){
System.out.println(e.getMessage());
}
}
```
The result will be like:
!image-2020-09-27-21-23-32-742.png!
Obviously, the result of `d0` is covered by `d1`!!! It does not have the
timestamp 1000 at all.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
