EJTTianyu created IOTDB-240:
-------------------------------
Summary: query problem for iotdb filter
Key: IOTDB-240
URL: https://issues.apache.org/jira/browse/IOTDB-240
Project: Apache IoTDB
Issue Type: Bug
Reporter: EJTTianyu
When querying a timeseries that does not exist, iotdb shows different behavior
for SQL with or without filter.
After starting a new iotdb instance, The following steps in iotdb-client below
could reproduce the problem.
Step 1: set storage group to root.demo
Step 2: CREATE TIMESERIES root.demo.ZT31 WITH DATATYPE=INT64, ENCODING=RLE
Step 3:insert into root.demo(timestamp,ZT31) values(1,1)
when using sql:
1.select ZT1 from root.demo
iotdb-client responds with message "Msg: Execute statement error: do not
select any existing series"
2.select ZT1,ZT31 from root.demo
iotdb-client responds with
+-----------------------------------+--------------+
| Time|root.demo.ZT31|
+-----------------------------------+--------------+
| 1970-01-01T08:00:00.001+08:00| 1|
+-----------------------------------+--------------+
3.select ZT1,ZT31 from root.demo where ZT1>0
iotdb-client responds with message "Msg: Execute statement error: Index: 0,
Size: 0"
Timeseries ZT1 does not exist in condition 2 and condition 3. However, without
using ZT1 as filter to query multiple sensors(at least one exists), iotdb
could respond with datapoints. When using ZT1 as filter, the returned msg
confused users.
In my opinion, both condition 2 and 3 should respond with message "Msg: Execute
statement error: do not select any existing series". Or condition 2 responds
with datapoints, condition 3 responds with "Msg: Execute statement error: do
not select any existing series".
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
