The distinct clause in an SQL query does not work in
some cases.
For example if I had a table/file Test with one column
say name
name
sanjiv
400-522
400-523
blah
the query 'select distinct name from Test' returns
only
sanjiv
400-522
blah
For some reason it treats 400-522 and 400-523
Sanjiv Jivan wrote:
The distinct clause in an SQL query does not work in
some cases.
...
For some reason it treats 400-522 and 400-523 as the
same.
Are you running with warnings (-w)? If not, you should be. If so, you
will probably see something like this warning:
Argument 400-522
Mitch Helle-Morrissey wrote:
Maybe you are having some problems with string vs. numeric operations.
Yes. That's the problem.
I'm haven't ever used DBD::CSV, but maybe there is a quote() operator that
you can use, and send in the correct datatype?
This module (and DBD::AnyData also)