Doris Error：修订间差异
跳到导航
跳到搜索
（创建页面，内容为“==== Right expr of binary predicate should be value ==== 删除数据时，右侧不支持表达式。如： DELETE FROM test WHERE part = abs( murmur_hash3_32 ('42cbd45b-f03b-4840-bdb0-965238c4c07c') % 10) --> DELETE FROM test WHERE part = 0 ==== 空值 ==== INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), '') --> INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), NULL)”） |
无编辑摘要 |
||
| （未显示同一用户的2个中间版本） | |||
| 第1行： | 第1行： | ||
==== Right expr of binary predicate should be value ==== | ==== [1105] Right expr of binary predicate should be value ==== | ||
删除数据时，右侧不支持表达式。如： | 删除数据时，右侧不支持表达式。如： | ||
DELETE FROM test WHERE part = abs( murmur_hash3_32 ('42cbd45b-f03b-4840-bdb0-965238c4c07c') % 10) | DELETE FROM test WHERE part = abs( murmur_hash3_32 ('42cbd45b-f03b-4840-bdb0-965238c4c07c') % 10) | ||
| 第5行： | 第5行： | ||
DELETE FROM test WHERE part = 0 | DELETE FROM test WHERE part = 0 | ||
==== | ==== [1105] Table[XXX]'s state is not NORMAL. Do not allow doing ALTER ops ==== | ||
表的状态不正常，不允许执行 alter 操作。如一个表同时只能进行一个 Alter 任务，多个 alter 执行或连续执行就会报此错误。 | |||
一般不用特别处理，等下再执行即可。 | |||
==== [5025] Insert has filtered data in strict mode ==== | |||
空值不支持 ''，改为 NULL | |||
INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), '') | INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), '') | ||
--> | --> | ||
INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), NULL) | INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), NULL) | ||
[[分类:Develop]] | |||
[[分类:DB]] | |||
[[分类:Doris]] | |||
2023年12月12日 (二) 12:11的最新版本
[1105] Right expr of binary predicate should be value
删除数据时，右侧不支持表达式。如：
DELETE FROM test WHERE part = abs( murmur_hash3_32 ('42cbd45b-f03b-4840-bdb0-965238c4c07c') % 10)
-->
DELETE FROM test WHERE part = 0
[1105] Table[XXX]'s state is not NORMAL. Do not allow doing ALTER ops
表的状态不正常，不允许执行 alter 操作。如一个表同时只能进行一个 Alter 任务，多个 alter 执行或连续执行就会报此错误。
一般不用特别处理，等下再执行即可。
[5025] Insert has filtered data in strict mode
空值不支持 ，改为 NULL
INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), )
-->
INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), NULL)