MyCATApache/Mycat-Server

mycat ChildTable multi insert not provided

Open

#2,794 opened on May 24, 2021

View on GitHub
 (5 comments) (0 reactions) (0 assignees)Java (3,886 forks)batch import
help wantedtodo

Repository metrics

Stars
 (9,451 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

**描述你使用过程中遇到的问题: ** mycat 是否支持子表的批量插入，批量插入方式为insert into table values('a','b'),('a','b'),('a','b')一条sql多个值的形式，其中包含分片字段，当批量插入子表的数据的时候报java.sql.SQLSyntaxErrorException: ChildTable multi insert not provided image

Contributor guide

Research direction
Inspect the insert handling code in the child table routing logic, specifically the method that throws 'ChildTable multi insert not provided', and add support for multi value INSERT statements.
Tech stack
javasql
Domain
backenddatabase
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
JavaSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40