Derby
  1. Derby
  2. DERBY-5839

dblook run on toursdb fails on triggers with java.lang.StringIndexOutOfBoundsException in dblook.log

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.9.2.2, 10.10.1.1
    • Component/s: Tools
    • Environment:
    • Issue & fix info:
      High Value Fix, Newcomer, Repro attached
    • Bug behavior facts:
      Regression

      Description

      Running dblook on toursdb (either in packaged demo/databases/toursdb in the bin distribution or generated/toursdb after a build) fails to generate ddl for triggers and gives a java.lang.StringIndexOutOfBoundsException in the dblook.log.

      To reproduce:

      java org.apache.derby.tools.dblook -d 'jdbc:derby:toursdb'

      output shows:

      – ----------------------------------------------
      – Note: At least one unexpected error/warning message was
      – DDL Statements for triggersration. See dblook.log
      – ----------------------------------------------

      dblook.log contains:

      java.lang.StringIndexOutOfBoundsException
      at java.lang.String.substring(String.java:1131)
      at org.apache.derby.tools.dblook.getColumnListFromDescription(dblook.java:664)
      at org.apache.derby.impl.tools.dblook.DB_Trigger.createTrigger(DB_Trigger.java:130)
      at org.apache.derby.impl.tools.dblook.DB_Trigger.doTriggers(DB_Trigger.java:82)
      at org.apache.derby.tools.dblook.go(dblook.java:547)
      at org.apache.derby.tools.dblook.<init>(dblook.java:142)
      at org.apache.derby.tools.dblook.main(dblook.java:97)

      This seems to be a regression in 10.9. 10.8 works fine for me

        Activity

        Knut Anders Hatlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Kathey Marsden made changes -
        Labels derby_backport_reject_10_8
        Gavin made changes -
        Workflow jira [ 12709555 ] Default workflow, editable Closed status [ 12802092 ]
        Kathey Marsden made changes -
        Fix Version/s 10.9.2.0 [ 12323562 ]
        Fix Version/s 10.9.1.1 [ 12321551 ]
        Mamta A. Satoor made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Mamta A. Satoor made changes -
        Fix Version/s 10.9.1.1 [ 12321551 ]
        Mamta A. Satoor made changes -
        Fix Version/s 10.10.0.0 [ 12321550 ]
        Mamta A. Satoor made changes -
        Field Original Value New Value
        Assignee Mamta A. Satoor [ mamtas ]
        Kathey Marsden created issue -

          People

          • Assignee:
            Mamta A. Satoor
            Reporter:
            Kathey Marsden
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development