Attachment 224555 Details for Bug 396259 – Support for local temporary tables in SAP HANA database

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

[patch] Support for local temporary tables in SAP HANA database

0001-HANAPlatform-Add-support-for-local-temporary-tables.patch (text/plain), 3.58 KB, created by Sabine Heider

on 2012-12-11 05:23:31 EST

(hide)

Description:

Filename:

MIME Type:

Creator: Sabine Heider

Created: 2012-12-11 05:23:31 EST

Size: 3.58 KB

patch

obsolete

>From 71bdc2fd220008ea2f8141983892c587571127ed Mon Sep 17 00:00:00 2001
>From: Sabine Heider <sabine.heider@sap.com>
>Date: Wed, 19 Sep 2012 11:08:11 +0200
>Subject: [PATCH] HANAPlatform: Add support for local temporary tables
>
>- Bug TBD
>- Local temporary tables introduced in HANAPlatform
>- Ant build file changed to allow merging of compiled HANAPlatform into
>main eclipselink.jar
>
>Signed-off-by: Sabine Heider <sabine.heider@sap.com>
>---
> .../org.eclipse.persistence.platform.database.hana/build.xml |  4 ++++
> .../eclipse/persistence/platform/database/HANAPlatform.java  | 12 +++++++++---
> 2 files changed, 13 insertions(+), 3 deletions(-)
>
>diff --git a/extensions/org.eclipse.persistence.platform.database.hana/build.xml b/extensions/org.eclipse.persistence.platform.database.hana/build.xml
>index de4f84e..f112910 100644
>--- a/extensions/org.eclipse.persistence.platform.database.hana/build.xml
>+++ b/extensions/org.eclipse.persistence.platform.database.hana/build.xml
>@@ -82,6 +82,10 @@
> 			</fileset>
> 		</zip>
>     </target>
>+
>+	<target name="merge-platform" description="merge the hana platform jar into the eclipselink jar in the trunk directory" depends="compile">
>+		<jar jarfile="${eclipselink-jar.file}" basedir="${classes.dir}" update="true"/>
>+	</target>
> 	
> 	<target name="merge-src" description="copy HANA platform and test sources into eclipselink trunk repository for testing purposes">
> 		<unzip src="${hana.platform.src.zip}" dest="${trunk.dir}/foundation/org.eclipse.persistence.core/src" overwrite="yes"/>
>diff --git a/extensions/org.eclipse.persistence.platform.database.hana/src/org/eclipse/persistence/platform/database/HANAPlatform.java b/extensions/org.eclipse.persistence.platform.database.hana/src/org/eclipse/persistence/platform/database/HANAPlatform.java
>index d139377..28c2679 100644
>--- a/extensions/org.eclipse.persistence.platform.database.hana/src/org/eclipse/persistence/platform/database/HANAPlatform.java
>+++ b/extensions/org.eclipse.persistence.platform.database.hana/src/org/eclipse/persistence/platform/database/HANAPlatform.java
>@@ -39,6 +39,7 @@ import org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter;
> import org.eclipse.persistence.internal.expressions.FunctionExpression;
> import org.eclipse.persistence.internal.expressions.SQLSelectStatement;
> import org.eclipse.persistence.internal.helper.ClassConstants;
>+import org.eclipse.persistence.internal.helper.DatabaseTable;
> import org.eclipse.persistence.internal.helper.Helper;
> import org.eclipse.persistence.internal.helper.NonSynchronizedVector;
> import org.eclipse.persistence.platform.database.DatabasePlatform;
>@@ -375,15 +376,20 @@ public final class HANAPlatform extends DatabasePlatform {
> 
>     @Override
>     public final boolean supportsGlobalTempTables() {
>-        return false;
>+        return false;
>     }
> 
>     @Override
>     protected final String getCreateTempTableSqlPrefix() {
>-        return "CREATE TEMPORARY TABLE ";
>+        return "CREATE LOCAL TEMPORARY TABLE ";
>     }
> 
>     @Override
>+    public DatabaseTable getTempTableForTable(DatabaseTable table) {
>+        return new DatabaseTable("#" + table.getName(), table.getTableQualifier(), table.shouldUseDelimiters(), getStartDelimiter(), getEndDelimiter());
>+    }          
>+    
>+    @Override
>     protected boolean shouldTempTableSpecifyPrimaryKeys() {
>         return false;
>     }
>@@ -395,7 +401,7 @@ public final class HANAPlatform extends DatabasePlatform {
> 
>     @Override
>     public final boolean supportsLocalTempTables() {
>-        return false;
>+        return true;
>     }
> 
>     @Override
>-- 
>1.8.0.msysgit.0
>

Actions: View | Diff

Attachments on bug 396259: 224554 | 224555