[jira] Commented: (DERBY-4582) Timestamps inserted with GMT calendar are 1 hour later when subsequently read with GMT calendar (Server Mode Only).

2010-07-13 Thread Lily Wei (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12888203#action_12888203 ] Lily Wei commented on DERBY-4582: - Don't worry about it, Mamta. Yes, I will back port this

[jira] Assigned: (DERBY-4582) Timestamps inserted with GMT calendar are 1 hour later when subsequently read with GMT calendar (Server Mode Only).

2010-07-13 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor reassigned DERBY-4582: -- Assignee: Lily Wei (was: Mamta A. Satoor) Sorry, didn't notice that Lily had already a

Regression Test Report - tinderbox_trunk16 963932 - Sun Database Engineering

2010-07-13 Thread Ole . Solberg
[Auto-generated mail] *tinderbox_trunk16* 963932/2010-07-14 05:02:11 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 022 047.36% org.apache.derbyTesting.functionTests.tests.dem

Re: JIRA Issues that would nice to have a Graphical Query Plan Attached

2010-07-13 Thread Nirmal Fernando
Hi Eranda, I captured the XplainStatistics by modifying the Main_Updated.java attached to the JIRA by Bryan. Thanks for the explanation, I'll look into it again tonight. On Wed, Jul 14, 2010 at 9:32 AM, Eranda Sooriyabandara wrote: > Hi Nirmal, > Thanks for the details and I will go through it

[jira] Commented: (DERBY-4574) derby.jar not a valid R4 OSGi bundle

2010-07-13 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12888183#action_12888183 ] Bryan Pendleton commented on DERBY-4574: Thanks Myrna. I believe that checking the

Re: JIRA Issues that would nice to have a Graphical Query Plan Attached

2010-07-13 Thread Eranda Sooriyabandara
Hi Nirmal, Thanks for the details and I will go through it. >>SELECT a.USER_ID, a.USER_NAME, b.account_id FROM Users a JOIN Messaged_Users b ON a.USER_ID=b.USER_ID AND b.account_id=(?) It is not a sql query. It's a prepared statement. if you are using ij you can do it as follows ij> prepare s1 as

[jira] Assigned: (DERBY-4582) Timestamps inserted with GMT calendar are 1 hour later when subsequently read with GMT calendar (Server Mode Only).

2010-07-13 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor reassigned DERBY-4582: -- Assignee: Mamta A. Satoor (was: Lily Wei) > Timestamps inserted with GMT calendar are

[jira] Resolved: (DERBY-4610) Error attempting delete with cascade and triggers

2010-07-13 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor resolved DERBY-4610. Fix Version/s: 10.5.3.1 Resolution: Fixed > Error attempting delete with cascade and

[jira] Commented: (DERBY-4582) Timestamps inserted with GMT calendar are 1 hour later when subsequently read with GMT calendar (Server Mode Only).

2010-07-13 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12888168#action_12888168 ] Mamta A. Satoor commented on DERBY-4582: Will work on backporting it to 10.5 > Tim

[jira] Created: (DERBY-4743) Attempt to access a DECLARE GLOBAL TEMPORARY TABLE after commit in an XA transaction in Network server fails.

2010-07-13 Thread Mike Matrigali (JIRA)
Attempt to access a DECLARE GLOBAL TEMPORARY TABLE after commit in an XA transaction in Network server fails. - Key: DERBY-4743 URL: https://issues.apache.

[jira] Updated: (DERBY-4743) Attempt to access a DECLARE GLOBAL TEMPORARY TABLE after commit in an XA transaction in Network server fails.

2010-07-13 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-4743: -- Attachment: XATest.java 2) testXATempTableD4743(org.apache.derbyTesting.functionTests.tests.jd

[jira] Issue Comment Edited: (DERBY-4735) prepare of an XA read only transaction with a declared global temporary table gets and ASSERT in SANE mode.

2010-07-13 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12888157#action_12888157 ] Mike Matrigali edited comment on DERBY-4735 at 7/13/10 10:40 PM:

[jira] Commented: (DERBY-4477) Selecting / projecting a column whose value is represented by a stream more than once fails

2010-07-13 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12888064#action_12888064 ] Kathey Marsden commented on DERBY-4477: --- Myrna pointed out that back porting the chan

Re: regression test regressed

2010-07-13 Thread Knut Anders Hatlen
On 07/13/10 10:33 PM, Tiago Espinha wrote: > I think ideally we'd keep the max number of ports on a tight fit to what is > actually needed, that's why I left them at 10. This way if new ports are > required along the way, whoever makes the changes gets alerted that they need > to > increase thi

Re: regression test regressed

2010-07-13 Thread Tiago Espinha
I think ideally we'd keep the max number of ports on a tight fit to what is actually needed, that's why I left them at 10. This way if new ports are required along the way, whoever makes the changes gets alerted that they need to increase this constant. Of course we can also overshoot and give

[jira] Closed: (DERBY-481) implement SQL generated columns

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-481. --- > implement SQL generated columns > --- > > Key: DERBY-481 >

[jira] Closed: (DERBY-2207) Improve usability of Derby's client/server security by implementing ANSI Roles

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-2207. > Improve usability of Derby's client/server security by implementing ANSI Roles >

[jira] Closed: (DERBY-1626) TransactionTable.sql fails

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-1626. > TransactionTable.sql fails > -- > > Key: DERBY-1626 >

[jira] Closed: (DERBY-2605) You can create BOOLEAN columns in 10.3

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-2605. > You can create BOOLEAN columns in 10.3 > -- > > K

[jira] Closed: (DERBY-2983) The ResultSet returned by DatabaseMetaData.getFunctions() does not contain a required column named FUNCTION_TYPE.

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-2983. > The ResultSet returned by DatabaseMetaData.getFunctions() does not contain a > required column named

[jira] Closed: (DERBY-3119) Derby does not resolve functions to methods with Integer return type.

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3119. > Derby does not resolve functions to methods with Integer return type. > -

[jira] Closed: (DERBY-651) Re-enable the storing of java objects in the database

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-651. --- > Re-enable the storing of java objects in the database >

[jira] Closed: (DERBY-3271) Using BUILTIN authentication, I can't log in as database creator after storing credentials in the database.

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3271. > Using BUILTIN authentication, I can't log in as database creator after > storing credentials in the

[jira] Closed: (DERBY-1460) Instability in storerecovery suite when run against jar files on jdk1.6

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-1460. > Instability in storerecovery suite when run against jar files on jdk1.6 > ---

[jira] Closed: (DERBY-1285) Finish JDBC3 Blob implementation

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-1285. > Finish JDBC3 Blob implementation > > > Key: DERBY-12

Re: regression test regressed

2010-07-13 Thread Kristian Waagan
On 13.07.10 20:59, Tiago Espinha wrote: Hello Rick, Do we know which patch it was that introduced this? The second failure has to do with my test conversions from last year and it should come up if we're trying to request one more port from TestConfiguration.getNextAvailablePort() without adjust

[jira] Closed: (DERBY-3744) User-coded functions can't return Blob or Clob because these raise connection-killing errors in the byte-code compiler

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3744. > User-coded functions can't return Blob or Clob because these raise > connection-killing errors in th

[jira] Closed: (DERBY-3904) NPE on left join with aggregate

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3904. > NPE on left join with aggregate > --- > > Key: DERBY-3904

[jira] Closed: (DERBY-3809) Add a SHOW FUNCTIONS command to ij

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3809. > Add a SHOW FUNCTIONS command to ij > -- > > Key: DERB

[jira] Closed: (DERBY-3923) Make the datatype optional when declaring columns with generation clauses

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3923. > Make the datatype optional when declaring columns with generation clauses > -

[jira] Closed: (DERBY-3945) Generation clauses which mention user-coded functions may produce different resuls depending on who performs the triggering INSERT/UPDATE

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3945. > Generation clauses which mention user-coded functions may produce different > resuls depending on wh

[jira] Closed: (DERBY-3932) Add tests of generated columns when sql authorization is turned on

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3932. > Add tests of generated columns when sql authorization is turned on >

[jira] Closed: (DERBY-3969) NPE if you declare a constraint on a generated column and omit the datatype

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3969. > NPE if you declare a constraint on a generated column and omit the datatype > ---

[jira] Closed: (DERBY-2918) Errors in regression tests run against 10.3.1.1 release candidate

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-2918. > Errors in regression tests run against 10.3.1.1 release candidate > -

[jira] Closed: (DERBY-3061) Wrong results from query with two conjuncts

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3061. > Wrong results from query with two conjuncts > --- > >

[jira] Closed: (DERBY-3985) Replace BUILDING.txt with a simlified up-to-date BUILDING.html

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3985. > Replace BUILDING.txt with a simlified up-to-date BUILDING.html >

[jira] Closed: (DERBY-3995) The tinderbox build should be updated to use CDC/FP 1.1 rather than 1.0 libraries

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3995. > The tinderbox build should be updated to use CDC/FP 1.1 rather than 1.0 > libraries > --

[jira] Closed: (DERBY-3996) Change eol style to native on jsr169 stubs

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3996. > Change eol style to native on jsr169 stubs > -- > >

[jira] Closed: (DERBY-3390) SQLException thrown from user function kills network connection

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3390. > SQLException thrown from user function kills network connection > ---

[jira] Closed: (DERBY-3592) The Java 5 javadoc tool generates a spurious output line when digesting the doctitle element for the public api

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3592. > The Java 5 javadoc tool generates a spurious output line when digesting the > doctitle element for t

[jira] Closed: (DERBY-4017) Removed deprecated jdk16 variable from the machinery which builds javadoc

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4017. > Removed deprecated jdk16 variable from the machinery which builds javadoc > -

[jira] Closed: (DERBY-4157) Create a test to verify that virgin metadata is identical to hard-upgraded metadata

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4157. > Create a test to verify that virgin metadata is identical to hard-upgraded > metadata >

[jira] Closed: (DERBY-3718) NPE when firing a trigger

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3718. > NPE when firing a trigger > - > > Key: DERBY-3718 >

[jira] Closed: (DERBY-4470) Forbid ordering operations on UDTs

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4470. > Forbid ordering operations on UDTs > -- > > Key: DERB

[jira] Closed: (DERBY-4221) Provide message localizations for 10.5

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4221. > Provide message localizations for 10.5 > -- > > K

[jira] Closed: (DERBY-4469) Fix the CASTing behavior of UDTs

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4469. > Fix the CASTing behavior of UDTs > > > Key: DERBY-44

[jira] Closed: (DERBY-3948) Don't allow references to generated columns in the NEW transition variables of triggered actions of BEFORE triggers

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3948. > Don't allow references to generated columns in the NEW transition variables > of triggered actions o

[jira] Closed: (DERBY-3950) You should get an error if you try to override a generated column via an INSERT driven by an inner ResultSet

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3950. > You should get an error if you try to override a generated column via an > INSERT driven by an inner

[jira] Closed: (DERBY-4487) Add dblook support for SEQUENCEs

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4487. > Add dblook support for SEQUENCEs > > > Key: DERBY-44

[jira] Closed: (DERBY-4491) The network client changes UDTs into Strings and returns their type as LONGVARBINARY.

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4491. > The network client changes UDTs into Strings and returns their type as > LONGVARBINARY. > --

[jira] Closed: (DERBY-4539) Make it possible to put the optional clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by the SQL Standard

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4539. > Make it possible to put the optional clauses of a CREATE SEQUENCE statement > in the arbitrary order

[jira] Closed: (DERBY-4684) Correct the implicit casting of other types to BOOLEAN

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4684. > Correct the implicit casting of other types to BOOLEAN >

[jira] Closed: (DERBY-4022) Remove dependency of junit targets on deprecated jdk16 variable

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4022. > Remove dependency of junit targets on deprecated jdk16 variable > ---

[jira] Closed: (DERBY-4024) Replace felix.jar file with the felix sources

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4024. > Replace felix.jar file with the felix sources > - > >

[jira] Closed: (DERBY-4215) Extra permissions tuple if you hard-upgrade from 10.0 without doing an intermediate hard-upgrade to 10.1

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4215. > Extra permissions tuple if you hard-upgrade from 10.0 without doing an > intermediate hard-upgrade t

[jira] Closed: (DERBY-4692) Unions between BOOLEAN and non-BOOLEAN datatypes should be rejected

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4692. > Unions between BOOLEAN and non-BOOLEAN datatypes should be rejected > ---

[jira] Closed: (DERBY-4703) Make it possible for table functions to return BOOLEAN columns

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4703. > Make it possible for table functions to return BOOLEAN columns >

[jira] Closed: (DERBY-4730) Add BOOLEAN to the list of datatypes returned by DatabaseMetaData.getTypeInfo()

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4730. > Add BOOLEAN to the list of datatypes returned by > DatabaseMetaData.getTypeInfo() >

[jira] Closed: (DERBY-4499) Compiler error when preparing a procedure call with an output parameter of user defined type.

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4499. > Compiler error when preparing a procedure call with an output parameter of > user defined type. > --

[jira] Closed: (DERBY-4513) Forbid NEXT VALUE FOR clause in certain contexts

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4513. > Forbid NEXT VALUE FOR clause in certain contexts > >

[jira] Closed: (DERBY-4659) Allow routines to take arguments of BOOLEAN type

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4659. > Allow routines to take arguments of BOOLEAN type > >

[jira] Closed: (DERBY-4658) Allow explicit casts of string values to BOOLEAN

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4658. > Allow explicit casts of string values to BOOLEAN > >

[jira] Closed: (DERBY-4714) Clean up some edge-case uses of the BOOLEAN keyword

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4714. > Clean up some edge-case uses of the BOOLEAN keyword > ---

[jira] Closed: (DERBY-4708) In the Administration Guide, clarify that you need to adjust file permissions in your security policy in order to prevent import/export from accessing sensitive files outsi

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4708. > In the Administration Guide, clarify that you need to adjust file permissions > in your security pol

[jira] Closed: (DERBY-4716) Enable BOOLEAN typed columns

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4716. > Enable BOOLEAN typed columns > > > Key: DERBY-4716 >

[jira] Assigned: (DERBY-4582) Timestamps inserted with GMT calendar are 1 hour later when subsequently read with GMT calendar (Server Mode Only).

2010-07-13 Thread Lily Wei (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei reassigned DERBY-4582: --- Assignee: Lily Wei (was: Knut Anders Hatlen) > Timestamps inserted with GMT calendar are 1 hour late

[jira] Closed: (DERBY-4720) Allow boolean-valued expressions in select lists

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-4720. > Allow boolean-valued expressions in select lists > >

Re: regression test regressed

2010-07-13 Thread Tiago Espinha
Hello Rick, Do we know which patch it was that introduced this? The second failure has to do with my test conversions from last year and it should come up if we're trying to request one more port from TestConfiguration.getNextAvailablePort() without adjusting the constant for the maximum numb

[jira] Commented: (DERBY-4459) Verification error at execute-time when an outer function which takes a primitive arg is wrapped around an inner function which returns the corresponding Java wrapper ob

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887929#action_12887929 ] Rick Hillegas commented on DERBY-4459: -- Tests ran cleanly for me except for the follow

regression test regressed

2010-07-13 Thread Rick Hillegas
I'm seeing these now: 1) testAttributeAccumulatedConnectionCount(org.apache.derbyTesting.functionTests.tests.management.NetworkServerMBeanTest)java.security.PrivilegedActionException: javax.management.InstanceNotFoundException: org.apache.derby:type=NetworkServer,system=c013800d-0129-cd0d-100f

[jira] Closed: (DERBY-3634) Cannot use row_number() in ORDER BY clause

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3634. > Cannot use row_number() in ORDER BY clause > -- > >

[jira] Closed: (DERBY-3652) Derby does not follow the SQL Standard when trying to map SQL routines to Java methods.

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3652. > Derby does not follow the SQL Standard when trying to map SQL routines to > Java methods. >

[jira] Resolved: (DERBY-4574) derby.jar not a valid R4 OSGi bundle

2010-07-13 Thread Myrna van Lunteren (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Myrna van Lunteren resolved DERBY-4574. --- Assignee: Bryan Pendleton (was: Myrna van Lunteren) Fix Version/s: 10.5.3.1

[jira] Closed: (DERBY-3570) Implement DETERMINISTIC keyword for procedures and functions

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3570. > Implement DETERMINISTIC keyword for procedures and functions > --

[jira] Closed: (DERBY-3635) Cannot build SELECT LIST expressions involving row_number()

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-3635. > Cannot build SELECT LIST expressions involving row_number() > ---

[jira] Resolved: (DERBY-4120) derbyclient.jar is not a complete OSGi bundle

2010-07-13 Thread Myrna van Lunteren (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Myrna van Lunteren resolved DERBY-4120. --- Assignee: Bryan Pendleton (was: Myrna van Lunteren) Fix Version/s: 10.5.3.1

[jira] Updated: (DERBY-3944) CHECK constraints involving user-coded functions may return different results depending on who performs the triggering INSERT/UPDATE

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-3944: - Bug behavior facts: [Data corruption] > CHECK constraints involving user-coded functions may retu

[jira] Resolved: (DERBY-3645) Insert into selecting BLOB column twice leads to SQLException: Restore of a serializable or SQLData object of class error selecting from the table

2010-07-13 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden resolved DERBY-3645. --- Assignee: Dag H. Wanvik (was: Kathey Marsden) Fix Version/s: 10.5.3.1 Resolut

Re: JIRA Issues that would nice to have a Graphical Query Plan Attached

2010-07-13 Thread Nirmal Fernando
Hi Eranda, Please see my comments inline. > Did you do it to prepared statement? I did it for this query: SELECT a.USER_ID, a.USER_NAME, b.account_id FROM Users a JOIN Messaged_Users b ON a.USER_ID=b.USER_ID AND b.account_id=(?) I suppose you need to know the query plan followed by the optimize

Regression Test Report - tinderbox_trunk16 963753 - Sun Database Engineering

2010-07-13 Thread Ole . Solberg
[Auto-generated mail] *tinderbox_trunk16* 963753/2010-07-13 17:12:13 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 022 042.10% org.apache.derbyTesting.functionTests.tests.dem

[jira] Assigned: (DERBY-3645) Insert into selecting BLOB column twice leads to SQLException: Restore of a serializable or SQLData object of class error selecting from the table

2010-07-13 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden reassigned DERBY-3645: - Assignee: Kathey Marsden assigning to myself for back port to 10.5 > Insert into select

[jira] Commented: (DERBY-4574) derby.jar not a valid R4 OSGi bundle

2010-07-13 Thread Myrna van Lunteren (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887838#action_12887838 ] Myrna van Lunteren commented on DERBY-4574: --- I was contemplating this backport, b

[jira] Reopened: (DERBY-4120) derbyclient.jar is not a complete OSGi bundle

2010-07-13 Thread Myrna van Lunteren (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Myrna van Lunteren reopened DERBY-4120: --- Assignee: Myrna van Lunteren (was: Bryan Pendleton) Reopening to backport to 10.5.

[jira] Assigned: (DERBY-4574) derby.jar not a valid R4 OSGi bundle

2010-07-13 Thread Myrna van Lunteren (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Myrna van Lunteren reassigned DERBY-4574: - Assignee: Myrna van Lunteren (was: Kathey Marsden) > derby.jar not a valid R4 OS

Re: JIRA Issues that would nice to have a Graphical Query Plan Attached

2010-07-13 Thread Eranda Sooriyabandara
Hi Nirmal, Did you do it to prepared statement? Can you do the same for the execution of the prepared statement. Also need a little explanation to understand the doc. Thanks Eranda On Tue, Jul 13, 2010 at 9:39 PM, Nirmal Fernando wrote: > Hi Eranda, > > I've attached a PDF to the JIRA issue. > >

[jira] Updated: (DERBY-4459) Verification error at execute-time when an outer function which takes a primitive arg is wrapped around an inner function which returns the corresponding Java wrapper obje

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-4459: - Issue & fix info: [Patch Available] > Verification error at execute-time when an outer function w

[jira] Updated: (DERBY-4459) Verification error at execute-time when an outer function which takes a primitive arg is wrapped around an inner function which returns the corresponding Java wrapper obje

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-4459: - Attachment: derby-4459-01-aa-disableOptimization.diff Attaching derby-4459-01-aa-disableOptimizat

[jira] Assigned: (DERBY-4459) Verification error at execute-time when an outer function which takes a primitive arg is wrapped around an inner function which returns the corresponding Java wrapper obj

2010-07-13 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas reassigned DERBY-4459: Assignee: Rick Hillegas > Verification error at execute-time when an outer function which t

[jira] Updated: (DERBY-4715) Write jvm information and path of derby.jar to derby.log

2010-07-13 Thread Lily Wei (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei updated DERBY-4715: Attachment: DERBY-4715-5.diff Thanks Knut for reviewing the patch. I make the following changes in DERBY-4

[jira] Updated: (DERBY-4731) XA two phase commit with active GLOBAL TEMPORARY TABLE causes An internal error identified by RawStore module

2010-07-13 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-4731: -- Fix Version/s: 10.4.2.1 10.5.3.1 10.6.1.1 Iss

[jira] Updated: (DERBY-4731) XA two phase commit with active GLOBAL TEMPORARY TABLE causes An internal error identified by RawStore module

2010-07-13 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-4731: -- Attachment: backport10_3.diff 10.3 backport is not working. Here is the diff of the backport.

[jira] Updated: (DERBY-3892) Query execution hangs

2010-07-13 Thread C.S. Nirmal J. Fernando (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] C.S. Nirmal J. Fernando updated DERBY-3892: --- Attachment: query_plan_derby_3892.pdf Hi All, I've attached the graphical qu

Re: JIRA Issues that would nice to have a Graphical Query Plan Attached

2010-07-13 Thread Nirmal Fernando
Hi Eranda, I've attached a PDF to the JIRA issue. Thanks for the request! On Tue, Jul 13, 2010 at 2:09 PM, Eranda Sooriyabandara wrote: > > Hi Nirmal, > Can you do it for the following issue > https://issues.apache.org/jira/browse/DERBY-3892 > Thanks > Eranda > On Tue, Jul 13, 2010 at 12:47 PM,

[jira] Commented: (DERBY-4574) derby.jar not a valid R4 OSGi bundle

2010-07-13 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887812#action_12887812 ] Kathey Marsden commented on DERBY-4574: --- This is a very simple change and easy to mer

Regression Test Report - Daily 963324 - Sun DBTG

2010-07-13 Thread Ole . Solberg
[Auto-generated mail] *Daily* 963324/2010-07-12 18:01:09 MEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin NA NA NANA suitesAll NA NA NANA jdbcapiAutoLoad NA

[jira] Updated: (DERBY-1511) SELECT clause without a WHERE, causes an Exception when extracting a Blob from a database

2010-07-13 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-1511: -- +1 to fixing the current bug as described (if you can do it only for holdable case that would be b

[jira] Assigned: (DERBY-4574) derby.jar not a valid R4 OSGi bundle

2010-07-13 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden reassigned DERBY-4574: - Assignee: Kathey Marsden (was: Bryan Pendleton) assigning to myself for back port to 10.

[jira] Assigned: (DERBY-4610) Error attempting delete with cascade and triggers

2010-07-13 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor reassigned DERBY-4610: -- Assignee: Mamta A. Satoor (was: Knut Anders Hatlen) > Error attempting delete with cas

[jira] Commented: (DERBY-4610) Error attempting delete with cascade and triggers

2010-07-13 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887805#action_12887805 ] Mamta A. Satoor commented on DERBY-4610: I will work on backporting this to 10.5 >

[jira] Resolved: (DERBY-4615) EmbedCallableStatement ignores Calendar in getDate, getTime and getTimestamp

2010-07-13 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor resolved DERBY-4615. Assignee: Knut Anders Hatlen (was: Mamta A. Satoor) Fix Version/s: 10.5.3.1

  1   2   >