query table partition data table alias issue #33199
Replies: 5 comments
-
Hello @travelliu Sorry, what you are doing is not clear. |
Beta Was this translation helpful? Give feedback.
-
@travelliu could you share the way to reproduce the issue? |
Beta Was this translation helpful? Give feedback.
-
No. I just see that the SQL statement generated by this code is not logically correct. appendExtraSelectParameters Functions now seem to just add partition syntax |
Beta Was this translation helpful? Give feedback.
-
@hallstorm it's not connected to this issue |
Beta Was this translation helpful? Give feedback.
-
We don't add aliases when building select from partition |
Beta Was this translation helpful? Give feedback.
-
Description
SELECT x.* FROM public.newtable_1 PARTITION(part_1) x --> correct
SELECT x.* FROM public.newtable_1 x PARTITION(part_1) error
so
https://github.com/dbeaver/dbeaver/blob/107958e9d1f3e1b181c554d472a16c20cb1dc6e3/plugins/org.jkiss.dbeaver.model.jdbc/src/org/jkiss/dbeaver/model/impl/jdbc/struct/JDBCTable.java#L157C1-L166C78
need change to
DBeaver Version
23.3.0
Operating System
No response
Database and driver
No response
Steps to reproduce
No response
Additional context
No response
Beta Was this translation helpful? Give feedback.
All reactions