From 09a8a6234145c907e290515f71f525be8f0a4eae Mon Sep 17 00:00:00 2001
From: Raphael Marichez <falco@m4x.org>
Date: Sun, 5 Dec 2004 16:32:25 +0000
Subject: [PATCH] bug bestalias homonymes

git-archimport-id: opensource@polytechnique.org--2005/platal--mainline--0.9--patch-52
---
 upgrade/0.9.3/10_aliases.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/upgrade/0.9.3/10_aliases.sql b/upgrade/0.9.3/10_aliases.sql
index a8d8471..4217921 100644
--- a/upgrade/0.9.3/10_aliases.sql
+++ b/upgrade/0.9.3/10_aliases.sql
@@ -5,6 +5,7 @@ alter table aliases change column type type enum('a_vie','alias','homonyme','lis
 alter table aliases add index (flags);
 
     update  aliases AS a
-left  join  aliases AS b ON(a.id=b.id and b.alias like '%.%' and length(b.alias)<length(a.alias))
+left  join  aliases AS b 
+	ON(a.id=b.id and b.alias like '%.%' and length(b.alias)<length(a.alias) and b.type!='homonyme')
        set  a.flags=CONCAT(a.flags,',bestalias')
-     where  a.alias LIKE '%.%' and b.alias IS NULL and a.type!='homonyme' and b.type!='homonyme';
+     where  a.alias LIKE '%.%' and b.alias IS NULL and a.type!='homonyme';
-- 
2.1.4