Derby
  1. Derby
  2. DERBY-3999

Can't execute select statement with blob in network server mode

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.4.2.0
    • Fix Version/s: None
    • Component/s: Network Client
    • Labels:
      None
    • Environment:
      OS - windows xp, Derby - 10.4.2, client jdbc Driver - org.apache.derby.jdbc.ClientDriver()
    • Bug behavior facts:
      Embedded/Client difference

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

      1. d3999.sql
        3 kB
        Knut Anders Hatlen
      2. log.txt
        5 kB
        Ashitkin Alexander

        Activity

        Ashitkin Alexander created issue -
        Knut Anders Hatlen made changes -
        Field Original Value New Value
        Attachment d3999.sql [ 12396999 ]
        Ashitkin Alexander made changes -
        Attachment log.txt [ 12397047 ]
        Ashitkin Alexander made changes -
        Attachment log.txt [ 12397047 ]
        Ashitkin Alexander made changes -
        Attachment log.txt [ 12397048 ]
        Dag H. Wanvik made changes -
        Derby Categories [Wrong query result, Embedded/Client difference] [Embedded/Client difference]
        Knut Anders Hatlen made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Cannot Reproduce [ 5 ]
        Kathey Marsden made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12449255 ] Default workflow, editable Closed status [ 12797540 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Ashitkin Alexander
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development