Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 327065

Summary:

MaxDB: Allow creating temporary tables with PK columns only

Product:

z_Archived

Reporter:

Adrian Goerler <adrian.goerler>

Component:

Eclipselink

Assignee:

Adrian Goerler <adrian.goerler>

Status:

RESOLVED FIXED

QA Contact:

Severity:

normal

Priority:

CC:

andreas.fischbach, eclipselink.incubator-inbox, krum.tsvetkov, sabine.heider

Version:

unspecified

Target Milestone:

---

Hardware:

OS:

Windows XP

Whiteboard:

maxdb

Bug Depends on:

Bug Blocks:

284657

Attachments:

Description	Flags
proposed patch	none

Description Adrian Goerler

2010-10-06 02:58:03 EDT

EclipseLink sometimes creates a temporary table to avoid a "self-modifying subquery". This temporary typed like an existing table. Sometimes, however, only the PK columns are needed. 

So far, MaxDB uses a 

CREATE TABLE <temp> LIKE <existing>

statement. However, this techinique does not allow to restrict to the PK columns only.

Comment 1 Adrian Goerler

2010-10-06 03:36:26 EDT

Created attachment 180297 [details]
proposed patch

Tested on MaxDB.
Checked in at 8320.

Comment 2 Adrian Goerler

2010-10-06 04:29:34 EDT

Fixes the issues with 

JUnitJPQLExamplesTestSuite 
.testDeleteExpression 
.testComplexDeleteExpression

Comment 3 Eclipse Webmaster

2022-06-09 10:02:43 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink