[
https://issues.apache.org/jira/browse/DERBY-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik updated DERBY-3999:
---------------------------------
Derby Categories: [Embedded/Client difference] (was: [Wrong query result,
Embedded/Client difference])
Unchecking "wrong query result", since this issue reports a query that fails,
not
erroneous data.
> Can't execute select statement with blob in network server mode
> ----------------------------------------------------------------
>
> Key: DERBY-3999
> URL: https://issues.apache.org/jira/browse/DERBY-3999
> Project: Derby
> Issue Type: Bug
> Components: Network Client
> Affects Versions: 10.4.2.0
> Environment: OS - windows xp, Derby - 10.4.2, client jdbc Driver -
> org.apache.derby.jdbc.ClientDriver()
> Reporter: Ashitkin Alexander
> Priority: Minor
> Attachments: d3999.sql, log.txt
>
>
> When Derby Derby in ServerMode this query raise the java.io.EOFException(in
> embedded works normally):
> SELECT
> this_.ID as ID11_2_,
> this_.PROTOCOL_ID as PROTOCOL2_11_2_,
> this_.PROTOCOL_NAME as PROTOCOL3_11_2_,
> this_.PROTOCOL_VERSION as PROTOCOL4_11_2_,
> this_.STORAGE as STORAGE11_2_,
> schemavali2_.PROTOCOL_VALIDATION_ID as PROTOCOL4_4_,
> schemavali2_.ID as ID4_,
> schemavali2_.ID as ID12_0_,
> schemavali2_.BINARY_CONTENT as BINARY2_12_0_, -- this should be
> commented to allow normal query execution
> schemavali2_.FILE_NAME as FILE3_12_0_,
> schemavali2_.PROTOCOL_VALIDATION_ID as PROTOCOL4_12_0_,
> validation3_.SCHEMA_VALIDATION_ID as SCHEMA8_5_,
> validation3_.ID as ID5_,
> validation3_.ID as ID13_1_,
> validation3_.IS_IMPORTED as IS2_13_1_,
> validation3_.IMPORTED_FILE_NAME as IMPORTED3_13_1_,
> validation3_.ITEM_TEXT as ITEM4_13_1_,
> validation3_.PROPERTY_NAME as PROPERTY5_13_1_,
> validation3_.RULE_NAME as RULE6_13_1_,
> validation3_.SCHEMA_VALIDATION_ID as SCHEMA8_13_1_,
> validation3_.ISSUE_STATUS as ISSUE7_13_1_
> FROM
> VL_PROTOCOL_VALIDATION this_
> LEFT OUTER JOIN
> VL_SCHEMA_VALIDATION schemavali2_
> ON
> this_.ID=schemavali2_.PROTOCOL_VALIDATION_ID
> LEFT OUTER JOIN
> VL_SCHEMA_VALIDATION_ISSUE validation3_
> ON
> schemavali2_.ID=validation3_.SCHEMA_VALIDATION_ID
> WHERE
> this_.PROTOCOL_NAME='base'
> Tables ddl:
> create table VL_PROTOCOL_VALIDATION (
> ID integer generated always as identity(start with 1, increment
> by 1) primary key,
> PROTOCOL_ID integer,
> PROTOCOL_NAME varchar(100),
> PROTOCOL_VERSION varchar(100),
> STORAGE varchar(20)
> );
> create table VL_SCHEMA_VALIDATION (
> ID integer generated always as identity(start with 1, increment
> by 1) primary key,
> PROTOCOL_VALIDATION_ID integer not null references
> VL_PROTOCOL_VALIDATION(ID),
> FILE_NAME varchar(250),
> BINARY_CONTENT blob
> );
> create table VL_SCHEMA_VALIDATION_ISSUE (
> ID integer generated always as identity(start with 1, increment
> by 1) primary key,
> SCHEMA_VALIDATION_ID integer not null references
> VL_SCHEMA_VALIDATION(ID),
> ITEM_TEXT varchar(1000),
> RULE_NAME varchar(100),
> ISSUE_STATUS varchar(10),
> PROPERTY_NAME varchar(100),
> IS_IMPORTED varchar(10),
> IMPORTED_FILE_NAME varchar(250)
> );
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
