Semicolon

torsten.strausstorsten.strauss Posts: 270 Silver 3
edited April 3, 2018 1:11AM in SQL Prompt
Hi redgate Team,

I though this was fixed already.
In the latest version it pops up again:

[code]

-- Create a table
DROP TABLE IF EXISTS test;
GO

CREATE TABLE test ( col1 int NOT NULL, col2 int NOT NULL );
GO
; -- This semicolon is not needed. Even it is send to a new line. Delete and reformat again ...

-- Insert 1000000 records
WITH cte
AS (  SELECT 1 AS T )
SELECT cte;
GO

[/code]

Thanks for fixing it!

Torsten

Answers

  • RichardLRichardL Posts: 417 Gold 4
    Hi @torsten.strauss

    Thanks for this. 

    Could you send us a ticket again for this one please? 

    Best

    Richard Lynch. 
    Customer Support
    Redgate Software
  • torsten.strausstorsten.strauss Posts: 270 Silver 3
    Hi Richard!

    Do I really need to send a ticket for this?
    I thought the aim of this forum is to address these issues...

    Torsten
  • torsten.strausstorsten.strauss Posts: 270 Silver 3
    Any news here?
    Thanks!
    Torsten
  • RichardLRichardL Posts: 417 Gold 4
    Hi @torsten.strauss

    Thanks again for your reply and apologies for any seemingly contradictory information. 

    I suppose the thing is that if you submit a support ticket then issues will get checked out faster than on here generally speaking. It is good though at the same time to post them here so that others with similar issues can see it and help or see what help is being given on here. 

    If you'd like, when you raise these in future I could make a ticket for you as well? 

    Let me know what you think. 

    Kind regards

    Richard Lynch. 
    Customer Support
    Redgate Software
  • torsten.strausstorsten.strauss Posts: 270 Silver 3
    Hi Richard!

    I mean if other customers will always create a ticket as well as posting the issues here for sure I will do the same.
    Would be nice if you can give me a hint where I can raise a ticket- thanks!

    Torsten
  • This still an issue.
    Can we expect to see a fix?

    Thanks!

    Torsten
    MVP Data Platform
  • kalokalo Posts: 88 Bronze 5
    edited July 26, 2018 2:44PM
    Hi Torsten,

    I for one have adopted the strategy of posting question and submitting request if I find what i think is a bug - the question might make other users aware of it and the request should get it looked at quicker.

    I can't always find my support list so rely on the links in the emails that get sent, but when you ask a question it does give an option to send a ticket


    https://productsupport.red-gate.com/hc/en-us



  • Why do I have to raise a ticket here?
    I mean what is different to the other requests / posts here.
    Btw the link will give the following ;

    oops

    The page you were looking for doesn't exist

    You may have mistyped the address or the page may have moved

    Take me back to the home page

  • kalokalo Posts: 88 Bronze 5
    edited July 26, 2018 2:53PM
    apologies, edited the link, i'd missed off the h

    i guess the forum is an opportunity to discuss with other users as well as redgate support, as people might be able to offer workarounds or provide more evidence that the issue exists (persists in other versions).
    whereas in your case, if i understand correctly, you are suggesting a fix has been undone - so that would warrant a service request (if you have a support contract) because it should be prioritised.

    i suppose what might be good - to save us typing the same thing twice - is a convert question to request button.

    regards.
Sign In or Register to comment.