[
https://jira.codehaus.org/browse/MSQL-67?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=275750#comment-275750
]
Mark Struberg commented on MSQL-67:
-----------------------------------
can yo please compile the latest from trunk and test it with your project?
(both variants).
txs!
> SQL comment /* */ with more than one lines and containing semicolons
> ----------------------------------------------------------------------
>
> Key: MSQL-67
> URL: https://jira.codehaus.org/browse/MSQL-67
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Affects Versions: 1.4
> Environment: Oracle 10g DB
> Reporter: Jochen Stiepel
>
> The following SQL doesn't work for me:
> {noformat}
> create table T_ABFRAGEPROTOKOLL (
> ID NUMBER(10),
> HELLO_DATE DATE
> )
> TABLESPACE VBS_TAB_GR_03;
> /* semicolon before the comment
> PARTITION BY RANGE (HELLO_DATE)
> ( PARTITION P_2009 VALUES LESS THAN (TO_DATE(' 2010-01-01 00:00:00',
> 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
> TABLESPACE TAB_GR_03,
> PARTITION P_2010 VALUES LESS THAN (TO_DATE(' 2011-01-01 00:00:00',
> 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
> TABLESPACE TAB_GR_03
> ); this semicolon is inside the sql comment */
> {noformat}
> If I change the statement to the following it works:
> {noformat}
> create table T_ABFRAGEPROTOKOLL (
> ID NUMBER(10),
> HELLO_DATE DATE
> )
> TABLESPACE VBS_TAB_GR_03
> /* no semicolon before the comment
> PARTITION BY RANGE (HELLO_DATE)
> ( PARTITION P_2009 VALUES LESS THAN (TO_DATE(' 2010-01-01 00:00:00',
> 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
> TABLESPACE TAB_GR_03,
> PARTITION P_2010 VALUES LESS THAN (TO_DATE(' 2011-01-01 00:00:00',
> 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
> TABLESPACE TAB_GR_03
> ) semicolon is ouside the sql comment */;
> {noformat}
> Both sql's can be executed with the Oracle SQL Developer.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
