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)”） |
无编辑摘要 |
||
| 第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 | ||
==== | ==== [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) | ||
2023年12月5日 (二) 16:57的版本
[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
[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)