Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4091

Investigate "size_problem" column in MailJdbc terst

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 10.5.1.1
    • 10.13.1.0
    • Test
    • None
    • Newcomer

    Description

      In the MailJdbc test there is a table
      CREATE TABLE inbox (id bigint generated always as identity (start with 1,increment by 1),
      from_name varchar(64),
      to_name varchar(64),
      message clob(3M),
      date timestamp,
      folder_id Integer,
      to_delete smallint default 0,
      exp_date timestamp,
      attach_id smallint default 0,
      size_problem varchar(32672),
      CONSTRAINT inbox__pk PRIMARY KEY (id));

      Which has a column "size_problem". We always insert into this column the value

      insertFirst
      .setString(
      6,
      "This column is used only to by pass the space problem. If the problem still exists, then we are going to "
      + "have a serious issue here.*****************************************************************************************************");

      Which seems to imply there is some bug that manifests itself if we don't have this column, but I don't see a bug reference. It would be interesting to take the column out and see what happens.

      Attachments

        1. DERBY-4091-2.diff
          2 kB
          Sandeep Samdaria
        2. Activity.out
          121 kB
          Sandeep Samdaria

        Activity

          People

            sandyridgeracer Sandeep Samdaria
            kmarsden Katherine Marsden
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: