[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: join bug?
From: |
german rigau |
Subject: |
Re: join bug? |
Date: |
Fri, 3 Feb 2006 15:16:59 +0100 |
Hello again,
Thanks a lot for you quick reply ...
But, BOTH files were sorted previously with default options.
address@hidden BaseConcepts]$ cat kk1
ice_cream%1:13:00::
life_style%1:07:00::
part-time%3:00:00::
address@hidden BaseConcepts]$ cat kk2
ice_cream%1:13:00:: 07510835 1 1
icecream%1:13:00:: 07510835 1 0
life_style%1:07:00:: 04875322 1 2
part-time%3:00:00:: 01131371 1 21
address@hidden BaseConcepts]$ join <(sort kk1) <(sort kk2)
life_style%1:07:00:: 04875322 1 2
part-time%3:00:00:: 01131371 1 21
address@hidden BaseConcepts]$ join -v 1 <(sort kk1) <(sort kk2)
ice_cream%1:13:00::
Then, the problem is on the "sort" command because:
address@hidden BaseConcepts]$ more kk2
ice_cream%1:13:00:: 07510835 1 1
icecream%1:13:00:: 07510835 1 0
life_style%1:07:00:: 04875322 1 2
part-time%3:00:00:: 01131371 1 21
address@hidden BaseConcepts]$ sort kk2
icecream%1:13:00:: 07510835 1 0
ice_cream%1:13:00:: 07510835 1 1
life_style%1:07:00:: 04875322 1 2
part-time%3:00:00:: 01131371 1 21
In fact, adding icecream%1:13:00: in kk1 we obtain:
address@hidden BaseConcepts]$ sort kk1
ice_cream%1:13:00::
icecream%1:13:00::
life_style%1:07:00::
part-time%3:00:00::
address@hidden BaseConcepts]$ sort kk2
icecream%1:13:00:: 07510835 1 0
ice_cream%1:13:00:: 07510835 1 1
life_style%1:07:00:: 04875322 1 2
part-time%3:00:00:: 01131371 1 21
Which could be the reason to produce two different orderings??
Thanks in advance,
German
Re: join bug?, Bob Proulx, 2006/02/03
- Re: join bug?,
german rigau <=