We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Please answer these questions before submitting your issue. Thanks!
The query is compiled successfully.
It throws an error Can't find column Column#40 in schema Column .
Can't find column Column#40 in schema Column
[2023/03/06 19:06:04.794 +08:00] [INFO] [conn.go:1158] ["command dispatched failed"] [conn=1362983201093452183] [connInfo="id:1362983201093452183, addr:127.0.0.1:65448 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT repo_id, GROUP_CONCAT( DISTINCT actor_login ORDER BY cnt DESC SEPARATOR ',' ) AS actor_logins FROM ( SELECT ge.repo_id AS repo_id, ge.actor_login AS actor_login, COUNT(*) AS cnt FROM github_events ge WHERE type = 'PullRequestEvent' AND action = 'opened' AND (ge.created_at >= DATE_SUB(NOW(), INTERVAL 1 DAY) AND ge.created_at <= NOW()) GROUP BY ge.repo_id, ge.actor_login ORDER BY cnt DESC ) sub GROUP BY repo_id"] [txn_mode=PESSIMISTIC] [timestamp=0] [err="Can't find column Column#40 in schema Column: [Column#37,gharchive_dev.github_events.repo_id,gharchive_dev.github_events.actor_login] Unique key: [[gharchive_dev.github_events.repo_id,gharchive_dev.github_events.actor_login]] github.com/pingcap/tidb/expression.(*Column).resolveIndices /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/expression/column.go:534 github.com/pingcap/tidb/expression.(*Column).ResolveIndices /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/expression/column.go:527 github.com/pingcap/tidb/planner/core.(*basePhysicalAgg).ResolveIndices /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:428 github.com/pingcap/tidb/planner/core.(*basePhysicalPlan).ResolveIndices /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:710 github.com/pingcap/tidb/planner/core.(*physicalSchemaProducer).ResolveIndices /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:699 github.com/pingcap/tidb/planner/core.(*PhysicalProjection).ResolveIndices /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:42 github.com/pingcap/tidb/planner/core.physicalOptimize /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/optimizer.go:1117 github.com/pingcap/tidb/planner/core.DoOptimize /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/optimizer.go:299 github.com/pingcap/tidb/planner.optimize /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:436 github.com/pingcap/tidb/planner.Optimize /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:264 github.com/pingcap/tidb/executor.(*Compiler).Compile /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/executor/compiler.go:112 github.com/pingcap/tidb/session.(*session).ExecuteStmt /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2161 github.com/pingcap/tidb/server.(*TiDBContext).ExecuteStmt /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:247 github.com/pingcap/tidb/server.(*clientConn).handleStmt /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1999 github.com/pingcap/tidb/server.(*clientConn).handleQuery /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1849 github.com/pingcap/tidb/server.(*clientConn).dispatch /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1380 github.com/pingcap/tidb/server.(*clientConn).Run /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1129 github.com/pingcap/tidb/server.(*Server).onConn /Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:625 runtime.goexit /usr/local/go1.19.5/src/runtime/asm_amd64.s:1594"]
v6.6.0
The text was updated successfully, but these errors were encountered:
planner: fix group concat projection elimination logic (#47612)
6e38182
close #41957
planner: fix group concat projection elimination logic (#47612) (#47628)
f628f52
planner: fix group concat projection elimination logic (pingcap#47612)
0abb675
close pingcap#41957
AilinKid
Successfully merging a pull request may close this issue.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
The query is compiled successfully.
3. What did you see instead (Required)
It throws an error
Can't find column Column#40 in schema Column
.4. What is your TiDB version? (Required)
v6.6.0
The text was updated successfully, but these errors were encountered: