View Issue Details

IDProjectCategoryView StatusLast Update
0000487Database Workbench v4Generalpublic2013-10-24 16:43
ReporterDoychin Bondzhev Assigned ToMartijn Tonies  
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


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:

  TS Numeric(18,0),
  TZ Integer)
 returns (
  TTS Timestamp)
declare days integer;
declare SEC integer;
declare MINUTES integer;
declare ts_tmp numeric(18, 0);
  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;
  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;
end ^^

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