Re: DBI: select distinct returns same values

You might try replacing push( @all_rows, $ref ); with push( @all_rows, [ @$ref ] );.

The DBI docs for fetchrow_arrayref() say "Note that the same array reference is returned for each fetch, so don't store the reference and then use it after a later fetch.".

The [ @$ref ] effectively does a shallow clone of $ref, so you should get distinct values again. Of course, if it were me I would push $ref->[0], and then in the following foreach loop just print "$row_ref\n";.

Comment on Re: DBI: select distinct returns same values Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI: select distinct returns same values by Anonymous Monk on Sep 21, 2019 at 14:48 UTC
This is correct: your results-array contains three references to the same result record. That is why you see three copies of the last row. (The SQL query is presented as literal text and you have already showed us what the result is.) You must make a deep copy of each row that is returned ... or, simply skip the step of putting them into a separate array entirely and work directly from the first loop.	[reply]
Re^3: DBI: select distinct returns same values by tukusejssirs (Beadle) on Sep 21, 2019 at 15:37 UTC
AnomalousMonk: Sorry I have done againt the site rules. I’ll mend my ways, I promiss! :) Anonymous Monk: You are right about the `push(@all_rows, [@$ref])`. It really fixed the output. Thanks!	[reply] [d/l]