2 Replies Latest reply on Apr 27, 2010 2:42 AM by Armando Flores Ibarra

    Composite Key + Mysql + EntityQuery broken in Seam 2.1.2

    Matthew Lueck Newbie

      getCountEjbql() appears to have changed from 2.1.1.GA to 2.1.2.  Hibernate is generating invalid SQL when asking for a count on an object with a composite key:


      2009-06-15 12:21:50,250 INFO  [STDOUT] Hibernate: 
          select
              count((externalag0_.cd_ExtRef,
              externalag0_.cd_External_Office,
              externalag0_.cd_Source)) as col_0_0_ 
          from
              uhp.external_agent externalag0_ limit ?
      2009-06-15 12:21:50,251 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1241, SQLState: 21000
      2009-06-15 12:21:50,251 ERROR [org.hibernate.util.JDBCExceptionReporter] Operand should contain 1 column(s)
      2009-06-15 12:21:50,253 ERROR [STDERR] Jun 15, 2009 12:21:50 PM com.sun.facelets.FaceletViewHandler handleRenderException
      


      This was not the behavoir in 2.1.1.GA.  2.1.2 breaks backward compatibility.