lance6716
some old discussions https://github.com/pingcap/tiflow/issues/10160 . The known issues are all labeled with "MariaDB"
A DM worker may replicate to different TiDB cluster with different password. And I'm not sure if environment variables are loaded at process start. If so, when need to change...
there's "in schema tracker" in error message. It means it's not caused by downstream TiDB, but DM's embedded TiDB component. /cc @OliverS929
Note that change to `DEFAULT (_utf8mb4'')` still can't parse ``` ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version...
Can reproduce in v8.5.4. The panic stack is ``` github.com/pingcap/tidb/pkg/server.(*clientConn).Run.func1 /Users/pingcap/workspace/bp-tidb-release-darwin-arm64-7vzg8-build-binaries/source/tidb/pkg/server/conn.go:1045 runtime.gopanic /Users/pingcap/go/pkg/mod/golang.org/[email protected]/src/runtime/panic.go:785 github.com/pingcap/tidb/pkg/executor.(*Compiler).Compile.func1 /Users/pingcap/workspace/bp-tidb-release-darwin-arm64-7vzg8-build-binaries/source/tidb/pkg/executor/compiler.go:59 runtime.gopanic /Users/pingcap/go/pkg/mod/golang.org/[email protected]/src/runtime/panic.go:785 runtime.goPanicIndex /Users/pingcap/go/pkg/mod/golang.org/[email protected]/src/runtime/panic.go:115 github.com/pingcap/tidb/pkg/planner/core.(*expressionRewriter).inToExpression /Users/pingcap/workspace/bp-tidb-release-darwin-arm64-7vzg8-build-binaries/source/tidb/pkg/planner/core/expression_rewriter.go:1925 github.com/pingcap/tidb/pkg/planner/core.(*expressionRewriter).Leave /Users/pingcap/workspace/bp-tidb-release-darwin-arm64-7vzg8-build-binaries/source/tidb/pkg/planner/core/expression_rewriter.go:1571 github.com/pingcap/tidb/pkg/parser/ast.(*PatternInExpr).Accept /Users/pingcap/workspace/bp-tidb-release-darwin-arm64-7vzg8-build-binaries/source/tidb/pkg/parser/ast/expressions.go:777 github.com/pingcap/tidb/pkg/planner/core.rewriteExprNode /Users/pingcap/workspace/bp-tidb-release-darwin-arm64-7vzg8-build-binaries/source/tidb/pkg/planner/core/expression_rewriter.go:301 github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).rewriteWithPreprocess /Users/pingcap/workspace/bp-tidb-release-darwin-arm64-7vzg8-build-binaries/source/tidb/pkg/planner/core/expression_rewriter.go:239 github.com/pingcap/tidb/pkg/planner/core.(*PlanBuilder).rewrite...
PTAL @GMHDBJD @D3Hunter
Oh, the document needs to be improved to specify the order of 3 columns https://docs.pingcap.com/zh/tidb/stable/dm-table-routing/#%E9%85%8D%E7%BD%AE%E8%A1%A8%E8%B7%AF%E7%94%B1 > 合表需要包含用于存放分表源数据信息的三个扩展列 target-column （表名列、库名列、数据源列），扩展列必须为表末尾列且必须为[字符串类型](https://docs.pingcap.com/zh/tidb/stable/data-type-string/) https://docs.pingcap.com/tidb/stable/dm-table-routing/#extract-table-schema-and-source-information-and-write-into-the-merged-table > The merged table must contain the three target-columns (c_table,...