View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001194Database Comparer VCLGeneralpublic2017-12-08 17:522019-04-18 19:46
Reportershirokov Assigned Tobarry  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Summary0001194: The extractor chops the final ")" from the stored procedure code
Description=== Should be:

CREATE PROCEDURE [ASI].[DbVersion] AS
BEGIN
-- for winfuel/winfluid v2.0.0
-- version info uses "Semantic Versioning" see http://semver.org/
--
-- Given a version number MAJOR.MINOR.PATCH, increment the:
--
-- MAJOR version when you make incompatible API changes,
-- MINOR version when you add functionality in a backwards-compatible manner, and
-- PATCH version when you make backwards-compatible bug fixes.
DECLARE @Major int;
DECLARE @Minor int;
DECLARE @Patch int;
SET @Major = 2;
SET @Minor = 0;
SET @Patch = 0;
SELECT * FROM (VALUES ( @Major, @Minor, @Patch )) AS DbVersionTable ( Major, Minor, Patch )
END
GO

=== The MssqlDBExtractor produces:

CREATE PROCEDURE ASI.DBVERSION
AS
BEGIN
-- for winfuel/winfluid v2.0.0
-- version info uses "Semantic Versioning" see http://semver.org/
--
-- Given a version number MAJOR.MINOR.PATCH, increment the:
--
-- MAJOR version when you make incompatible API changes,
-- MINOR version when you add functionality in a backwards-compatible manner, and
-- PATCH version when you make backwards-compatible bug fixes.
DECLARE @Major int;
DECLARE @Minor int;
DECLARE @Patch int;
SET @Major = 2;
SET @Minor = 0;
SET @Patch = 0;
SELECT * FROM (VALUES ( @Major, @Minor, @Patch )) AS DbVersionTable ( Major, Minor, Patch
go

As you can see the extractor code chops the final ")" from the code, leaving the code broken.
TagsNo tags attached.

Activities

barry

2018-06-01 00:31

administrator   ~0003739

7.0.0.1670
чего она у нас висит

Issue History

Date Modified Username Field Change
2017-12-08 17:52 shirokov New Issue
2017-12-19 14:37 barry Assigned To => barry
2017-12-19 14:37 barry Status new => acknowledged
2018-06-01 00:31 barry Status acknowledged => resolved
2018-06-01 00:31 barry Resolution open => fixed
2018-06-01 00:31 barry Note Added: 0003739
2019-04-18 19:46 barry Status resolved => closed