db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-21) Sql Server drop statements fail without delimited identifiers
Date Fri, 30 Sep 2005 13:35:47 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-21?page=comments#action_12330956 ] 

Thomas Dudziak commented on DDLUTILS-21:
----------------------------------------

Unfortunately I have no Sql Server to test against at the moment. But I wonder, does this
work when using a table name like 'SomeTable' (note the upper case).
If you could verify for me that such mixed case names work with your patch when not in delimited
mode, then I'll apply it ASAP.

Tom

> Sql Server drop statements fail without delimited identifiers
> -------------------------------------------------------------
>
>          Key: DDLUTILS-21
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-21
>      Project: DdlUtils
>         Type: Bug
>     Reporter: Richard Bounds
>     Assignee: Thomas Dudziak
>  Attachments: patch.txt
>
> The drop statements that are generated for sql server are prefixed by:
> IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'tablename')
> Without a delimeter being specified the statement changes to:
> IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = tablename)
> ...which fails (note the lack of quotes around tablename).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message