Subject | Re: [ib-support] System Table Inconsistency in IB6? |
---|---|

Author | Helen Borrie |

Post date | 2001-05-27T23:28:47Z |

At 10:54 PM 27-05-01 +0100, you wrote:

BLOB - 261

CHAR - 14

CSTRING - 40

D_FLOAT - 11

DOUBLE - 27

FLOAT - 10

INT64 - 16

INTEGER - 8

QUAD - 9

SMALLINT - 7

DATE - 12

(dialect 3 DATE)

TIME - 13

TIMESTAMP - 35

(DATE in older versions)

VARCHAR - 37

There's an inconsistency somewhere. Here is the output from the same query, over a 5.6 database:

14 TEXT

7 SHORT

8 LONG

9 QUAD

10 FLOAT

27 DOUBLE

35 DATE

37 VARYING

261 BLOB

40 CSTRING

45 BLOB_ID

So - if QUAD is numeric(18,0), what was it doing in 5.6?

More puzzles...

Helen

All for Open and Open for All

InterBase Developer Initiative · http://www.interbase2000.org

_______________________________________________________

>Thanks for the info Ann. However it beings to look as if there *really* is an inconsistancy in the system tables.According to the ib6 docs, the field type enumeration is as follows:

>

>In rdb$types the value for an INT64 field (ie QUAD) is 9.

>

>However a field defined as say numeric(18) (ie an INT64 field) has a value of 16 in rdb$fields.rdb$field_type.

>

>16 does not appear in rdb$types.

>

>Thanks, Andy.

BLOB - 261

CHAR - 14

CSTRING - 40

D_FLOAT - 11

DOUBLE - 27

FLOAT - 10

INT64 - 16

INTEGER - 8

QUAD - 9

SMALLINT - 7

DATE - 12

(dialect 3 DATE)

TIME - 13

TIMESTAMP - 35

(DATE in older versions)

VARCHAR - 37

There's an inconsistency somewhere. Here is the output from the same query, over a 5.6 database:

14 TEXT

7 SHORT

8 LONG

9 QUAD

10 FLOAT

27 DOUBLE

35 DATE

37 VARYING

261 BLOB

40 CSTRING

45 BLOB_ID

So - if QUAD is numeric(18,0), what was it doing in 5.6?

More puzzles...

Helen

All for Open and Open for All

InterBase Developer Initiative · http://www.interbase2000.org

_______________________________________________________