Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

ALIGN BY DEVICE 查询结果错误

Open
#3 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
csharp
Domain
databases

Research direction

Start with the supplied C# console reproduction and the ExecuteQueryStatementAsync entry point, then inspect how the returned query rows and Values are iterated for the ALIGN BY DEVICE statement. Compare the client output with the CLI result, focusing on why the second row is missing. Done means the C# client returns the same rows as the CLI for this SQL.

Written by the indexing model from the issue text.

Description

版本：Apache.IoTDB.Data 1.0.0.3

查询这样的语句，第2行获取不到数据。
sql：select FIRST_VALUE(ctwingCmdBody) as ctwingCmdBody ,MIN_TIME(ctwingCmdBody) as ts from root.beijingheat.commandCreate.IOT16810103.T10495873.P16810103.* where Time >= 2012-05-22T21:51:48.929 and Time < 2023-10-19T13:51:48.929 ALIGN BY DEVICE

cli的执行有结果：

1697696411896

测试代码如下：

using System.Data;
using Apache.IoTDB.Data;
using Microsoft.Extensions.Logging;

namespace ConsoleApp2
{
internal class Program
{
static void Main(string[] args)
{
string sql = "select FIRST_VALUE(ctwingCmdBody) as ctwingCmdBody ,MIN_TIME(ctwingCmdBody) as ts from root.beijingheat.commandCreate.IOT16810103.T10495873.P16810103.* where Time >= 2012-05-22T21:51:48.929 and Time < 2023-10-19T13:51:48.929 ALIGN BY DEVICE ";

        IoTDBConnection _ioTDB= new IoTDBConnection("DataSource=192.168.1.101;Port=6667;Username=root;Password=root;Compression=false"); ;

        Apache.IoTDB.SessionPool _session= _ioTDB.SessionPool;
        
        Task.Run(async () => 
        {
            _session.Open();

            var query =await _session.ExecuteQueryStatementAsync(sql);
            while (query.HasNext())
            {
                var next = query.Next();
                var values = next.Values;
                var time = next.GetDateTime();
                foreach (var item in values)
                {
                    Console.WriteLine($"{item}");
                }

            }


        });
        Console.ReadLine();
    }
}

}

执行结果如下：
image

Dominant language
C#
Stars
24
Forks
6
No merged PRs in 30d

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from apache/iotdb-client-csharp

All issues in apache/iotdb-client-csharp

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.