[jira] [Created] (IOTDB-2153) Incorrect query result when selecting from paths containing **

["Zhong Wang (Jira)" <ji...@apache.org>]

Zhong Wang created IOTDB-2153:
---------------------------------

             Summary: Incorrect query result when selecting from paths containing **
                 Key: IOTDB-2153
                 URL: https://issues.apache.org/jira/browse/IOTDB-2153
             Project: Apache IoTDB
          Issue Type: Bug
            Reporter: Zhong Wang


With the following dataset

{code}
set storage group to root.sg.d1;
set storage group to root.sg.d2
create timeseries root.sg.d1.s1 with datatype=TEXT
create timeseries root.sg.d1.s2 with datatype=TEXT
create timeseries root.sg.d2.s1 with datatype=TEXT
create timeseries root.sg.d2.s2 with datatype=TEXT
insert into root.sg.d1(time, s1) values(0, 'foo');
insert into root.sg.d1(time, s2) values(0, 'bar');
insert into root.sg.d2(time, s1) values(0, 'foo');
insert into root.sg.d2(time, s2) values(0, 'bar');
{code}

The query 

{code:sql}
select * from root.sg.**
{code}

produces an empty result set. While the expected result set is


{code}
+-----------------------------+-------------+-------------+-------------+-------------+
|                         Time|root.sg.d1.s1|root.sg.d1.s2|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+-------------+-------------+
|1970-01-01T08:00:00.000+08:00|          foo|          bar|          foo|          bar|
+-----------------------------+-------------+-------------+-------------+-------------+
{code}




--
This message was sent by Atlassian Jira
(v8.20.1#820001)