Forums

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

Confluence document fails to save after pasting SQL script

Shneor Cheshin
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 5, 2020

Hello,

I have this strange behaviour which I am not able to solve.

  • When I copy & paste a SQL script to a document, it fails to update/save. Also with plain text
  • Inside a code block or outside
  • If I type in the code, everything is OK.
  • Copy and paste of other codes are fine (tried Java for example)

After debugging, I found 1 SQL script that fails and another very similar that passes. Please note the 'keyword' string in the query.

Fails

SELECT COUNT(DISTINCT uuid.keyword) as count FROM "monitoring*" WHERE resolved.keyword = 'false'

In the screenshot movie, you can see that from status "changes saved" it goes to "can't save changes"  (bottom right status).

Pass

SELECT COUNT(DISTINCT uuid.keyword) as count FROM "monitoring*" WHERE resolved = 'false'

In the screenshot movie , you can see that after I paste the code it is saved (bottom right status)

Any ideas of the root cause and the solution?

Cheers!

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events