Bugs item #1884382, was opened at 2008-02-01 13:42
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1884382&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Romulo Goncalves (romulog)
Summary: table dependency inside union...
Initial Comment:
If I create a view over a table and the reference to this table is inside a
union the dependency is not detected...
To understand better the problem run this SQL code:
create table t1 (id int);
create table t2 (id int);
create view v1 as (select * from t1
union
select * from t2);
drop table t1;
drop table t2;
drop view v1;
select * from t1;
drop table t1;
drop table t2;
The tables t1 and t2 should not be removed on the first drop statements because
view v1 depend on them...
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-02-01 17:49
Message:
Logged In: YES
user_id=1498628
Originator: YES
The bug is fixed in the following check ins:
[Monetdb-sql-checkins] sql/src/server sql_statement.mx, , 1.159, 1.160
Log Message:
o statement st_sql only has
op1->stval
for statement st_column we also need to check the statements in
op1->stval (but only when we are looking for view dependencies)...
[Monetdb-sql-checkins] sql/src/server sql_select.mx,,1.218,1.219
Modified Files:
sql_select.mx
Log Message:
When I create a statement column for table_optname
I need to insert the table in this statement and not NULL
if not, I am not able to detect tables inside a union in the view
definition...
For example:
create view as (select * from t1 UNION select * from t2);
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-02-01 13:45
Message:
Logged In: YES
user_id=1498628
Originator: YES
Test added in:
sql/src/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1884382&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
