Comments in a view DDL that follow last byte of query aren't included in this
view source
-----------------------------------------------------------------------------------------
Key: CORE-5013
URL: http://tracker.firebirdsql.org/browse/CORE-5013
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Beta 2
Reporter: Pavel Zotov
Test:
====
create or alter view v_bar as select 2 id from rdb$database where 1=1 -- and 2=2
-- ... plus very clever comment after the last line of query
-- but before semicolon, so it should be saved in our database.
;
commit;
Run:
====
C:\MIX\firebird\fb30\isql /3333:e30 -i createview.sql &
C:\MIX\firebird\fb30\isql /3333:e30 -x
Output:
======
SET SQL DIALECT 3;
/* CREATE DATABASE '/3333:e30' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE; */
COMMIT WORK;
/* View: V_BAR, Owner: SYSDBA */
CREATE VIEW V_BAR (ID) AS
select 2 id from rdb$database where 1=1;
===
Following lines missed in the script that is received by ISQL -X:
-- and 2=2
-- ... plus very clever comment after the last line of query
-- but before semicolon, so it should be saved in our database.
PS. WI-V3.0.0.32157
--
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
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
