|
Replies:
9
-
Pages:
1
-
Last Post:
Aug 19, 2011 3:24 PM
by: Dwight
|
|
|
Posts:
5
Registered:
12/22/09
|
|
|
|
Comparing sequences
Posted:
Jan 11, 2010 1:26 AM
|
|
|
Hi,
I've imported a schema that contains sequences. As a result of the import, the sequence in the model is defined to START WITH 1.
Next, the sequence is used in the database to insert 5 rows.
When I now compare the model with the database, the sequence is considered as changed, because it's current value in the database has been increased (START WITH 6).
As a result, the update script will recreate the sequence with "START WITH 1".
I'm not sure I should consider this as a bug, because I can set the update action to "Skip". but it can be quite annoying when you have hundreds of sequences you should check at each comparison.
Is it possible to have an option to ignore the "START WITH" value of the sequence during the comparison?
Best regards,
Dirk
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Comparing sequences
Posted:
Jan 11, 2010 12:24 PM
in response to: Dirk Ven
|
|
|
Dirk,
Thanks for pointing this out. We should probably always assume that the value of a sequence is going to be different. It's something that we should probably ignore by default and allow the user to explicitly specify for comparison.
I'm going to pass this along to our team and see what they think. Thanks for bringing this up.
Dwight
|
Dwight
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Comparing sequences
Posted:
Feb 22, 2011 12:12 PM
in response to: Dirk Ven
|
|
|
Dirk,
I've created a task to change this behavior. It should be available in one of our upcoming beta releases.
|
Dwight
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Comparing sequences
Posted:
Apr 4, 2011 9:21 PM
in response to: Dwight
|
|
|
Update,
The fix for this should be coming out in our V 1.3.0 Beta release.
|
Dwight
|
|
Posts:
9
Registered:
4/18/11
|
|
|
|
Re: Comparing sequences
Posted:
May 15, 2011 7:59 PM
in response to: Dwight
|
|
|
Hi,
I am facing the same sequence problem. we are using v1.2, is it any way i can avoide the sequence while depoying using the build process.
Cheers
Shaik
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Comparing sequences
Posted:
May 26, 2011 10:43 AM
in response to: munnusfm
|
|
|
Shaik,
Unfortunately, no.
But, we have addressed this issue in v1.3.0 which is coming out soon (we finish development on Friday, May 27th, and then have to get it through release process). Until the release of v.1.3.0 you can work with our v1.3.0 Beta. Please wait for our next release, though: I mean our release after the current Beta v1.3.0.459 on the web site.
We are hoping to release the next beta this Friday (May 27th).
In the 1.3.0 version we ignore the STARTS WITH clause. This eliminates the redeployment issue with sequences.
|
Dwight
|
|
Posts:
67
Registered:
11/24/10
|
|
|
|
Re: Comparing sequences
Posted:
Jun 7, 2011 5:58 AM
in response to: Dwight
|
|
|
Seems that the freeware version has already reached 1.3.
When will the commercial version reach this version which includes the sequence fix, Dwight?
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Comparing sequences
Posted:
Jun 8, 2011 12:09 PM
in response to: tkrause
|
|
|
Hi,
We have tenatively scheduled the release of v1.3.0 for the beginning of Q3. So, we are aiming for the first two weeks of September.
So far, everything looks like it is on track. We have begun our QA testing cycle, and are qualifying v.1.3.0 for release.
|
Dwight
|
|
Posts:
67
Registered:
11/24/10
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: Comparing sequences
Posted:
Aug 19, 2011 3:24 PM
in response to: tkrause
|
|
|
Okay,
Here are some updates. First, we've re-versioned TEx to v1.5.0. There are so many changes that it warrants a major version change.
We've added support for
Materialized Views and Logs.
Partitioning
Subpartitioning
Debugging
Etc.
Also, the v1.5.0 Beta has been in heavy rotation. We've been fixing bugs and listening to your feedback. So, with our release just around the corner, v1.5.0.500 is officially our first Release Candidate.
If you download the v1.5.0.500 Beta, you are going to be getting something that is very close to what the final product will be. Enjoy.
|
Dwight
|
|
|
Legend
|
|
MVP: 2501
+
pts
|
|
Guru: 2001
- 2500
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
