[TRAFODION-3322] odb incorrectly generates 0 rows in a certain scenario

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4
• Component/s: db-utility-odb
• Assignee: Unassigned
• Reporter: Dave Birdsall
• Created: 07/Aug/19 20:55
• Updated: 07/Aug/19 21:18

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