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
Create Table as Select .... [CORE796] #1181
Comments
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Commented by: lacak (lacak) SQL 2003: |
Modified by: @pcisarWorkflow: jira [ 10820 ] => Firebird [ 15201 ] |
Commented by: Umberto Masotti (umasotti) Would be nice to have also CREATE [TEMPORARY] TABLE <table name> [(<column name list>)] The version WITH DATA means a starting point to be materialized on first access (why elaborate it if don't used?) and discarded at commit or disconnection. In some way resemble the ClientDataSet clone() command. In this case <subquery> can have filtering parameters? If first access is forced to be a SELECT ... FROM TEMP_TABLE_WITH_DATA ( <params list> ) like selectable stored procedures, this will create a subset to work with. From the engine POV maybe there is no difference, but developer hasn't to filter every access. |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] => |
Commented by: Lukas Eder (lukas.eder) I think it is worth mentioning that among the 16 RDBMS currently supported by jOOQ, 15 support this statement or an equivalent one: SELECT ... INTO table FROM ... is supported by: - HSQLDB CREATE TABLE AS SELECT ... is supported by: - CUBRID |
Submitted by: @pcisar
Votes: 30
SFID: 807931#
Submitted By: pcisar
Submitted by mailto:nick@upsonuk.com
I'd love to see "create table as select ...." as
Ingres does.
The text was updated successfully, but these errors were encountered: