René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Indexes are not scripted correctly ","articleBody":"## Read and complete the full issue template\r\n\r\n**Do you want to request a *feature* or report a *bug*?**\r\n- [x] Bug\r\n- [ ] Feature\r\n\r\n**Version of OpenDBDiff**\r\n\r\ne.g. 0.13.0.0\r\n\r\n**What is the current behavior?**\r\n\r\nit gives for triggers wrong script after compare \r\n\r\n**What is the expected behavior or new feature?**\r\n\r\nno error in script\r\n\r\n**Did this work in previous versions of our tool?  If so, in which versions?**\r\n\r\nNo\r\n\r\n## Reproducibility\r\ncreate a table\r\n\r\nCREATE TABLE [dbo].[_Orders](\r\n\t[Order_Id] [varchar](50) NOT NULL,\r\n\t[OnDate] [datetime] NOT NULL,\r\n\t[Client_Id] [varchar](50) NOT NULL,\r\n\t[Price] [varchar](50) NOT NULL\r\n) ON [PRIMARY]\r\n\r\nGO\r\n\r\nSET ANSI_PADDING OFF\r\nGO\r\n\r\nALTER TABLE [dbo].[_Orders] ADD  CONSTRAINT [DF__Orders_Order_Id]  DEFAULT (newid()) FOR [Order_Id]\r\nGO\r\n\r\nALTER TABLE [dbo].[_Orders] ADD  CONSTRAINT [DF__Orders_OnDate]  DEFAULT (getutcdate()) FOR [OnDate]\r\nGO\r\n\r\n\r\ncreate an index\r\n\r\nCREATE UNIQUE NONCLUSTERED INDEX [IX_Orders_Client_Id] ON [dbo].[_Orders] \r\n(\r\n\t[Client_Id] ASC,\r\n\t[Order_Id] ASC,\r\n\t[OnDate] DESC\r\n)\r\nINCLUDE ( [Price]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = ON, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]\r\nGO\r\n\r\n\r\nthen compare the database with and empty database\r\n\r\nand you will get this \r\n\r\nCREATE TABLE [dbo].[_Orders]\r\n(\r\n\t[Order_Id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__Orders_Order_Id] DEFAULT (newid()),\r\n\t[OnDate] [datetime] NOT NULL CONSTRAINT [DF__Orders_OnDate] DEFAULT (getutcdate()),\r\n\t[Client_Id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,\r\n\t[Price] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL\r\n) ON [PRIMARY]\r\nGO\r\nCREATE UNIQUE NONCLUSTERED INDEX [IX_Orders_Client_Id] ON [dbo].[_Orders]\r\n(\r\n\t[Client_Id] ASC,\r\n\t[Order_Id] ASC,\r\n\t[OnDate] DESC\r\n) INCLUDE ([Price]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFFIGNORE_DUP_KEY = ON, , ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\nGO\r\n\r\n\r\nthe error is that it is missing a comma after off and it as a comma to much after the next ON\r\n\r\n= OFFIGNORE_DUP_KEY = ON, , ALLOW_ROW_LOCKS\r\n\r\ncorrect would be \r\n\r\n--\u003e  = OFF, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS\r\n\r\n--\u003e\r\nINCLUDE ([Price]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n\r\n","author":{"url":"https://github.com/salusalpha","@type":"Person","name":"salusalpha"},"datePublished":"2024-04-23T17:48:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/166/OpenDBDiff/issues/166"}