You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by aa...@apache.org on 2007/02/08 15:27:29 UTC
svn commit: r504907 - in
/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl:
db2/create-update-sp2.sql db2/drop-update-sp2.sql
oracle/create-update-sp2.sql sybase/create-update-sp2.sql
sybase/drop-update-sp2.sql
Author: aadamchik
Date: Thu Feb 8 06:27:29 2007
New Revision: 504907
URL: http://svn.apache.org/viewvc?view=rev&rev=504907
Log:
CAY-750 Stored procedures without parameters fail on Postgres 8
(unit tests for other dbs)
Added:
cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql
cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql
cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql
cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql
cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql
Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql (added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/create-update-sp2.sql Thu Feb 8 06:27:29 2007
@@ -0,0 +1,8 @@
+CREATE PROCEDURE cayenne_tst_upd_proc2
+ MODIFIES SQL DATA
+ LANGUAGE SQL
+BEGIN
+ UPDATE
+ PAINTING SET ESTIMATED_PRICE = ESTIMATED_PRICE * 2;
+ COMMIT;
+END
Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql (added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/db2/drop-update-sp2.sql Thu Feb 8 06:27:29 2007
@@ -0,0 +1 @@
+DROP PROCEDURE cayenne_tst_upd_proc2
\ No newline at end of file
Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql (added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/oracle/create-update-sp2.sql Thu Feb 8 06:27:29 2007
@@ -0,0 +1,7 @@
+ CREATE OR REPLACE PROCEDURE cayenne_tst_upd_proc2
+ AS
+ BEGIN
+ SET TRANSACTION READ WRITE;
+ UPDATE PAINTING SET ESTIMATED_PRICE = ESTIMATED_PRICE * 2;
+ COMMIT;
+ END;
Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql (added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/create-update-sp2.sql Thu Feb 8 06:27:29 2007
@@ -0,0 +1,6 @@
+CREATE PROCEDURE cayenne_tst_upd_proc2 AS
+BEGIN
+ BEGIN TRANSACTION UPDATE
+ PAINTING SET ESTIMATED_PRICE = ESTIMATED_PRICE * 2
+ COMMIT
+END
Added: cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql?view=auto&rev=504907
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql (added)
+++ cayenne/main/trunk/framework/cayenne-jdk1.4-unpublished/src/test/resources/ddl/sybase/drop-update-sp2.sql Thu Feb 8 06:27:29 2007
@@ -0,0 +1,4 @@
+if exists (SELECT * FROM sysobjects WHERE name = 'cayenne_tst_upd_proc2')
+BEGIN
+ DROP PROCEDURE cayenne_tst_upd_proc2
+END
\ No newline at end of file