Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug] 模糊查询 like 查询无法匹配所有满足条件的数据 #12253

Open
1 of 2 tasks
SunnySaman opened this issue Mar 29, 2024 · 3 comments
Open
1 of 2 tasks

[Bug] 模糊查询 like 查询无法匹配所有满足条件的数据 #12253

SunnySaman opened this issue Mar 29, 2024 · 3 comments

Comments

@SunnySaman
Copy link

Search before asking

  • I searched in the issues and found nothing similar.

Version

0.13.3

Describe the bug and provide the minimal reproduce step

如下所示，是两个查询，第一个查询有61行数据，查询内容中满足存在 AABB的字符串有29条数据；第二个查询使用like进行模糊匹配，却只查询到一条数据。
使用正则匹配是可以全部匹配到的。

IoTDB> select log_info from root.fz4.userlog.s_1.** where time>1711471299000000000 and time < 1711680099000000000 and subsystem_id in(13,85,86) order by time desc align by device;
+-----------------------------------+-----------------------------------------------+--------------------------------------------------------------------------+
|                               Time|                                         Device|                                                                  log_info|
+-----------------------------------+-----------------------------------------------+--------------------------------------------------------------------------+
|2024-03-29T10:14:07.497227652+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据站 ，所选设备执行命令全部失败，
  下发内容:停止命令|
|2024-03-29T10:13:01.245596353+08:00|                  root.fz4.userlog.s_1.userid_7|        上行,下行,站厅-自 测试数据站 ，停止命令下发错误，
  下发内容:停止命令|
|2024-03-29T10:12:17.015642895+08:00|                  root.fz4.userlog.s_1.userid_7|   上行,下行,站厅-自 测试数据 ，所选设备执行命令全部成功，
  下发内容:士大夫：|
|2024-03-29T09:13:46.813319841+08:00|                  root.fz4.userlog.s_1.userid_7|                           上行,下行-自 测试数据 ，反馈超时，
  下发内容:AABB|
|2024-03-28T17:09:56.545189930+08:00|                  root.fz4.userlog.s_1.userid_7|                     下行,站厅-自 测试数据站 ，反馈超时，
  下发内容:停止命令|
|2024-03-28T17:08:20.760339372+08:00|                  root.fz4.userlog.s_1.userid_7|                        下行,站厅-自 测试数据 ，反馈超时，
  下发内容:士大夫：|
|2024-03-28T17:07:07.184382465+08:00|                  root.fz4.userlog.s_1.userid_7|                        下行,站厅-自 测试数据 ，反馈超时，
  下发内容:士大夫：|
|2024-03-28T17:06:20.300855443+08:00|                  root.fz4.userlog.s_1.userid_7|                   上行,下行,站厅-自 测试数据 ，反馈超时，
  下发内容:士大夫：|
|2024-03-28T17:03:20.280334769+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，反馈超时，
  下发内容:AABB|
|2024-03-28T17:02:33.763913176+08:00|                  root.fz4.userlog.s_1.userid_7|                   上行,下行,站厅-自 测试数据 ，反馈超时，
  下发内容:士大夫：|
|2024-03-28T16:29:55.205594507+08:00|                  root.fz4.userlog.s_1.userid_7|                                              创建重复时间表任务"HHMM"成功|
|2024-03-28T16:29:00.074173398+08:00|                  root.fz4.userlog.s_1.userid_7|                                               创建重复时间表任务"HHH"成功|
|2024-03-28T16:19:14.465323205+08:00|                  root.fz4.userlog.s_1.userid_7|                                                               CEN自检成功|
|2024-03-28T16:19:14.411137161+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           CEN自检下发成功|
|2024-03-28T16:18:03.149670113+08:00|                  root.fz4.userlog.s_1.userid_7|                                                               CEN自检成功|
|2024-03-28T16:18:03.042466192+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           CEN自检下发成功|
|2024-03-28T16:06:52.715451239+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T16:06:47.608124521+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T16:02:59.280079380+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T16:02:24.086492516+08:00|                  root.fz4.userlog.s_1.userid_7|                   上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:士大夫：|
|2024-03-28T16:02:20.798119759+08:00|                  root.fz4.userlog.s_1.userid_7|                   上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:士大夫：|
|2024-03-28T16:02:02.434995674+08:00|                  root.fz4.userlog.s_1.userid_7|                   上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:士大夫：|
|2024-03-28T16:01:58.375793459+08:00|                  root.fz4.userlog.s_1.userid_7|                   上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:士大夫：|
|2024-03-28T16:01:55.683650803+08:00|                  root.fz4.userlog.s_1.userid_7|                   上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:士大夫：|
|2024-03-28T15:51:35.440728662+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:49:13.839724554+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:43:40.916188147+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:43:08.521880479+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:23:34.397710186+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                   上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:士大夫：|
|2024-03-28T15:22:50.226397573+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:09:36.032566710+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:07:05.573211240+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:04:32.990980908+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:01:47.436815548+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:00:56.081392780+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:58:41.836273644+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:58:37.652062127+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:55:47.337485077+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                                上行-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:50:09.986980347+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:48:51.860144939+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T13:35:20.873617920+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T13:34:10.621460125+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:31:22.055121872+08:00|                  root.fz4.userlog.s_1.userid_7|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:30:21.719589770+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:29:07.647480558+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:26:15.395542578+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:26:10.280628758+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:25:38.972641341+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                      上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:24:47.708807802+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                               编辑预录制信息"SSDFSSDDDD"成功,内容为:AABB"|
|2024-03-28T11:24:45.927589795+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|                                                           PIS下发审核成功|
|2024-03-28T10:21:10.110515722+08:00|                  root.fz4.userlog.s_1.userid_7|                     添加预录制信息"SSDFSSDDDD"成功,内容为:实打实打算SDSD"|
|2024-03-28T10:21:08.859026440+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
|2024-03-27T16:00:10.541922724+08:00|                  root.fz4.userlog.s_1.userid_7|                                上行-自 测试数据 ，下发错误，
  下发内容:还会|
|2024-03-27T16:00:09.446654123+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
|2024-03-27T15:59:49.087330272+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
|2024-03-27T15:58:26.345968261+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
|2024-03-27T15:58:21.861009871+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
|2024-03-27T15:55:46.319377359+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
|2024-03-27T15:55:21.499522030+08:00|                  root.fz4.userlog.s_1.userid_7|                              添加预录制信息"请问请问"成功,内容为:士大夫："|
|2024-03-27T15:55:18.156974500+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
|2024-03-27T15:53:21.126669691+08:00|                  root.fz4.userlog.s_1.userid_7|                                                           PIS下发审核成功|
+-----------------------------------+-----------------------------------------------+--------------------------------------------------------------------------+
Total line number = 61
It costs 0.021s
IoTDB> select log_info from root.fz4.userlog.s_1.** where time>1711471299000000000 and time < 1711680099000000000 and subsystem_id in(13,85,86) and log_info like '%AABB%' order by time desc align by device;
+-----------------------------------+-----------------------------------------------+-------------------------------------------+
|                               Time|                                         Device|                                   log_info|
+-----------------------------------+-----------------------------------------------+-------------------------------------------+
|2024-03-28T11:24:47.708807802+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|编辑预录制信息"SSDFSSDDDD"成功,内容为:AABB"|
+-----------------------------------+-----------------------------------------------+-------------------------------------------+
Total line number = 1
It costs 0.012s

IoTDB> select log_info from root.fz4.userlog.s_1.** where time>1711471299000000000 and time < 1711680099000000000 and subsystem_id in(13,85,86) and log_info regexp '^*AABB*' order by time desc align by device;
+-----------------------------------+-----------------------------------------------+----------------------------------------------------+
|                               Time|                                         Device|                                            log_info|
+-----------------------------------+-----------------------------------------------+----------------------------------------------------+
|2024-03-29T09:13:46.813319841+08:00|                  root.fz4.userlog.s_1.userid_7|     上行,下行-自 测试数据 ，反馈超时，
  下发内容:AABB|
|2024-03-28T17:03:20.280334769+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，反馈超时，
  下发内容:AABB|
|2024-03-28T16:06:52.715451239+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T16:06:47.608124521+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T16:02:59.280079380+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:51:35.440728662+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:49:13.839724554+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:43:40.916188147+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:43:08.521880479+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:22:50.226397573+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:09:36.032566710+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:07:05.573211240+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:04:32.990980908+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:01:47.436815548+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T15:00:56.081392780+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:58:41.836273644+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:58:37.652062127+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:55:47.337485077+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|          上行-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:50:09.986980347+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T14:48:51.860144939+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T13:35:20.873617920+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T13:34:10.621460125+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:31:22.055121872+08:00|                  root.fz4.userlog.s_1.userid_7|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:30:21.719589770+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:29:07.647480558+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:26:15.395542578+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:26:10.280628758+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:25:38.972641341+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|上行,下行,站厅-自 测试数据 ，下发错误，
  下发内容:AABB|
|2024-03-28T11:24:47.708807802+08:00|root.fz4.userlog.s_1.userid_1682975766379429888|         编辑预录制信息"SSDFSSDDDD"成功,内容为:AABB"|
+-----------------------------------+-----------------------------------------------+----------------------------------------------------+
Total line number = 29

What did you expect to see?

同上

What did you see instead?

同上

Anything else?

No response

Are you willing to submit a PR?

  • I'm willing to submit a PR!
@SunnySaman
Copy link
Author

我没有测试0.13.4以及1.0之后的版本，希望你们自己测试一下

@SunnySaman
Copy link
Author

v0.13.3, v1.3.0版本发现使用正则匹配 特殊字符 时 匹配结果不准确

IoTDB> select log_info from root.fz4.di where log_info like '%~%' align by device ;
+------------------------------+-----------+--------+
|                          Time|     Device|log_info|
+------------------------------+-----------+--------+
|2024-04-01T06:29:50.693051973Z|root.fz4.di|  ces~hi|
+------------------------------+-----------+--------+
Total line number = 1
It costs 0.009s

IoTDB> select log_info from root.fz4.di where log_info regexp '^*~*' align by device ;
+------------------------------+-----------+--------+
|                          Time|     Device|log_info|
+------------------------------+-----------+--------+
|2024-04-01T06:29:45.790086438Z|root.fz4.di|   ceshi|
|2024-04-01T06:29:50.693051973Z|root.fz4.di|  ces~hi|
+------------------------------+-----------+--------+
Total line number = 2
It costs 0.009s

@SunnySaman
Copy link
Author

@qiaojialin 乔老师，正则匹配不支持特殊字符嘛？

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@SunnySaman