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.

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

clob字段更新为null时报错 #218

Closed
ContyChen opened this issue Dec 29, 2023 · 1 comment
Closed

clob字段更新为null时报错 #218

ContyChen opened this issue Dec 29, 2023 · 1 comment

Comments

@ContyChen
Copy link

ContyChen commented Dec 29, 2023

更新clob类型字段为null时会报错,sql如下:

CREATE TABLE xxl_job_group (
  id bigint NOT NULL AUTO_INCREMENT,
  app_name varchar(64) NOT NULL COMMENT '执行器AppName',
  title varchar(12) NOT NULL COMMENT '执行器名称',
  address_type tinyint NOT NULL DEFAULT 0 COMMENT '执行器地址类型:0=自动注册、1=手动录入',
  address_list clob COMMENT '执行器地址列表,多地址逗号分隔',
  update_time datetime DEFAULT NULL,
  CONSTRAINT pk_xxl_job_group PRIMARY KEY (id)
);

INSERT INTO xxl_job_group(id, app_name, title, address_type, address_list, update_time) VALUES (1, 'xxl-job-executor', '示例执行器', 0, NULL, '2018-11-03 22:21:31' );

UPDATE xxl_job_group SET app_name = 'xxl-job-executor', title = '示例执行器', address_type = '0', address_list ='http://172.22.128.1:9999/', update_time = '2023-12-21 14:36:39' WHERE id = 1;

UPDATE xxl_job_group SET app_name = 'xxl-job-executor', title = '示例执行器',  address_type = 0,  address_list = null, 			update_time = '2023-12-29 20:20:57'  WHERE id = 1 ;

 SQL 错误 [50000] [HY000]: General error: "java.lang.NullPointerException: Cannot invoke ""org.lealone.db.value.ValueLob.link(org.lealone.db.DataHandler, int)"" because ""v"" is null";
@codefollower
Copy link
Member

已修复,感谢报告 bug。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants