View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000487 | Database Workbench v4 | General | public | 2012-11-10 12:59 | 2013-10-24 16:43 |
Reporter | Doychin Bondzhev | Assigned To | Martijn Tonies | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Fixed in Version | 4.4.2 | ||||
Summary | 0000487: After execute prodecure result windows still displays procedure result grid when executing select statement | ||||
Description | I 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. | ||||
Tags | No tags attached. | ||||
DBMS & Version | |||||
|
What DBMS are you using? Can you give step by step instructions on how to reproduce? |
|
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. |
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 |