[Firebird-devel] [ firebird-Bugs-223516 ] Missing types in rdb$types.

[SourceForge.net <no...@so...>]

Bugs item #223516, was opened at 2000-11-26 23:10
Message generated for change (Comment added) made by seanleyne
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=223516&group_id=9028

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: DSQL
Group: Confirmed Bug
Status: Open
Resolution: None
Priority: 5
Submitted By: Claudio Valderrama C. (robocop)
Assigned to: Nobody/Anonymous (nobody)
Summary: Missing types in rdb$types.

Initial Comment:
LangRef describes among values that
rdb$fields.rdb$field_type can assume the following two:
D_FLOAT - 11
INT64 - 16
Both values appear in the documentation but not in rdb$types.
I don't have any idea what D_FLOAT is but at least INT64 should be listed in rdb$types for consistency reasons. Also, putting NUMERIC (1) and DECIMAL (2) as registered sub_types would help programs that cope with metadata.

C.


----------------------------------------------------------------------

>Comment By: Sean Leyne (seanleyne)
Date: 2005-07-09 20:20

Message:
Logged In: YES 
user_id=71163

Can this item be closed?

The entries for:

RDB$FIELD_TYPE        16  INT64
RDB$OBJECT_TYPE    12  GROUP
RDB$OBJECT_TYPE    13  ROLE

now exist.

Ivan's request for the additional items opened as a 
new/separate Feature request since the items he requests 
were not included in the original set of entries in RDB$Types.

----------------------------------------------------------------------

Comment By: Sean Leyne (seanleyne)
Date: 2005-07-09 20:19

Message:
Logged In: YES 
user_id=71163

Can this item be closed?

The entries for:

RDB$FIELD_TYPE        16  INT64
RDB$OBJECT_TYPE    12  GROUP
RDB$OBJECT_TYPE    13  ROLE

now exist.

Ivan's request for the additional items opened as a 
new/separate Feature request since the items he requests 
were not included in the original set of entries in RDB$Types.

----------------------------------------------------------------------

Comment By: Ivan Prenosil (prenosil)
Date: 2001-09-05 12:31

Message:
Logged In: YES 
user_id=89535

There are more values missing in rdb$types, e.g.

RDB$OBJECT_TYPE    12  GROUP
RDB$OBJECT_TYPE    13  ROLE

and probably these should be added too:

RDB$PARAMETER_TYPE  0  INPUT
RDB$PARAMETER_TYPE  1  OUTPUT

RDB$SYSTEM_FLAG     0  USER_DEFINED
RDB$SYSTEM_FLAG     1  SYSTEM_DEFINED

RDB$INDEX_INACTIVE  0  ACTIVE
RDB$INDEX_INACTIVE  1  INACTIVE

RDB$UNIQUE_FLAG     0  ALLOWS_DUPLICATES
RDB$UNIQUE_FLAG     1  DOES_NOT_ALLOW_DUPLICATES

RDB$TRIGGER_INACTIVE  0  ACTIVE
RDB$TRIGGER_INACTIVE  1  INACTIVE

RDB$GRANT_OPTION    0  ''
RDB$GRANT_OPTION    1  GRANT_OPTION
RDB$GRANT_OPTION    2  ADMIN_OPTION

RDB$PAGE_TYPE       1  DB_HEADER_PAGE
RDB$PAGE_TYPE       2  PIP
RDB$PAGE_TYPE       3  TIP
etc...

----------------------------------------------------------------------

Comment By: Sean Leyne (seanleyne)
Date: 2001-07-30 20:14

Message:
Logged In: YES 
user_id=71163

Database maintenance

----------------------------------------------------------------------

Comment By: Sean Leyne (seanleyne)
Date: 2001-07-30 20:09

Message:
Logged In: YES 
user_id=71163

Database maintenance

----------------------------------------------------------------------

Comment By: Claudio Valderrama C. (robocop)
Date: 2001-03-02 00:32

Message:
Logged In: YES 
user_id=62823

Also, rdb$function_arguments.rdb$mechanism becomes -1 when 
the return argument needs FREE_IT. It seems it's simply the 
negative value of rdb$mechanism logged in table rdb$types 
(in this case, 1 is by_reference).

C.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=223516&group_id=9028