Re: DBI: select distinct returns same values

[Anonymous Monk]

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";.

[Anonymous Monk]

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.

[tukusejssirs]

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!