sfst - 2013-10-07

An odd number of apostrophes causes problems. My problem is in reverse, I don't have parameters in my select, but SQuirreL sees it different:

--One apostrophe ' in this comment causes being prompted for parameter values
--only blank values work; consequently no minutes or seconds are shown
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') FROM dual;

/* such comments stuck to the SQL make it fail,
even if the multi-line comment removal for Oracle is checked */
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') FROM dual;

--works fine:
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') /* some info */ FROM dual;

--fails
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') /* some info ' */ FROM dual;

--works fine:
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') --some info '
FROM dual;

The single SELECT commands are not a real problem, but when writing procedures I prefer heavy commenting, which brought up the problem.

My current workaround is not using any apostrophes in the comments or make their number even in each comment block.

I agree: low priority