What steps will reproduce the problem?
1. Create a postgresql migration with the following:
CREATE TYPE imagedata AS (
imageid integer,
activity character varying,
imagecategory character varying,
path character varying,
whentaken timestamp with time zone,
imagecaption character varying
);
2. Migrate
What is the expected output? What do you see instead?
I expect no output, instead I get a failure:
[ERROR] Error executing: CREATE TYPE imagedata AS ( imageid integer, activity
character varying, imagecategory character varying, path character varying,
whentaken timestamp with time zone, imagecaption character varying ); ALTER
TYPE...
It includes the next statement.
What version of the product are you using? On what operating system?
0.9.9-SNAPSHOT, max os x snow leopard.
Please provide any additional information below.
Line 90 in scriptrunner looks for create and as in a line and uses the
characters after the "as" as the delimiter. In this case, it is looking for
the "(" character to end the statement, which is clearly wrong.
This can be fixed by changing line 90 to this:
else if ((command.length() == 0) && startsWithIgnoreCase(line, "create ") && containsIgnoreCase(line, " as ") && (containsIgnoreCase(line, " type ") != true))
I have attached a patch with tests and source code modification for this issue
and issue 46. Sorry about not separating these out, but it makes some sense to
keep the test resource file together.
Original issue reported on code.google.com by jer...@musicsmith.net on 8 Jul 2011 at 5:10
Original issue reported on code.google.com by
jer...@musicsmith.net
on 8 Jul 2011 at 5:10Attachments: