SQL comment /* */ with more than one lines and containing semicolons
----------------------------------------------------------------------
Key: MSQL-67
URL: http://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:
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 */
If I change the statement to the following it works:
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 */;
Both sql's can be executed with the Oracle SQL Developer.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
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
