[TRAFODION-2670] when I copy data from oracle table to trafodion table with max for limit rows， but the result rows in trafodion table is differ with max rows , and without any error.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: any
• Fix Version/s: 2.3
• Component/s: db-utility-odb
• Assignee: Unassigned
• Reporter: pengpeng.yang
• Created: 28/Jun/17 01:57
• Updated: 23/Oct/17 09:57
• Resolved: 23/Oct/17 09:57

Description

Example
odb64luo -u oracle_username:trafodion_username -p oracle_passwd:trafodion_passwd -d oracle_schema:traf_schema -cp src=CUSTOMER_ADDRESS:tgt=TRAFODION.ODB_COPY.CUSTOMER_ADDRESS_9:pwhere='CA_ADDRESS_SK>100000':parallel=8:rows=5000:max=500000:commit=auto -v
I set max is 500000, but Wher I execute statement "select count(*) from ODB_COPY.CUSTOMER_ADDRESS_9", the result is 520000.

Issue Links

• duplicates: TRAFODION-2346 odb copy 510k rows while set parameter max 500k
• duplicates: TRAFODION-2373 odb load 500k rows while set parameter max 505k