View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000487Database Workbench v4Generalpublic2012-11-10 12:592013-10-24 16:43
ReporterDoychin Bondzhev Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version4.4.2 
Summary0000487: After execute prodecure result windows still displays procedure result grid when executing select statement
DescriptionI run one execute procedure statement that used procedure with result in Single SQL editor.

Result tab displayed grid with result of procedure execution.

After that I run select statement but result set grid was not displayed until I changed the tab to something else and then returned it back to Result Tab.
TagsNo tags attached.
DBMS & Version

Activities

Martijn Tonies

2013-09-11 12:01

administrator   ~0000225

What DBMS are you using? Can you give step by step instructions on how to reproduce?

Doychin Bondzhev

2013-09-11 13:21

reporter   ~0000229

This is with firebird 2.1.x

Create test database.
Create this procedure in database:

SET TERM ^^ ;
CREATE PROCEDURE P_FROM_UNIXTIME (
  TS Numeric(18,0),
  TZ Integer)
 returns (
  TTS Timestamp)
AS
declare days integer;
declare SEC integer;
declare MINUTES integer;
declare HOURS INTEGER;
declare ts_tmp numeric(18, 0);
begin
  ts_tmp = ts;
  ts_tmp = ts_tmp + tz * 3600 * 1000;
  ts_tmp = ts_tmp / 1000;
  days = ts_tmp/3600/24;
  select dateadd(day, :days, cast ('01-01-1970' as timestamp)) from rdb$database into :tts;
  if (extract(month from tts) between 4 and 11) then begin
    tz = tz + 1;
    ts_tmp = ts;
    ts_tmp = ts_tmp + tz * 3600 * 1000;
    ts_tmp = ts_tmp / 1000;
  end
  SEC = mod(ts_tmp, 60);
  MINUTES = mod(ts_tmp/60, 60);
  HOURS = mod(ts_tmp/3600, 24);
  days = ts_tmp/3600/24;
  select dateadd(day, :days, cast ('01-01-1970' as timestamp)) from rdb$database into :tts;
  select dateadd(hour, :HOURS, :tts) from rdb$database into :tts;
  select dateadd(minute, :MINUTES, :tts) from rdb$database into :tts;
  select dateadd(second, :SEC, :tts) from rdb$database into :tts;
  suspend;
end ^^
SET TERM ; ^^


No add one table with single column and add one row in to that table.

open Sing SQL window.

first run this:

execute procedure P_FROM_UNIXTIME(0, 1)

you will see a grid that displays the result of procedure execution.

Now run:
select * from testtable

you will see that result tab still shows the result of stored procedure. Switch to another tab and then return back to result.

Issue History

Date Modified Username Field Change
2012-11-10 12:59 Doychin Bondzhev New Issue
2012-11-13 16:14 Martijn Tonies Status new => acknowledged
2013-06-25 14:09 Martijn Tonies Category SQL & Parameter Insight => General
2013-09-11 12:01 Martijn Tonies Note Added: 0000225
2013-09-11 12:01 Martijn Tonies Status acknowledged => feedback
2013-09-11 13:21 Doychin Bondzhev Note Added: 0000229
2013-09-11 13:21 Doychin Bondzhev Status feedback => new
2013-09-11 14:36 Martijn Tonies Status new => resolved
2013-09-11 14:36 Martijn Tonies Fixed in Version => 4.4.2
2013-09-11 14:36 Martijn Tonies Resolution open => fixed
2013-09-11 14:36 Martijn Tonies Assigned To => Martijn Tonies
2013-10-24 16:43 Martijn Tonies Status resolved => closed