View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000510 | Database Workbench v4 | Firebird Module | public | 2013-01-17 11:17 | 2013-04-24 12:47 |
| Reporter | Jacek Laskowski | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| OS | Windows 7 x64 | ||||
| Fixed in Version | 4.4.0 | ||||
| Summary | 0000510: Problem with SP debuger | ||||
| Description | I have two SP: SET TERM ^^ ; CREATE PROCEDURE P_DATA_HASH ( NAZWA VarChar(250), ULICA VarChar(60), MIEJSCOWOSC VarChar(50), KODRAW VarChar(20), POCZTA VarChar(50), KRAJ VarChar(50), TELEFONSTAC VarChar(22), TELEFONKOM VarChar(22), EMAIL VarChar(65)) returns ( HASZDANYCH D_VARCHAR32) AS DECLARE VARIABLE DANE VARCHAR(250); BEGIN DANE = ''; IF (NAZWA IS NOT NULL) THEN DANE = DANE || NAZWA; IF (ULICA IS NOT NULL) THEN DANE = DANE || ULICA; IF (MIEJSCOWOSC IS NOT NULL) THEN DANE = DANE || MIEJSCOWOSC; IF (KODRAW IS NOT NULL) THEN DANE = DANE || KODRAW; IF (POCZTA IS NOT NULL) THEN DANE = DANE || POCZTA; IF (KRAJ IS NOT NULL) THEN DANE = DANE || KRAJ; IF (TELEFONSTAC IS NOT NULL) THEN DANE = DANE || TELEFONSTAC; IF (TELEFONKOM IS NOT NULL) THEN DANE = DANE || TELEFONKOM; IF (EMAIL IS NOT NULL) THEN DANE = DANE || EMAIL; HASZDANYCH = HASH(DANE); SUSPEND; END ^^ SET TERM ; ^^ SET TERM ^^ ; CREATE PROCEDURE P_TEST_DEBUG ( IDFIRMY Integer, UUID VarChar(32), NIP VarChar(20), IDREGIONU Integer, UWAGI VarChar(250), NAME VarChar(250), STREET VarChar(60), CITY VarChar(50), CODE VarChar(5), POST VarChar(50), COUNTRY VarChar(50), PHONE VarChar(22), PHONEMOB VarChar(22), EMAIL VarChar(65), ACTUAL Date) returns ( IDKONTRAHENTA D_FOREIGN_KEY, IDDANYCHKONTRAHENTA D_FOREIGN_KEY) AS DECLARE VARIABLE DATAHASH BIGINT; BEGIN SELECT HASZDANYCH FROM P_DATA_HASH(:NAME, :STREET, :CITY, :CODE, :POST, :COUNTRY, :PHONE, :PHONEMOB, :EMAIL) INTO :DATAHASH; SUSPEND; END ^^ SET TERM ; ^^ The problem occurs during execute the procedure P_TEST_DEBUG in SP debugger. Calling P_DATA_HASH (inside P_TEST_DEBUG) with parameters set to NULL causing crash. See screencast in attached video file. | ||||
| Tags | No tags attached. | ||||
| DBMS & Version | |||||
|
|
Mantis rejected the attached file :( I uploaded movie to youtube, please see: http://www.youtube.com/watch?v=eBH_puolV20 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-01-17 11:17 | Jacek Laskowski | New Issue | |
| 2013-01-17 11:24 | Jacek Laskowski | Note Added: 0000161 | |
| 2013-01-21 16:11 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2013-01-21 16:11 | Martijn Tonies | Status | new => assigned |
| 2013-01-22 13:25 | Martijn Tonies | Status | assigned => resolved |
| 2013-01-22 13:25 | Martijn Tonies | Fixed in Version | => 4.4.0 |
| 2013-01-22 13:25 | Martijn Tonies | Resolution | open => fixed |
| 2013-04-24 12:47 | Martijn Tonies | Status | resolved => closed |
