search

sindicate / solidbase

SolidBase is a database change management and version control tool that uses annotated SQL
https://code.google.com/p/solidbase/
Apache License 2.0
2 stars 0 forks source link

-- Comment before solidbase command does not work #139

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
--DROP INDEX ZM_POINT_IDX;
--ALTER TABLE ZM_POINT MODIFY GEOM NULL;

IMPORT CSV SKIP HEADER
INTO ZM_POINT ( ID, NAME, CASE_ID, CREATED_BY, NEAREST_ADDRESS_DESCRIPTION )
VALUES ( :1, :2, :3, :4, :5 )
FILE "DATA/ZM_POINT.CSV" ENCODING "UTF-8";
COMMIT;

Gives

build.xml:19: null: Invalid SQL type
While executing line 577: --DROP INDEX ZM_POINT_IDX

Original issue reported on code.google.com by rene.de....@gmail.com on 19 Nov 2011 at 11:32

GoogleCodeExporter commented 9 years ago 
Actually, if you remove the semicolons you get:

G:\PROJECTS\triplec-personal\dump\build.xml:19: 42000: ORA-00900: invalid SQL 
statement

While executing line 577: --DROP INDEX ZM_POINT_IDX
--ALTER TABLE ZM_POINT MODIFY GEOM NULL

IMPORT CSV SKIP HEADER
INTO ZM_POINT ( ID, NAME, CASE_ID, CREATED_BY, NEAREST_ADDRESS_DESCRIPTION )
VALUES ( :1, :2, :3, :4, :5 )
FILE "DATA/ZM_POINT.CSV" ENCODING "UTF-8"

Original comment by rene.de....@gmail.com on 19 Nov 2011 at 11:42

GoogleCodeExporter commented 9 years ago

Original comment by rene.de....@gmail.com on 4 Dec 2011 at 2:53