× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2016-03-11T05:27:27Z  · last modified 2016-03-30T16:44:36Z

Schema Compare: ADS does not ignore embedded spaces in the generated DDL and makes the diff think it is different


customer request
Dev
Kin-Hong Wong
kin-hong
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Moderate
Component Tools - Compare - Schema
Version 17.0
Version: 17.0.3-6
Build #: 48867
Build Date: 2016-Mar-07 01:21:27 PM
 
Schema Compare: ADS does not ignore spaces in the generated DDL and makes the diff think it is different
 

When comparing the DDL of two objects, the embedded spaces in the generated DDL makes the diff think it is different.  See attached screenshots. The issue exists in all older versions. 

To reproduce:

1. File Options -> Compare -> Enable all the Schema Compare options. See File Options screenshot
2. Navigate to PostgreSQL v9.4 at Aws ending 1.69
3. Select databases FY_DIFF_1 and FY_DIFF_2 and select functions and perform a Schema Compare
4. You can see that Diff Count is displayed as 1. There is a difference in line 7 in which ADS does not ignore the Embedded spaces.
Under File-> Options, this is enabled to ignore but in Compare results, this is not taken into account.
 
I checked for older versions from ADS v9 to ADS v17 and the issue exists in all older versions.
 
4 attachments

Issue #14328

Closed
Fixed
Resolved 2016-03-13T03:28:59Z
 
 
Completion
No due date
Fixed Build 17.0.3-11
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017