[ 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)