ERROR1138(22004) : Invalid use of NULL value 示例 创建tny表,创建完成后修改id字段的属性及设置非空的时候,报空值的使用无效错误。 obclient> CREATE TABLE tny ( id DECIMAL COMMENT '主键', trade_no VARCHAR(64), channel VARCHAR(2) ); Query OK, 0 rows affected obclient> DESC tny; +---+-...
MySQL [test]> alter table t1 modify column `id` varchar(32); ERROR 1235 (0A000): Truncate the data of column schema not supported 暂不支持添加非空约束。 MySQL [test]> alter table t1 modify column `id` varchar(64) not null; ERROR 1138 (22004): Invalid use of NULL value 暂不支持...
MySQL [test]> alter table test modify column `id` varchar(10) not null; ERROR 1138 (22004): Invalid use of NULL value 【复现路径】问题出现前后相关操作 【附件及日志】
519S1004HY004Invalid SQL data type 520S1009HY009Invalid use of null pointer 521S1010HY010Function sequence error 522S1011HY011Attribute can not be set now 523S1012HY012Invalid transaction operation code 524S1013HY013Memory management error ...
Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone3 | observer | 192.169.4.163 | 2882 | syslog_io_bandwidth_limit | NULL | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | ...
Example of data insertion (INSERT) { "allMetaData":{ "checkpoint":null, "record_primary_key":"id1\u0001id2", "source_identity":null, "record_primary_value":"3\u0001129", "dbType":"OB_MYSQL", "table_name":"table_name", "db":"tenant.database", "timestamp":"1609344671" }, "...
观察到最开始抛出错误的是 int_to_ob_time_with_date 方法,报的错是 “datetime is invalid or out of range(ret=-4219, int64=0)”,即值无效或超过范围。 这里UPDATE 的调用链路是: common_int_datetime -> int_to_datetime -> int_to_ob_time_with_date...
} else if (int64 < power_of_10[2]) { ret = OB_INVALID_DATE_VALUE; LOG_WARN("datetime integer is out of range", K(ret), K(int64)); } else if (int64 < power_of_10[8]) { // YYYYMMDD. parts[DT_MDAY] = static_cast<int32_t>(int64 % power_of_10[2]); int64 /= power...
(int64 % power_of_10[2]); int64 /= power_of_10[2]; parts[DT_MON] = static_cast<int32_t>(int64 % power_of_10[2]); int64 /= power_of_10[2]; parts[DT_YEAR] = static_cast<int32_t>(int64 % power_of_10[4]); } else { ret = OB_INVALID_DATE_VALUE; LOG_WARN("...
Fix the new protocol, refcursor cannot get the value when there are other out parameters Fix obproxy core at oceanbase::common::ObObjCmpFuncs::compare null safe Fix obproxy core at oceanbase::common::ObTimeConverter::str_to_digit_with_date ...