Duplicated rows when select from a tabla with PK. STRANGE

[Hernan H]

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