fix #8892 fix select statement for TaxonNodeDaoHibernateImpl.getUuidAndTitleCache()

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonNodeDaoHibernateImpl.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonNodeDaoHibernateImpl.java
index 57e80d74154635f034fa1aa64b495d89206a79d4..09270f21af6fbdec3cd02122cd9ab0a7ef1e15ed 100755 (executable)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonNodeDaoHibernateImpl.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonNodeDaoHibernateImpl.java
@@ -198,7 +198,7 @@ public class TaxonNodeDaoHibernateImpl extends AnnotatableDaoImpl<TaxonNode>
 \r
     @Override\r
     public List<UuidAndTitleCache<TaxonNode>> getUuidAndTitleCache(Integer limit, String pattern, UUID classificationUuid) {\r
-        String queryString = "SELECT tn.uuid, tn.id, t.titleCache, name, rank "\r
+        String queryString = "SELECT tn.uuid, tn.id, t.titleCache, rank "\r
                 + " FROM TaxonNode tn "\r
                        + "   INNER JOIN tn.taxon AS t "\r
                        + "   INNER JOIN tn.classification AS cls "\r
@@ -899,7 +899,7 @@ public class TaxonNodeDaoHibernateImpl extends AnnotatableDaoImpl<TaxonNode>
         int classificationId = classification.getId();\r
 \r
          String queryString =\r
-                   " SELECT nodes.uuid, nodes.id,  t.titleCache, name, rank"\r
+                   " SELECT nodes.uuid, nodes.id,  t.titleCache, rank"\r
                    + " FROM TaxonNode AS nodes "\r
                    + "   JOIN nodes.taxon as t " // FIXME why not inner join here?\r
                    + "   INNER JOIN t.name AS name "\r