Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Code Block corrupts my SQL

Jerry Chappell February 20, 2019

What's up with the <Code> block feature? If I paste my SQL code into a description field, like this....

 

CREATE PROC [dbo].[TestMostRecent]
(
@location varchar(50),
@tsn varchar(10),
@records int = 1
)
AS
BEGIN
RETURN 0
END

 

And then specify that it's SQL, and click Save.

When I come back into it, and copy it to my clipboard, it comes out fine (apparently), but it must include some bad characters because it no longer parses in SQL Server Management Studio saying there are errors...

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '‌'.

2 answers

0 votes
Jerry Chappell February 25, 2019

This issue is my first one, since starting to pay for Jira. Does anyone have an estimate on how long it takes for Atlassian to support me?

0 votes
Jerry Chappell February 20, 2019

Here's a bit more information -- it works fine if I specify that it's SQL when I first put in the code. But if I put Java (or don't put any language), and later change it to SQL, then the text is corrupted and there's no way to ever get it back to runnable. I'm worried that I've already lost a lot of SQL scripts that I assumed were being saved... re-typing them is going to be brutal.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25 europe, atlassian event, barcelona 2025, jira, confluence, atlassian intelligence, rovo, ai-powered collaboration, developer tools, agile teams, digital transformation, teamwork solutions, atlassian conference, product announcements

🌆 Team '25 Europe registration is now open!

Join the largest European gathering of the Atlassian Community and reimagine what’s possible when great teams and transformative technology come together. Plus, grab your Super Fan ticket now and save over €1,000 on your pass before prices rise on 3 June.

Register now
AUG Leaders

Atlassian Community Events