Bugs item #2607293, was opened at 2009-02-17 00:26
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2607293&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 "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: insert into done by procedure
Initial Comment:
The following sql code in M5-SQL:
create table get_results (schem string, clust string, real_time bigint);
create procedure save_times (schem string, clust string)
BEGIN
insert into get_results select
schem ,
clust ,
id as real_time
from columns order by id limit 1;
delete from callhistory;
END;
call save_times('triples', 'pso');
select * from get_results;
drop ALL procedure save_times;
drop table get_results;
gives the following result:
the result of this code is:
[gonca...@alviss sql]$ mclient stable debug no_algebra sql < test.sql
% sys.get_results, sys.get_results, sys.get_results # table_name
% schem, clust, real_time # name
% clob, clob, bigint # type
% 7, 7, 4 # length
[ "triples", "triples", 1063 ]
[gonca...@alviss sql]$
and it should be:
[gonca...@alviss sql]$ mclient stable debug no_algebra sql < test.sql
% sys.get_results, sys.get_results, sys.get_results # table_name
% schem, clust, real_time # name
% clob, clob, bigint # type
% 7, 7, 4 # length
[ "triples", "pso", 1063 ]
[gonca...@alviss sql]$
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2009-02-17 00:37
Message:
Test added:
sql/src/test/BugTracker-2009/Tests/insert_into_done_by_procedure.SF-2607293.sql
Note: The delete statement inside the create procedure can be removed, if
not you need to load history.sql from sql/src/sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2607293&group_id=56967
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
