#897 RSyntax Editor Single Quoting is cumbersome

open
Colin Bell
5
2012-12-29
2010-08-11
Anonymous
No

Environment: Windows XP, Database:Oracle 10G, Version=3.1.2

While writing an SQL, inserting single quotes within existing text exhibits weird behavior. The single quote seems to "bring-in" the next character. For example, starting with a SQL like below:

select * from emp
where 1=1 and emp_id=1031

Modifying this SQL to below
select * from emp
where 1=1 and emp_status='RETIRED' and emp_id=1031

When the first single quote is inserted, the editor at that moment appears like below:
select * from emp
where 1=1 and emp_status=e'mp_id=1031

This did not happen with prior versions of Squirrel. This bug is also hard to explain, I hope I made it clear.

Discussion