Hacktoberfest 2026: los issues que los mantenedores marcaron para octubre, abiertos y aptos para principiantes. Explorar issues de Hacktoberfest

IoTDB 2.0.5 版本中，LIKE 后使用 CONCAT 函数和 || 会报错，直接使用字符串正常

Abierto
  • ¿Algo no está bien?
#17,610 1 comentario 0 reacciones 1 asignado Ver en GitHub

Los mantenedores suelen responder en 1 día

@DaZuiZui ya está trabajando en esto.

Desde el 15/5/2026.

Evaluación

Este issue todavía no se ha evaluado.

Descripción

Search before asking
  • I searched in the issues and found nothing similar.
Version

2.0.5

Describe the bug and provide the minimal reproduce step
IoTDB:ykk> select * from quota_info where **alarmname = concat('正','常')**
+-----------------------------+--------+-------+---------+-----+-----+---------+------+--------------+-----+-----------+
|                         time|deviceid|quotaid|quotaname|alarm|level|alarmname|  unit|referencevalue|value|stringvalue|
+-----------------------------+--------+-------+---------+-----+-----+---------+------+--------------+-----+-----------+
|2026-05-06T17:15:30.860+08:00|     003|      2|     湿度|    0|    0|     正常|     %|         10-20| 50.0|       50.0|
|2026-05-06T17:15:44.337+08:00|     003|      2|     湿度|    0|    0|     正常|     %|         10-20| 10.0|       10.0|
|2026-05-06T17:15:30.738+08:00|     003|      1|     温度|    0|    0|     正常|摄氏度|           1-5| 10.0|       10.0|
+-----------------------------+--------+-------+---------+-----+-----+---------+------+--------------+-----+-----------+
Total line number = 3
It costs 1.865s
IoTDB:ykk> select * from quota_info where **alarmname = concat('正','常','%')**
+----+--------+-------+---------+-----+-----+---------+----+--------------+-----+-----------+
|time|deviceid|quotaid|quotaname|alarm|level|alarmname|unit|referencevalue|value|stringvalue|
+----+--------+-------+---------+-----+-----+---------+----+--------------+-----+-----------+
+----+--------+-------+---------+-----+-----+---------+----+--------------+-----+-----------+
Empty set.
It costs 0.243s
IoTDB:ykk> select * from quota_info where alarmname **like concat('正','常','%')**
Msg: org.apache.iotdb.jdbc.IoTDBSQLException: 305: [INTERNAL_SERVER_ERROR(305)] Exception occurred: "select * from quota_info where alarmname like concat('正','常','%')". executeStatement failed. Cannot invoke "org.apache.iotdb.commons.schema.filter.impl.singlechild.AbstractSingleChildFilter.getSchemaFilterType()" because "currentFilter" is null
IoTDB:ykk> select * from quota_info where alarmname **like concat('正','常')**
Msg: org.apache.iotdb.jdbc.IoTDBSQLException: 305: [INTERNAL_SERVER_ERROR(305)] Exception occurred: "select * from quota_info where alarmname like concat('正','常')". executeStatement failed. Cannot invoke "org.apache.iotdb.commons.schema.filter.impl.singlechild.AbstractSingleChildFilter.getSchemaFilterType()" because "currentFilter" is null
IoTDB:ykk> select * from quota_info where **alarmname like '正常%'**
+-----------------------------+--------+-------+---------+-----+-----+---------+------+--------------+-----+-----------+
|                         time|deviceid|quotaid|quotaname|alarm|level|alarmname|  unit|referencevalue|value|stringvalue|
+-----------------------------+--------+-------+---------+-----+-----+---------+------+--------------+-----+-----------+
|2026-05-06T17:15:30.860+08:00|     003|      2|     湿度|    0|    0|     正常|     %|         10-20| 50.0|       50.0|
|2026-05-06T17:15:44.337+08:00|     003|      2|     湿度|    0|    0|     正常|     %|         10-20| 10.0|       10.0|
|2026-05-06T17:15:30.738+08:00|     003|      1|     温度|    0|    0|     正常|摄氏度|           1-5| 10.0|       10.0|
+-----------------------------+--------+-------+---------+-----+-----+---------+------+--------------+-----+-----------+
Total line number = 3
It costs 0.672s
IoTDB:ykk> select * from quota_info where alarmname **like '正常'||'%'**
Msg: org.apache.iotdb.jdbc.IoTDBSQLException: 305: [INTERNAL_SERVER_ERROR(305)] Exception occurred: "select * from quota_info where alarmname like '正常'||'%'". executeStatement failed. Cannot invoke "org.apache.iotdb.commons.schema.filter.impl.singlechild.AbstractSingleChildFilter.getSchemaFilterType()" because "currentFilter" is null
IoTDB:ykk>
What did you expect to see?

理论上来说like后面不应该可以跟concat()或者用'||'拼接的字符串吗

What did you see instead?

like后面跟concat()或者'||'拼接的字符串会报错

Anything else?

No response

Are you willing to submit a PR?
  • I'm willing to submit a PR!
Lenguaje dominante
Java
Estrellas
6.4k
Forks
1.2k
Merge medio
1 d 15 h
PR fusionados (30 d)
178

Preparar el entorno

Primeros pasos

  1. Lee el issue completo y luego la guía de contribución del proyecto.
  2. Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
  3. Haz un fork del repositorio y trabaja en una rama.
  4. Abre un pull request que haga referencia al número del issue.

Más de apache/iotdb

Todos los issues de apache/iotdb

Issues similares

Más issues de Java

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.