dynamobi/dynamobi — Issue #212: [LDB-109] dba_columns not showing decimal precision/scale
Author: dynamobi-build
Created: 2011-12-30 02:22:17+00:00
State: open
Labels: LDB

[reporter="jvs", created="Fri, 23 Jun 2006 10:05:26 -0500 (GMT-05:00)"]
create schema s;

create table s.ttt(i decimal(5,3), c char(1));

0: jdbc:luciddb:> select * from sys_root.dba_columns where table_name='TT';

+---------------+--------------+-------------+--------------+-------------------+-----------+------------+-------------+--------------+----------+---------------------+---------------------------------------+

| CATALOG_NAME | SCHEMA_NAME | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | DATATYPE | PRECISION | DEC_DIGITS | IS_NULLABLE | REMARKS |MOFID| LINEAGEID |

+---------------+--------------+-------------+--------------+-------------------+-----------+------------+-------------+--------------+----------+---------------------+---------------------------------------+

| LOCALDB | S | TT | I | 1 | DECIMAL | | | YES | | j:0000000000006473 | dbc98f7a-bfc6-43f9-8514-5786d33c5f6d |

| LOCALDB | S | TT | C | 2 | CHAR | 1 | | YES | | j:0000000000006476 | de416778-8f02-4b30-9676-21b9cad5326e |

+---------------+--------------+-------------+--------------+-------------------+-----------+------------+-------------+--------------+----------+---------------------+---------------------------------------+