Details
-
Type: Bug
-
Status: Closed
-
Priority: Critical
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.3.0
-
Component/s: None
-
Labels:None
-
Environment:
Project: SMB-DL
Build : core-smb-data-loader-ui-1.3.1(p166)
Server : SMB-DL-QA (192.168.70.67)
Application link : http://192.168.70.67:8080/core-smb-data-loader-ui-1.3.1/
Description
When same file is uploaded twice then it inserts duplicate entry in the table.
Step 1: Click Local File tab, click browse and upload a Sample_business_location.csv file.
Step 2: Click Load button.
Step 3: Select Staging Area say Test and Move file from local to selected staging Area.
Step 4: Open the database and execute following queries.
> use Test;
> Show tables;
> Select count from businessLocations; # Get the count of number of rows.
> Select * from businessLocations; # Displays the records.
Step 5: Upload same file Sample_business_location.csv.
Step 6: Click Load button.
Step 7: Already Staging Area is selected Test, just Move file from local to staging Area.
Step 8: Open the database and execute following queries.
> use Test;
> Show tables;
> Select count from businessLocations; # Get the count of number of rows.
> Select * from businessLocations; # Displays the records with duplicate entries.
Actual Result
Inserting Duplicate entries in the table.
Expected Result
No Duplicate entry should happen
Please find attached file.