Skip to content
New issue

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

[Bug report] jdbc-postgresql/00004_query_pushdown.sql under catalog pg failed. #3929

Closed
danhuawang opened this issue Jun 21, 2024 · 0 comments · Fixed by #4419
Closed

[Bug report] jdbc-postgresql/00004_query_pushdown.sql under catalog pg failed. #3929

danhuawang opened this issue Jun 21, 2024 · 0 comments · Fixed by #4419
Assignees
Labels
0.6.0 Release v0.6.0 bug Something isn't working

Comments

@danhuawang
Copy link
Contributor

Version

main branch

Describe what's wrong

pg:jdbc-postgresql/00004_query_pushdown.sql, FAIL, 7.305, Execute sql in the tester jdbc-postgresql/00004_query_pushdown.sql under catalog pg failed.

Error message and/or stacktrace

pg:jdbc-postgresql/00004_query_pushdown.sql, FAIL, 7.305, Execute sql in the tester jdbc-postgresql/00004_query_pushdown.sql under catalog pg failed.
Sql:
explain select customer.custkey, orders.orderkey from customer join orders on customer.custkey = orders.custkey order by orders.orderkey limit 10;
Expect:
"Trino version: %
%
TableScan[table = gt_postgresql:gt_db1.orders->Query[SELECT % INNER JOIN %] limit=10 columns=%]
%
"
Actual:
"Trino version: 435
Fragment 0 [SINGLE]
Output layout: [custkey, orderkey]
Output partitioning: SINGLE []
Output[columnNames = [custkey, orderkey]]
│ Layout: [custkey:bigint, orderkey:bigint]
│ Estimates: {rows: 10 (180B), cpu: 0, memory: 0B, network: 0B}
└─ TopN[count = 10, orderBy = [orderkey ASC NULLS LAST]]
│ Layout: [custkey:bigint, orderkey:bigint]
│ Estimates: {rows: 10 (180B), cpu: ?, memory: ?, network: ?}
└─ LocalExchange[partitioning = SINGLE]
│ Layout: [custkey:bigint, orderkey:bigint]
│ Estimates: {rows: ? (?), cpu: 0, memory: 0B, network: 0B}
└─ RemoteSource[sourceFragmentIds = [1]]
Layout: [custkey:bigint, orderkey:bigint]

Fragment 1 [SOURCE]
Output layout: [custkey, orderkey]
Output partitioning: SINGLE []
TableScan[table = gt_postgresql:gt_db1.customer->Query[SELECT l.""custkey"" AS ""custkey_0"", r.""orderkey"" AS ""orderkey_1"", r.""custkey"" AS ""custkey_2"" FROM (SELECT ""custkey"" FROM ""gt_db1"".""customer"") l INNER JOIN (SELECT ""orderkey"", ""custkey"" FROM ""gt_db1"".""orders"") r ON l.""custkey"" = r.""custkey""] sortOrder=[orderkey_1:bigint:int8 ASC NULLS LAST] limit=10 columns=[orderkey_1:bigint:int8, custkey_0:bigint:int8]]
Layout: [custkey:bigint, orderkey:bigint]
Estimates: {rows: ? (?), cpu: ?, memory: 0B, network: 0B}
orderkey := orderkey_1->orderkey_1:bigint:int8
custkey := custkey_0->custkey_0:bigint:int8

"

How to reproduce

https://github.com/datastrato/gravitino-test/actions/workflows/test-on-eks.yml

Additional context

No response

@danhuawang danhuawang added the bug Something isn't working label Jun 21, 2024
@jerryshao jerryshao added the 0.6.0 Release v0.6.0 label Aug 1, 2024
github-actions bot pushed a commit that referenced this issue Aug 8, 2024
…hdown.sql under catalog pg failed (#4419)

### What changes were proposed in this pull request?

Fix the jdbc-postgresql/00004_query_pushdown.sql under catalog pg
failed. Because the explain result of the join query has random left and
right table.

### Why are the changes needed?

Fix: #3929

### Does this PR introduce _any_ user-facing change?

NO

### How was this patch tested?

Exist testers
yuqi1129 pushed a commit that referenced this issue Aug 8, 2024
…hdown.sql under catalog pg failed (#4434)

### What changes were proposed in this pull request?

Fix the jdbc-postgresql/00004_query_pushdown.sql under catalog pg
failed. Because the explain result of the join query has random left and
right table.

### Why are the changes needed?

Fix: #3929

### Does this PR introduce _any_ user-facing change?

NO

### How was this patch tested?

Exist testers

Co-authored-by: Yuhui <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0.6.0 Release v0.6.0 bug Something isn't working
Projects
None yet
3 participants