View Issue Details

IDProjectCategoryView StatusLast Update
0000437Database Workbench v4Firebird Modulepublic2013-01-22 12:34
Reportermacma Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version4.4.0 
Summary0000437: Create SUID procedure - wrong type with BLOB fields
DescriptionCreating SUID procedure for table with text blob filed I get

CREATE PROCEDURE E_RAPORTY_S RETURNS (
    I_TYPEID_RAPORTU Integer,
    I_ID_RAPORTU Integer,
    C_TYTUL VarChar(512),
    C_OPIS VarChar(32765),
    C_GUID Char(38),
    SI_DEFAULT SmallInt,
    B_RAPORT BLOB(text) )

Firebird complain "Dynamic SQL Error SQL error code = -104 Token unknown - line , column 19 text"
Should be "B_RAPORT BLOB SUB_TYPE 1" at least with FB 2.1
TagsNo tags attached.
DBMS & Version

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-08-24 07:12 macma New Issue
2012-08-27 09:31 Martijn Tonies Status new => acknowledged
2012-11-01 14:53 Martijn Tonies Assigned To => Martijn Tonies
2012-11-01 14:53 Martijn Tonies Status acknowledged => assigned
2012-11-02 09:59 Martijn Tonies Issue cloned: 0000483
2012-11-02 10:25 Martijn Tonies Status assigned => resolved
2012-11-02 10:25 Martijn Tonies Fixed in Version => 4.3.2
2012-11-02 10:25 Martijn Tonies Resolution open => fixed
2013-01-22 12:34 Martijn Tonies Status resolved => closed