[Modeling-users] Double Result

[Yannick G. <yan...@sa...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi, I think that something is broken with the MySQL SQL.  I mean, I think t=
hat=20
MySQL is broken but I have to use it and I wonder if the framework can help=
=2E =20
The fetch spec :=20

 ((codelike**) AND (isActive!=3D-255) AND (i18n.titlelike*ABC*))

gives me the my 2 rows twice :=20

Evaluating: SELECT t0.activity_id, t0.code, t0.enterprise_id, t0.is_active=
=20
=46ROM ABCI18N t1 INNER JOIN ABC t0 ON ( t0.activity_id=3Dt1.activity_id ) =
 WHERE=20
(t0.code LIKE '%%' AND t0.is_active <> -255 AND t1.title LIKE '%ABC%')
rowcount: 4 Returning: {'activityId': 1L, 'code': 'ABC009', 'enterpriseId':=
=20
1L, 'isActive': 1L}
rowcount: 4 Returning: {'activityId': 1L, 'code': 'ABC009', 'enterpriseId':=
=20
1L, 'isActive': 1L}
rowcount: 4 Returning: {'activityId': 2L, 'code': 'ABC123', 'enterpriseId':=
=20
1L, 'isActive': 1L}
rowcount: 4 Returning: {'activityId': 2L, 'code': 'ABC123', 'enterpriseId':=
=20
1L, 'isActive': 1L}

MySQL returns 4 rows with the same select typed at the prompt.  Is
there anything that I can do to prevent the duplication ?

Thanks in advance !

=2D --=20
Yannick Gingras
Byte Gardener, Savoir-faire Linux inc.
(514) 276-5468

=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/JtAjrhy5Fqn/MRARAlMjAJ0eaFrARN9Z4CZtciN5z16eHNsNdgCdFIXT
n+7h7wwmFLECQsBBkFo7ENs=3D
=3DNxDq
=2D----END PGP SIGNATURE-----