You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/04/29 03:54:15 UTC

[GitHub] [shardingsphere] carlyin0801 opened a new issue, #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

carlyin0801 opened a new issue, #17198:
URL: https://github.com/apache/shardingsphere/issues/17198

   hi ,I am using version 5.0.0， In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql.
   
   2022-04-29 11:45:55.634|biz-6f32770874f04555a58353f335304281||SQLLogger.java|74|INFO||||||[XNIO-1 task-1] Logic SQL: insert into `t_pipeline_info` (`PIPELINE_ID`, `PROJECT_ID`, `PIPELINE_NAME`, `PIPELINE_DESC`) values (?, ?, ?, ?) on duplicate key update `t_pipeline_info`.`PIPELINE_DESC` = ?
   2022-04-29 11:45:55.634|biz-6f32770874f04555a58353f335304281||SQLLogger.java|74|INFO||||||[XNIO-1 task-1] SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.column.OnDuplicateKeyColumnsSegment@4e2038b4])
   2022-04-29 11:45:55.634|biz-6f32770874f04555a58353f335304281||SQLLogger.java|74|INFO||||||[XNIO-1 task-1] Actual SQL: ds_0 ::: insert into `t_pipeline_info_0` (`PIPELINE_ID`, `PROJECT_ID`, `PIPELINE_NAME`, `PIPELINE_DESC`) values (?, ?, ?, ?) on duplicate key update `t_pipeline_info`.`PIPELINE_DESC` = ? ::: [p-17bd8ac017dsfsd1f, devops0, bnmvvv123dsfdf, 232323yui, 232323yui]
   2022-04-29 11:45:55.669|biz-6f32770874f04555a58353f335304281||RuntimeExceptionMapper.kt|47|ERROR||||||[XNIO-1 task-1] Failed with runtime exception org.jooq.exception.DataAccessException: SQL [insert into `t_pipeline_info` (`PIPELINE_ID`, `PROJECT_ID`, `PIPELINE_NAME`, `PIPELINE_DESC`) values (?, ?, ?, ?) on duplicate key update `t_pipeline_info`.`PIPELINE_DESC` = ?]; Unknown column 't_pipeline_info.PIPELINE_DESC' in 'field list'
   	at org.jooq_3.14.7.MYSQL.debug(Unknown Source)
   	at org.jooq.impl.Tools.translate(Tools.java:2880)
   


-- 
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.apache.org

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

[GitHub] [shardingsphere] cheese8 commented on issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #17198:
URL: https://github.com/apache/shardingsphere/issues/17198#issuecomment-1113971229

   Assign it to me? thanks @strongduanmu 


-- 
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

[GitHub] [shardingsphere] carlyin0801 commented on issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
carlyin0801 commented on issue #17198:
URL: https://github.com/apache/shardingsphere/issues/17198#issuecomment-1112921830

   The issue template has been updated, please take a look


-- 
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

[GitHub] [shardingsphere] strongduanmu commented on issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17198:
URL: https://github.com/apache/shardingsphere/issues/17198#issuecomment-1112912062

   @carlyin0801 Please submit issue with bug template.


-- 
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

[GitHub] [shardingsphere] carlyin0801 commented on issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
carlyin0801 commented on issue #17198:
URL: https://github.com/apache/shardingsphere/issues/17198#issuecomment-1112991503

   configuration:
   "ds_\${0..1}.t_pipeline_info_\${0..1}"
   
   table init sql:
   CREATE TABLE `t_pipeline_info_0` (
     `PIPELINE_ID` varchar(34) NOT NULL DEFAULT '' COMMENT '流水线ID （P-32位UUID)=34位',
     `PROJECT_ID` varchar(64) NOT NULL COMMENT '项目ID',
     `PIPELINE_NAME` varchar(255) NOT NULL COMMENT '名称',
     `PIPELINE_DESC` varchar(255) DEFAULT NULL COMMENT '描述',
     PRIMARY KEY (`PIPELINE_ID`),
     UNIQUE KEY `T_PIPELINE_INFO_NAME_uindex` (`PROJECT_ID`,`PIPELINE_NAME`),
     KEY `PROJECT_ID` (`PROJECT_ID`,`PIPELINE_ID`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='流水线定义表';
   
   CREATE TABLE `t_pipeline_info_1` (
     `PIPELINE_ID` varchar(34) NOT NULL DEFAULT '' COMMENT '流水线ID （P-32位UUID)=34位',
     `PROJECT_ID` varchar(64) NOT NULL COMMENT '项目ID',
     `PIPELINE_NAME` varchar(255) NOT NULL COMMENT '名称',
     `PIPELINE_DESC` varchar(255) DEFAULT NULL COMMENT '描述',
     PRIMARY KEY (`PIPELINE_ID`),
     UNIQUE KEY `T_PIPELINE_INFO_NAME_uindex` (`PROJECT_ID`,`PIPELINE_NAME`),
     KEY `PROJECT_ID` (`PROJECT_ID`,`PIPELINE_ID`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='流水线定义表';
   


-- 
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

[GitHub] [shardingsphere] carlyin0801 commented on issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
carlyin0801 commented on issue #17198:
URL: https://github.com/apache/shardingsphere/issues/17198#issuecomment-1112853282

   @strongduanmu hi, can you please take a look


-- 
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

[GitHub] [shardingsphere] strongduanmu commented on issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17198:
URL: https://github.com/apache/shardingsphere/issues/17198#issuecomment-1113976253

   @cheese8 Welcome, I just assign this issue to you.


-- 
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

[GitHub] [shardingsphere] strongduanmu closed issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #17198:  In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql
URL: https://github.com/apache/shardingsphere/issues/17198


-- 
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

[GitHub] [shardingsphere] strongduanmu commented on issue #17198: In the case of sub-tables, if the sql contains on duplicate key update, it will cause an error in the actually generated sql

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17198:
URL: https://github.com/apache/shardingsphere/issues/17198#issuecomment-1112957296

   > @strongduanmu The issue template has been updated, please take a look
   
   Please add your sharding configuration, and table init sql.


-- 
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