isql hangs when trying to show a view based on a procedure
----------------------------------------------------------
Key: CORE-2735
URL:
http://tracker.firebirdsql.org/browse/CORE-2735 Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0 Alpha 1
Reporter: Claudio Valderrama C.
SQL> set term ^;
SQL> create procedure p returns(a int) as begin a = 9; suspend; end^
SQL> create view vp1 as select a from p^
SQL> set term ;^
SQL> show view vp1;
A INTEGER^C
(had to be killed and hence the ^C in the output).
The reason is that isql is not prepared to find view field's sources in procedures and therefore ISQL_get_base_column_null_flag (called by ISQL_get_null_flag and this by show_table) goes in an infinite loop. The code should indicate to the caller when it can't find the required field.
The code should check also procedure parameters. I continue thinking that putting the type of source field in rdb$view_relations would simplify code in the long term and we would know where to check instead of digging in tables and procedures and who knows what else more in the future.
--
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
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.
http://p.sf.net/sfu/bobj-julyFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
