Menu

#48 [Perl]Precision's return values about int, float and numeric are not correct

open
nobody
None
5
2011-12-31
2011-12-31
Jira Trac
No

Test Build:CUBRID 2008 R4.0 (8.4.0.2019) (64bit release build for linux_gnu)
OS: Linux 64
Description: Precision's return values about int, float and numeric are not correct

Repro Steps:
perl precision_01.pl

statements in precision_01.pl:
$dbh - do(create table tb (id int, bgi bigint, name varchar(1),dc numeric(5,4),ft float(5) );)
my $sth=$dbh-prepare(select * from tb) or die prepare error: $dbh-errstr;
$sth-execute() or die execute error: $dbh-errstr;

my $fieldNumber=$sth-{NUM_OF_FIELDS};
print Number of field is $fieldNumber\n;

for (my $i=0;$i$fieldNumber; $i++){
print name: $sth-{NAME}-[$i]\n;
print type: $sth-{TYPE}-[$i]\n;
print precision: $sth-{PRECISION}-[$i]\n\n\n;
}

Actual result:
{noformat}
name: id
type: 8
precision: 0

name: bgi
type: 21
precision: 0

name: name
type: 2
precision: 1

name: dc
type: 7
precision: 5

name: ft
type: 11
precision: 0
{noformat}

Expect result:
{noformat}
name: id
type: 8
precision: 11

name: bgi
type: 21
precision: 20

name: name
type: 2
precision: 1

name: dc
type: 7
precision: 7

name: ft
type: 11
precision: 12
{noformat}

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.