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

Client allows insert of stream in excess of column with non-white space characters

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.9.1.0
    • None
    • Network Client
    • Urgent
    • High Value Fix, Repro attached
    • Deviation from standard, Embedded/Client difference, Wrong query result

    Description

      In converting LobLimits.java DERBY-1903 and trying to enable LobLimitsLiteTest with client. I discovered that this case fails with client:
      try

      { insertClob2("ClobTest #9.1 ", conn, insertClob2, MORE_DATA_THAN_COL_WIDTH, 4, 1, MORE_DATA_THAN_COL_WIDTH, CHARDATAFILE); fail("ClobTest #9.1 " + "should have thrown XSDA4"); }

      catch (SQLException sqle)

      { assertSQLState("XSDA4", sqle); }

      // no row must be retrieved.
      selectClob2("ClobTest #9.2 ", conn, selectClob2, BIG_LOB_SZ, 4, 0,
      CHARDATAFILE);

      If I omit the fail assertion, the row actually does get inserted and has presumably been truncated.
      I will check in LobLimits.java soon with this bug number in the comments.
      To reproduce, remove the if(!usingDerbyNetClient) condition and run the test largedata.LobLimitsLiteTest to reproduce the problem.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: