db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3646) Embedded returns wrong results when selecting a blob column twice and using getBinaryStream()
Date Tue, 23 Jun 2009 19:48:07 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12723266#action_12723266
] 

Rick Hillegas commented on DERBY-3646:
--------------------------------------

My $0.02:

(a) is non-ANSI/ISO behavior.

(b) and (c) are quirky behaviors which will puzzle users.

(d) is limited but probably easy to explain to users.

(e) is fully functional and should be the ultimate goal.

Thanks,
-Rick

> Embedded returns wrong results when selecting a blob column twice and using getBinaryStream()
> ---------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3646
>                 URL: https://issues.apache.org/jira/browse/DERBY-3646
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.1.3, 10.5.1.1
>            Reporter: Kathey Marsden
>         Attachments: DoubleSelect.java
>
>
> The attached program DoubleSelect selects a blob column twice and tries to access the
blob column with getBinaryStream.
> With embedded the output is:
> 4 5 6 7 8 9 10 11 12 13
> 14 15 16 17 18 19 20 21 22 23
> I am done
> Two things seem to be happening with embedded.
> 1) Both getBinaryStream() calls are returning the same stream.
> 2) The second getBinaryStream() call throws away 4 bytes.
> With client the output is:
> Exception in thread "main" java.io.IOException: The object is already
> closed.
>         at
> org.apache.derby.client.am.CloseFilterInputStream.read(CloseFilterInputStream.java:50)
>         at DoubleSelect.printNextTen(DoubleSelect.java:53)
>         at DoubleSelect.main(DoubleSelect.java:43)
> 0 1 2 3 4 5 6 7 8 9
> So with client it looks like the  second getBinaryStream() call closes
> the first stream but then returns the right result for the second stream.
> Perhaps embedded should behave the same as client or perhaps the query should just work.
 Regardless embedded should not return wrong results.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message