[jira] [Updated] (TRAFODION-3322) odb incorrectly generates 0 rows in a certain scenario

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-3322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Wayne Birdsall updated TRAFODION-3322:
--------------------------------------------
    Description: 
In the following scenario, odb generates 0 rows when it should generate 5 rows.

DDL:

create table toyodb2 (a int not null, b int, c varchar(100), d varchar(100), primary key (a));

Map file (here named, try2OdbCrandFails.map):

A:SEQ:0
B:IRAND:3:12
C:DSRAND:carMakes.txt
D:CRAND:10

The file carMakes.txt contains:

Chevrolet
Dodge
Toyota
Nissan
Suzuki
Hyundai

odb command:

odb64luo -u db__root -p traf123 -d traf -l src=nofile:tgt=trafodion.sch.toyodb2:max=100:map=try2OdbCrandFails.map:rows=100:truncate

In this example, 0 rows will be generated, when 5 should have been.

If you change the map file to the following, it will succeed in generating 5 rows:

A:SEQ:0
B:IRAND:3:12
C:CRAND:10
D:DSRAND:carMakes.txt

 

 

> odb incorrectly generates 0 rows in a certain scenario
> ------------------------------------------------------
>
>                 Key: TRAFODION-3322
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3322
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: db-utility-odb
>    Affects Versions: 2.4
>            Reporter: David Wayne Birdsall
>            Priority: Major
>
> In the following scenario, odb generates 0 rows when it should generate 5 rows.
> DDL:
> create table toyodb2 (a int not null, b int, c varchar(100), d varchar(100), primary key (a));
> Map file (here named, try2OdbCrandFails.map):
> A:SEQ:0
> B:IRAND:3:12
> C:DSRAND:carMakes.txt
> D:CRAND:10
> The file carMakes.txt contains:
> Chevrolet
> Dodge
> Toyota
> Nissan
> Suzuki
> Hyundai
> odb command:
> odb64luo -u db__root -p traf123 -d traf -l src=nofile:tgt=trafodion.sch.toyodb2:max=100:map=try2OdbCrandFails.map:rows=100:truncate
> In this example, 0 rows will be generated, when 5 should have been.
> If you change the map file to the following, it will succeed in generating 5 rows:
> A:SEQ:0
> B:IRAND:3:12
> C:CRAND:10
> D:DSRAND:carMakes.txt
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)