[
http://jira.codehaus.org/browse/MSQL-67?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Scholte updated MSQL-67:
-------------------------------
Description:
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.
was:
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.
> 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:
> {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.
-
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
