I encountered an error executing a CREATE PROCEDURE statement and burned it down to the following example:
create procedure CommentTest
as
begin
-- a comment's text may not contain any single quotes
select 1 from dummy
end
If I try to execute that with ISQL (Java) 11.0.1.2467 it gives me an error:
Could not execute statement.
Syntax error or access violation
SQLCODE=0, ODBC 3 State="42000"
The same statement works with the C-Version of ISQL (dbisqlc.exe).
Might I call this a bug or a feature?
asked
18 Aug '10, 13:00
Reimer Pods
4.5k●38●48●91
accept rate:
11%
Works for me, in the dbisql that ships with 11.0.1.2276 and 12.0.0.2483. What version are you using? FWIW I have bazillions of -- comments containing embedded quotes, never a problem.
Fine in 10.0.1.3931
Must be version specific, it works too in 12.00.2483
Works on 11.0.1.2467
@Vincent: Please re-confirm that Reimer's exact procedure (which is in Transact SQL syntax) works for you on 11.0.1.2467... since that fails for Reimer.
@Breck: I copied and executed Reimer's code above on 11.0.1.2467 without a glitch. I also have tons of comments with single quotes in them