SqlDbx Forum

neuli

Member

Bug: Scripting a constraint with whitespace

Scripting a CREATE TABLE-Statement for a column with a constraint that contains whitespaces is wrong.

Tested with 4.12.1

Example:

-- CORRECT SYNTAX WOULD BE
CREATE TABLE dbo.IndexNameTestTable
(
TestColumn INT CONSTRAINT [ConstraintNa meWit hWhiteSp ace] CHECK ([TestColumn]>=(1))
)

--SqlDbx generates
CREATE TABLE dbo.IndexNameTestTable
    (
    TestColumn INT CONSTRAINT ConstraintNa meWit hWhiteSp ace CHECK ([TestColumn]>=(1))
    )
GO

I don't know, what happens to other statements (ALTER, CREATE INDEX, ...) or what happens if column name contains whitespaces, but I think there could be more bugs.

Thx
neuli

Last edited by neuli (2016-01-18 05:56:21)