Inside a comment block (either -- or /* */) -and in strings- SQL Prompt needs to stop doing things like putting in a second single-quote when you type in a single-quote.
I was writing a long comment between /* and */ and tried to type
... There's
and it came out as
... There's'
I was writing a long comment between /* and */ and tried to type
... There's
and it came out as
... There's'