Comments
Sort by recent activity
Hello Paul,
i fully understand you, i'm developer too [image] . And our users are as exacting to me as i am to you.
Just small advise: as long as you know about issues with GEOMETRY/GEOGRAPHY data types, cannt you make hot fix, which shows warning about problems possible, when user tries to "smart rename" such column?
Regarding, prev issue i reported (identity values are screwed after "smart rename") - it's super easy to fix. It as simple as adding "SET IDENTITY_INSERT ON" statement to script generated. Why this fix was not incorporated in latest update?
Best regards,
Dmitry Gokun. / comments
Hello Paul,
i fully understand you, i'm developer too . And our users are as exacting to me as i am to you.
Just small advise: as long as you know about issues with GEOMETRY/GEOGRAPHY data types, c...
CodantiM wrote:
I don't know if you have looked through the forum history much, but I have complained about the lack of bugs getting fixed unless they cause a crash or a lot of people complain about them. So don't hold your breath for this being fixed anytime soon. (I still have open bugs from years ago that were reported against SQL Prompt 3.x and 4.x.)
Okay, thanks for information. This is really important to know. / comments
CodantiM wrote:
I don't know if you have looked through the forum history much, but I have complained about the lack of bugs getting fixed unless they cause a crash or a lot of people complain a...
Hello,
may thanks for finally replying. First of all, i want to make this discussion public. It's not only me who interested in this, so other user also need to know what's going on and what they should be aware of when using SQL Prompt.
I made small investigation. What is found is that smart rename works very bad with GEOMETRY & GEOGRAPHY data types. I'm not sure if it's new bug or it was present in prev versions as well - i have no way to check.
Here's script: CREATE DATABASE TestSmartRename
GO
USE TestSmartRename
GO
CREATE TABLE Test
(
UglyName GEOMETRY NOT NULL
)
GO
CREATE PROCEDURE SP1
AS
SELECT
UglyName
FROM
Test
GO
CREATE PROCEDURE SP2
AS
SELECT
UglyName.STX,
UglyName.STY
FROM
Test
GO
CREATE PROCEDURE SP3
(
@Point GEOMETRY
)
AS
SELECT
*
FROM
Test
WHERE
UglyName.STDistance(@Point) < 100
GO
After running this, expand TestSmartRename database in Object Explorer, select Test table and try smart-renaming UglyName column. SQL Prompts finds only 1 usage of this field: in SP1.
Best regards,
Dmitry Gokun / comments
Hello,
may thanks for finally replying. First of all, i want to make this discussion public. It's not only me who interested in this, so other user also need to know what's going on and what they s...
Hello Anuradha,
I have logged this issue in our internal tracking system whose tracking id is SP-4010.
Is there any way for me to track issue state online?
I reported another bug (along with steps to reproduce) about a month ago - http://www.red-gate.com/MessageBoard/vi ... 8828#48828.
In private mail, you told me "I was able to reproduce the issue and hence logged this in our internal tracking system whose tracking id is SP-3975". Month is passed and i did not get any information about your team working on bug/when it's planned to be fixed.
Please understand me correct: we bought SQL Prompt for everyday use right today, not after year or two. For now, it does not work as expected and i have to manually work on every refactoring i do. So, i want to know, is it worse of waiting for bugs be fixed in near future or i just have to look around and buy another product which can do what we need right today (or write my own scripts/tools to perform tasks we need). I just need to know rough estimation for bug fixes time.
Best regards,
Dmitry. / comments
Hello Anuradha,
I have logged this issue in our internal tracking system whose tracking id is SP-4010.
Is there any way for me to track issue state online?
I reported another bug (along with ste...
Any comment?? / comments
Any comment??
Do not you think it's idiotic that we should do this magic to have bugs fixed in product we paid money for?
What i do here is simple - we will not buy RedGate's products anymore and i will storngly advise all people i know to do the same. Thanks God, there full set of competitive products on the market. / comments
Do not you think it's idiotic that we should do this magic to have bugs fixed in product we paid money for?
What i do here is simple - we will not buy RedGate's products anymore and i will storngly...
And so it goes... No fix, no forum update. Good support, guys (Y) / comments
And so it goes... No fix, no forum update. Good support, guys (Y)
Well, 11 monthes passed since i reported this problem. It's not fixed. Can you let us know if you ever have plans to fix it?
Fix is as hard as adding SET IDENTITY_INSERT ON statement to generated script.. It's very frustrating that it makes such a big problem for RedGate to fix. / comments
Well, 11 monthes passed since i reported this problem. It's not fixed. Can you let us know if you ever have plans to fix it?
Fix is as hard as adding SET IDENTITY_INSERT ON statement to generated ...
Hello Anu.
Here's sample script which creates table: CREATE TABLE Test
(
TestId INTEGER IDENTITY(1, 1) NOT NULL PRIMARY KEY,
Name NVARCHAR(MAX) NOT NULL
)
GO
INSERT INTO Test(Name) VALUES ('Name1')
GO
INSERT INTO Test(Name) VALUES ('Name2')
GO
INSERT INTO Test(Name) VALUES ('Name2')
GO
INSERT INTO Test(Name) VALUES ('Name4')
GO
DELETE FROM Test WHERE TestId = 1
GO
DELETE FROM Test WHERE TestId = 3
GO
SELECT * FROM Test
GO
After running this, you have two rows in table "Test":
TestId Name
2 Name2
4 Name4
Now, right-click TestId column in SMSS's Object Explorer and "Smart Rename..." it to "Id". After script ran, try selecting from "Test". What you get is:
Id Name
1 Name2
2 Name4
As you can see, values of identity column just renamed are screwed.
Regards,
Dmitry Gokun / comments
Hello Anu.
Here's sample script which creates table:CREATE TABLE Test
(
TestId INTEGER IDENTITY(1, 1) NOT NULL PRIMARY KEY,
Name NVARCHAR(MAX) NOT NULL
)
GO
INSERT ...
Hello Eddie,
thanks for picking up this ..
Regards,
Dmitry / comments
Hello Eddie,
thanks for picking up this ..
Regards,
Dmitry