MySQL Forums
Forum List  »  Connector/ODBC

Duplicated rows when select from a tabla with PK. STRANGE
Posted by: Hernan H
Date: March 21, 2023 11:30AM

I'm sennding a simple :

select * from myDb.myTable

the table has a PK, unique key

It returns *duplicated* entries for the same key. That's impossible


I then checked the Connector Setup, I realized the PREFETCH was enabled

When I turned it off, queries started to work



What the PREFETCH option does?


NOTE:

The server is an online replica, and the table gets several insert by second

My task is to read that replica (instead of the prod server) and send data to a data warehouse

Options: ReplyQuote


Subject
Written By
Posted
Duplicated rows when select from a tabla with PK. STRANGE
March 21, 2023 11:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.