[GitHub] [shardingsphere] liaojiexin commented on issue #25182: I use shardingsphere-proxy to migrate data, but it seems that some tables do not take effect

["liaojiexin (via GitHub)" <gi...@apache.org>]

liaojiexin commented on issue #25182:
URL: https://github.com/apache/shardingsphere/issues/25182#issuecomment-1518580979

   > Thanks for feedback @liaojiexin The first problem need to see the output error log of the Proxy (the problem fixed at the master now, you can see the really errror reason). The second problem, can you provide create table SQL, help me try to reproduce the problem
   
   ```sql
   create table ds_attach_segment
   (
   	userid varchar(100) not null,
   	md5 varchar(1000) not null,
   	filename varchar(500),
   	createtime timestamp(6),
   	filepath varchar(1000) not null,
   	partcount integer not null,
   	uuid varchar(400) not null,
   	isdelete boolean default false not null,
   	length bigint,
   	sid varchar(40) not null
   		constraint ds_attach_segment_pk
   			primary key
   );
   
   comment on table ds_attach_segment is '存储断点续传文件分片信息';
   
   comment on column ds_attach_segment.userid is '上传人id';
   
   comment on column ds_attach_segment.md5 is '文件md5标记（唯一性）';
   
   comment on column ds_attach_segment.filename is '文件名';
   
   comment on column ds_attach_segment.createtime is '分片生成时间';
   
   comment on column ds_attach_segment.filepath is '碎片文件存储路径';
   
   comment on column ds_attach_segment.partcount is '分片数量';
   
   comment on column ds_attach_segment.uuid is 'uuid唯一标识符';
   
   comment on column ds_attach_segment.isdelete is '是否删除';
   
   comment on column ds_attach_segment.length is '文件长度';
   
   comment on column ds_attach_segment.sid is '主键id';
   
   alter table ds_attach_segment owner to postgres;
   
   create index ds_attach_segment_md5_index
   	on ds_attach_segment (md5);
   
   create index ds_attach_segment_userid_index
   	on ds_attach_segment (userid);
   
   create index ds_attach_segment_uuid_index
   	on ds_attach_segment (uuid);
   ```
   ```sql
   create table ds_attach_extend
   (
   	id varchar(50) not null
   		constraint ds_attach_extend_pkey
   			primary key,
   	nid varchar(50),
   	bimid varchar(50),
   	flowid varchar(50),
   	confine_size bigint default 0,
   	confine_ext varchar(1000) default '*'::character varying,
   	confine_kind smallint,
   	create_time timestamp(6),
   	update_time timestamp(6),
   	user_id varchar(50) not null,
   	total_size numeric(20),
   	template_id varchar(50),
   	imagespath varchar(200)
   );
   
   comment on table ds_attach_extend is '附件拓展表';
   
   comment on column ds_attach_extend.id is '文件拓展表ID';
   
   comment on column ds_attach_extend.nid is '文件NID';
   
   comment on column ds_attach_extend.bimid is '业务ID';
   
   comment on column ds_attach_extend.flowid is '流程界定ID';
   
   comment on column ds_attach_extend.confine_size is '限制大小(单位byte)';
   
   comment on column ds_attach_extend.confine_ext is '限制拓展名';
   
   comment on column ds_attach_extend.confine_kind is '限制类型';
   
   comment on column ds_attach_extend.create_time is '创建时间';
   
   comment on column ds_attach_extend.update_time is '更新时间';
   
   comment on column ds_attach_extend.user_id is '用户ID';
   
   comment on column ds_attach_extend.total_size is '总大小';
   
   comment on column ds_attach_extend.template_id is '模板ID';
   
   comment on column ds_attach_extend.imagespath is '图片路径(备用字段)';
   
   alter table ds_attach_extend owner to postgres;
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org