Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.03 » View Incident Report |
Serious |
Reported By: Ole Willy Tuv Reported On: 3/28/2007 For: Version 1.02 Build 1 |
create table t1 ( col1 char(1), col2 char(1), col3 smallint, col4 integer ); create table t2 ( col1 varchar(2), col2 varchar(2), col3 decimal(18,2), col4 float ); create table t3 ( col1 clob, col2 char(3), col3 integer, col4 double precision ); insert into t1 values ('a','a',32767,2147483647); insert into t2 values ('ab','ab',123456789012345.67,1.7E308); insert into t3 values ('abc','abc',2147483647,1.7E308); create table test as ( select * from t1 union all select * from t2 union all select * from t3 ) with data; select name column_name, type data_type, "length", scale from information.tablecolumns where tablename = 'test'
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |