8000 in 查询是否支持,结果集不正确 · Issue #877 · openGemini/openGemini · GitHub
[go: up one dir, main page]

Skip to content

in 查询是否支持,结果集不正确 #877

Open

Description

@852814453

Describe the bug(Bug 描述)

建表语句
CREATE MEASUREMENT t_monitor_0000000003_4_6_1 (itemCode TAG, itemValue STRING) WITH ENGINETYPE = COLUMNSTORE SHARDKEY itemCode PRIMARYKEY itemCode SORTKEY itemCode,time

Image

To Reproduce(Bug 复现步骤)

No response

Expected behavior(期望结果)

No response

Screenshots(屏幕截图)

No response

Logs(完整的错误日志)

No response

Additional context(其他的一些补充内容)

No response

Activity

  1. TDroyal commented on Aug 19, 2025

    @TDroyal
    Contributor

    可以提供更详细的信息吗?比如openGemini的版本,是单机还是集群?或许你可以参考我的方式看能否解决问题。
    我用最新源码编译的openGemini,然后启了一个单机的数据库,按照你的方式进行了建表,然后插入了几条数据,测试没有复现出你所遇到的问题。

    > CREATE MEASUREMENT t_monitor_0000000003_4_6_1 (itemCode TAG, itemValue STRING) WITH ENGINETYPE = COLUMNSTORE SHARDKEY itemCode PRIMARYKEY itemCode SORTKEY itemCode,time
    > select * from t_monitor_0000000003_4_6_1
    name: t_monitor_0000000003_4_6_1
    +---------------------+------------+-----------+
    |        time         |  itemCode  | itemValue |
    +---------------------+------------+-----------+
    | 1755565790901288300 | workStatus |         2 |
    | 1755566105512529800 | txzt       |         3 |
    | 1755565773014009600 | wd         |      27.0 |
    | 1755565766099936900 | wd         |      26.0 |
    | 1755566113462521700 | txzt       |      89.5 |
    | 1755566108703479500 | txzt       |         7 |
    +---------------------+------------+-----------+
    3 columns, 6 rows in set
    > select * from t_monitor_0000000003_4_6_1 where time >= 1755565766099936900 and time <= 1755565790901288300 and (itemCode in('wd','txzt','workStatus')) order by time desc limit 20 offset 0
    name: t_monitor_0000000003_4_6_1
    +---------------------+------------+-----------+
    |        time         |  itemCode  | itemValue |
    +---------------------+------------+-----------+
    | 1755565790901288300 | workStatus |         2 |
    | 1755565773014009600 | wd         |      27.0 |
    | 1755565766099936900 | wd         |      26.0 |
    +---------------------+------------+-----------+
    3 columns, 3 rows in set
    > select * from t_monitor_0000000003_4_6_1 where time >= 1755565766099936900 and time <= 1755565790901288300 and (itemCode in('workStatus','txzt','wd')) order by time desc limit 20 offset 0
    name: t_monitor_0000000003_4_6_1
    +---------------------+------------+-----------+
    |        time         |  itemCode  | itemValue |
    +---------------------+------------+-----------+
    | 1755565790901288300 | workStatus |         2 |
    | 1755565773014009600 | wd         |      27.0 |
    | 1755565766099936900 | wd         |      26.0 |
    +---------------------+------------+-----------+
    3 columns, 3 rows in set
    >
  2. 852814453 commented on Nov 17, 2025

    @852814453
    Author
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

    0