View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001194 | Database Comparer VCL | General | public | 2017-12-08 17:52 | 2019-04-18 19:46 |
Reporter | shirokov | Assigned To | barry | ||
Priority | high | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Summary | 0001194: 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. | ||||
Tags | No tags attached. | ||||
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 |