Compiler error for assignment variable to empty string which is enclosed in
DOUBLE QUOTES differ in 3.0 vs previous versions.
-----------------------------------------------------------------------------------------------------------------------------
Key: CORE-5211
URL: http://tracker.firebirdsql.org/browse/CORE-5211
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 3.0.0, 4.0 Initial
Reporter: Pavel Zotov
Priority: Minor
Consider script which shoud raise compiler error (because of DOUBLE quotes in
assignment):
set term ^;
execute block returns(o varchar(10)) as
begin
o = "qwe";
end
^
If you run this script on 2.1, 2.5 and 3.0 you will get the same error:
===
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-qwe
===
But if we replace "qwe" with empty string ( o = ""; ) then we get:
===
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Zero length identifiers are not allowed
===
(I've checked on WI-V3.0.0.32490)
As for 2.1 and 2.5 - error will be the same, but without showing value empty
string (though this could be clarified by something like <EMPTY>):
===
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
===
Can the message "-Zero length identifiers are not allowed" be replaced with old
one ?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
