Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Compare - Schema |
| Version | 14.0 |
create table guest.employee_azure
(ID SMALLINT NOT NULL,
NAME VARCHAR(9),
DEPT SMALLINT CHECK (DEPT BETWEEN 10 AND 100),
JOB CHAR(5) CHECK (JOB IN ('Sales', 'Mgr', 'Clerk')),
HIREDATE DATE,
SALARY DECIMAL(7,2),
COMM DECIMAL(7,2),
PRIMARY KEY (ID),
CONSTRAINT YEARSAL CHECK (YEAR(HIREDATE) > 1986 OR SALARY > 40500) )
go
create table dbo.employee_azure
(ID SMALLINT NOT NULL,
NAME VARCHAR(9),
DEPT SMALLINT CHECK (DEPT BETWEEN 10 AND 100),
JOB CHAR(5) CHECK (JOB IN ('Sales', 'Mgr', 'Clerk')),
HIREDATE DATE,
SALARY DECIMAL(7,2),
COMM DECIMAL(7,2),
PRIMARY KEY (ID),
CONSTRAINT yearsal CHECK (YEAR(HIREDATE) > 1986 OR SALARY > 40500) )
GO
ADS version : ads-windows-x64-14.0-dev-36.
This use case also does not work with Syabse Anywhere 12.Please handle this for this database as well.
ADS version : ads-windows-x64-14.0-dev-36.
This use case also does not work with Syabse ASE 15.7.Please handle this for this database as well.
ADS version : ads-windows-x64-14.0-dev-36.
This use case also does not work with Syabse ASE 15.7.Please handle this for this database as well.
Change option File-> Compare-> Schema Compare-> Ignore Case and enable the option. Then try the Schema Compare and it does not work.
This works in ADS 9.0, ADS 10.0 and ADS 11.0
Change option File-> Compare-> Schema Compare-> Ignore Case and enable the option. Then try the Schema Compare and it does not work.
This works in ADS 9.0, ADS 10.0 and ADS 11.0
I am unable to find a change in the ads code that would have caused this problem. I am noticing there is an issue with what the code is saying the difference is and what the component is displaying. In the above example code is saying there are only 3 differences yet the display is showing 5. If you click on the arrows you will notice it will only scroll through 3 as if provider class is out of sync.
We did upgrade the vincaed from 2.x to 3.x when this issue started occuring, any way to check if there is some change in the editor that is causing the problem?
I am unable to find a change in the ads code that would have caused this problem. I am noticing there is an issue with what the code is saying the difference is and what the component is displaying. In the above example code is saying there are only 3 differences yet the display is showing 5. If you click on the arrows you will notice it will only scroll through 3 as if provider class is out of sync.
We did upgrade the vincaed from 2.x to 3.x when this issue started occuring, any way to check if there is some change in the editor that is causing the problem?
This was a tricky thing to find. The problem is we don't have a proper API for Diff, like we have for (most of) the editor.
Somewhere in your code you have a EditableDiffView subclass which overrides getDiffProvider() in order to inject your custom case-aware provider.
But getDiffProvider() disappeared during the migration since I've noticed it's not used anywhere. Most certainly I checked for setDiffProvider usage (which is never called) and I didn't expect you to just override getDiffProvider (which should have been final).
So your code remained unchanged but didn't do anything anymore. An @Override annotation would have warned us here.
I'll send you a new build tomorrow.
This was a tricky thing to find. The problem is we don't have a proper API for Diff, like we have for (most of) the editor.
Somewhere in your code you have a EditableDiffView subclass which overrides getDiffProvider() in order to inject your custom case-aware provider.
But getDiffProvider() disappeared during the migration since I've noticed it's not used anywhere. Most certainly I checked for setDiffProvider usage (which is never called) and I didn't expect you to just override getDiffProvider (which should have been final).
So your code remained unchanged but didn't do anything anymore. An @Override annotation would have warned us here.
I'll send you a new build tomorrow.
Issue #8653 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build Vincaed 3.0.5.7 |
| No time estimate |
1 issue link |
relates to #8465
Issue #8465Compare schema shows differences when a table has unnamed check constraints |
ADS version : ads-windows-x64-14.0-dev-36.
This use case also does not work with Syabse Anywhere 12.Please handle this for this database as well.