0 Replies Latest reply: Dec 20, 2012 7:00 AM by Andrew Miller RSS

    BUG: Unit Testing Process Validations SQL editor - extra spaces appended

    Andrew Miller
      There is a bug in the SQL editor used by Unit Testing Process Validations.

      To re-create:

      Create a Validation with some multi-line SQL and save:

      select *
      from DUAL
      where 1=1

      Click on a different Validation, and then click back onto the Validation just created. SQL Developer will have appended a space to all the lines except the last one. Edit the Validation and save:

      select *
      from DUAL
      where 1=2

      When you navigate to a different validation and back, SQL Developer will have appended an extra space to each line. This can be repeated - each time an extra space will be added.