[
https://issues.apache.org/jira/browse/IOTDB-240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
EJTTianyu closed IOTDB-240.
---------------------------
Resolution: Fixed
> 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
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
