开发者

InstallShield 2010 SQL Script multi line comment bug?

I think I found a bug with multi-line comments and SQL scripts in InstallShield 2010.

To reproduce the bug, create a basic MSI project. Go to Installation Designer -> SQL Scripts, create a SQL connection then add a new script that contains the following script:

/*
USE [master]
GO
*/

USE master
GO

Build the MSI and try to install it, you will receive the following MSI error:

Error 27506.Error executing SQL script sqlscript.sql. Line 3. Missing end comment mark '*/'. (113)

Changing the multi-line comment t开发者_开发问答o -- form will solve the issue. Also, if the end comment mark is not being preceded by a GO statement, the install will not fail. For instance:

/*
THIS
WILL
NOT
FAIL
*/

Has someone experienced this bug? Any way to "fix" it?

PS: I'll be posting this to Flexara's forum.


This sounds like known behavior to me. I believe the parsing looks for lines of GO without respect to anything else, so multi-line comments do not affect it. See hidenori's second response on the thread Install Shield is trashing SQL Scripts.

You appear to have already identified the workaround - change the GO to a --GO.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜