Hi! ________________________________________ From: [email protected] [[email protected]] On Behalf Of Vincent Massol [[email protected]] Sent: 01 March 2012 22:10 To: XWiki Users Subject: Re: [xwiki-users] SQL vs HQL cross join ()
>> Hi, >> >> I haven't looked in your mail in details but maybe it's related to >> http://jira.xwiki.org/jira/browse/XWIKI-7542 It sounds like a similar issue although we are using MySQL and HQL here. I'll install a snapshot ASAP and test the query, then I'll provide more information in the pieces used here it it keeps failing. Thanks, Vincent! Ricardo >> >> -Vincent On Mar 1, 2012, at 9:52 PM, <[email protected]> <[email protected]> wrote: > Hi, > > I'm trying to get the values of two fields from xwikiattahment table with > this HQL query: > > select att.filename,att.date from xwiki.xwikiattachment att, xwiki.xwikidoc > doc where doc.fullName='Event.IIXornadaIDIS' and att.filename like > '%abstract%' and att.date > '2012-03-01' and att.docId=doc.id order by > att.filename; > > The query fails. When used to get only one field, it works fine. For > instance... > > select att.date from xwiki.xwikiattachment att, xwiki.xwikidoc doc where > doc.fullName='Event.IIXornadaIDIS' and att.filename like '%abstract%' and > att.date > '2012-03-01' and att.docId=doc.id order by att.filename; > > or > > select att.filename from xwiki.xwikiattachment att, xwiki.xwikidoc doc where > doc.fullName='Event.IIXornadaIDIS' and att.filename like '%abstract%' and > att.date > '2012-03-01' and att.docId=doc.id order by att.filename; > > and, the SQL equivalent to the in troubles query works also fine. This way... > > select att.XWA_FILENAME,att.XWA_DATE from xwiki.xwikiattachment att, > xwiki.xwikidoc doc > where doc.XWD_FULLNAME='Event.IIXornadaIDIS' and att.XWA_FILENAME like > '%abstract%' and att.XWA_DATE > '2012-03-01' and att.XWA_DOC_ID=doc.XWD_ID > order by att.XWA_FILENAME; > > Please, where am I wrong when trying select att.filename,att.date from > xwiki.xwikiattachment att,...? > > I'm running XWiki Enterprise 2.4.30451. > > Thanks for your help! > > Ricardo > > -- > Ricardo Rodríguez > Research Management and Promotion Technician > Health Research Institute of Santiago de Compostela (IDIS) > http://www.idisantiago.es > > Nota: A información contida nesta mensaxe e os seus posibles documentos > adxuntos é privada e confidencial e está dirixida únicamente ó seu > destinatario/a. Se vostede non é o/a destinatario/a orixinal desta mensaxe, > por favor elimínea. A distribución ou copia desta mensaxe non está autorizada. > > Nota: La información contenida en este mensaje y sus posibles documentos > adjuntos es privada y confidencial y está dirigida únicamente a su > destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, > por favor elimínelo. La distribución o copia de este mensaje no está > autorizada. > > See more languages: http://www.sergas.es/aviso_confidencialidad.htm > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia desta mensaxe non está autorizada. Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o copia de este mensaje no está autorizada. See more languages: http://www.sergas.es/aviso_confidencialidad.htm _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
