sqlCheck precondition fails with ORA-00911: invalid character fails with trailing characters after semicolon

Description

The following precondition leads to the exception:

<sqlCheck expectedResult="9">select count( * ) from mytable; </sqlCheck>

or:

<sqlCheck expectedResult="9">select count( * ) from mytable; </sqlCheck>

while the one without semicolon nor any whitespace after the semicolon works fine:

<sqlCheck expectedResult="9">select count( * ) from mytable </sqlCheck>

or:

<sqlCheck expectedResult="9">select count( * ) from mytable;</sqlCheck>

This can easily happen when someone reformats the changelog file and sql statements are spread across multiple lines.

Environment

Linux, openjdk-1.7

Activity

Show:

Details

Reporter

Components

Affects versions

Priority

Created July 3, 2014 at 8:35 AM
Updated July 3, 2014 at 8:35 AM

Flag notifications