定义STABLE的TAGS字段为BIGINT类型时查询卡死

[zeroxxmmbm]

创建的表单如下:

CREATE STABLE prd_job_order_report (
	report_time TIMESTAMP,
	org_id INT,
	order_number varchar(50),
	order_detail_seq INT,
	job_order_number varchar(50),
	machine_number VARCHAR(20),
	cavity_num INT,
	report_count INT,
	quantity DECIMAL(28,10),
	total_quantity DECIMAL(28,10),
	report_type VARCHAR(60),
	remark VARCHAR(100),
	shift_name VARCHAR(20),
	operator_name VARCHAR(50)
) TAGS (job_order_id BIGINT,order_id BIGINT,order_detail_id BIGINT,machine_id BIGINT,operator_id BIGINT,shift_id BIGINT);

超级表创建成功后，子表以machine_id拆分成多张子表 t_machine_{id} 插入多张子表后查询超级表时 job_order_id使用字符串就正常查询,使用数值查询就卡死(不加引号时)，只能重启容器,使用docker容器体验出现的问题，并且仅有2张表每张表20条数据,版本见截图 select report_time,operator_name,report_count,quantity,job_order_number from prd_job_order_report where job_order_id = "31623211405312"; 图片上传失败，附带成文字面板

taos> select report_time,operator_name,report_count,quantity,machine_number from prd_job_order_report where job_order_id = 31623211405312;
^[OQ^C
DB error: Query killed [0x8000022D] (6.839545s)
taos> [root@localhost ~]# docker exec -it tdengine bash
root@70e4d46c32d5:~# taos -p
Enter password: 
Welcome to the TDengine Command Line Interface, Native Client Version:3.3.6.0 
Copyright (c) 2025 by TDengine, all rights reserved.


  *********************************  Tab Completion  *************************************
  *   The TDengine CLI supports tab completion for a variety of items,                   *
  *   including database names, table names, function names and keywords.                *
  *   The full list of shortcut keys is as follows:                                      *
  *    [ TAB ]        ......  complete the current word                                  *
  *                   ......  if used on a blank line, display all supported commands    *
  *    [ Ctrl + A ]   ......  move cursor to the st[A]rt of the line                     *
  *    [ Ctrl + E ]   ......  move cursor to the [E]nd of the line                       *
  *    [ Ctrl + W ]   ......  move cursor to the middle of the line                      *
  *    [ Ctrl + L ]   ......  clear the entire screen                                    *
  *    [ Ctrl + K ]   ......  clear the screen after the cursor                          *
  *    [ Ctrl + U ]   ......  clear the screen before the cursor                         *
  ****************************************************************************************

Server is TDengine Community Edition, ver:3.3.6.0 and will never expire.

taos> show database;

DB error: syntax error near "database;" [0x80002600] (0.000194s)

[yu285]

麻烦提供一下：

子表的建表/写入语句，我们本地复现一下。

[zeroxxmmbm]

麻烦提供一下：

子表的建表/写入语句，我们本地复现一下。

你好 子表插入语句 INSERT INTO t_machine_report_37 USING production_report_1 TAGS ("31623211405312","100482","101033","112371558940676","100225","40406") VALUES ("2025-05-15 09:46:47","1","MO000418","4","PGD20250513000002","12","14","20","393","7140","report","正常报告","下午班","王小白")

TAGS中的数据也尝试过不加引号插入，但是不影响查询结果

[yu285]

收到，谢谢

[yu285]

升级到最新版即可，目前为3.3.7.5