Mycat 1.6日志分类-Insert 语句解析

Insert 语句解析

can't find table define in schema ${tableName}  schema:  ${schema}

调试:表名在schema中不存在

解决:更改SQL

 

partition table, insert must provide ColumnList

错误:insert语句没有column名

解决:更改SQL

 

joinKey not provided :${joinKey} ${插入语句}

错误:ER表插入需要提供joinKey

解决:更改SQL

 

ChildTable multi insert not provided

错误:ER表不支持多条插入

解决:更改SQL

 

find root parent's node sql ${ER表的父SQL}

调试:路由解析的SQL

解决:更改SQL

 

 

can't find (root) parent sharding node for sql:${insert sql}

调试:该SQL无法路由

 

found partion node for child table to insert ${dataNode} sql:${sql}

调试:路由解析的日志输出

 

bad insert sql (sharding column:${分片字段} not provided,${sql}

调试:该分片字段无法路由,分片字段没有提供

 

Sharding column can't be updated: ${tableName} -> ${partitionColumn}

调试:分片字段不能更新

 

bad insert sql (sharding column:${分片字段}  not provided,${插入SQL}

调试:找不到分片表

 

Sharding column can't be updated: ${表名} -> ${分片表}

调试:分片字段不能更新

 

bad insert sql columnSize != valueSize

调试:字段数量与值数量不匹配

 

can't find any valid datanode :${表名} -> ${partitionColumn}  -> {shardingValue}

错误:无法找到合法的SQL节点

解决:检查分片算法的数量

 

sub table not exists for ${dataNode} on ${表名}

调试:单库分表的表不在dataNode

解决:检查单库分表的dataNode名字

 

TODO:insert into .... select .... not supported!

调试:不支持TODO:insert into .... select .... 语句!

解决:改写SQL