[DERBY-3999] Can't execute select statement with blob in network server mode

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 10.4.2.0
• Component/s: Network Client
• Environment: OS - windows xp, Derby - 10.4.2, client jdbc Driver - org.apache.derby.jdbc.ClientDriver()
• Bug behavior facts: Embedded/Client difference
• Assignee: Unassigned
• Reporter: Ashitkin Alexander
• Created: 30/Dec/08 08:38
• Updated: 21/Jan/11 17:52
• Resolved: 03/Jul/09 13:24

Description

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)
);