Sven Köhler wrote: > > this query seems to shutdown SAPDB 7.3.0.30 > > SELECT a.name,b.spalte,b.reihenfolge,c.box, > concat(d.url_prefix,a.prefix) as prefix > from ib_data_infoboxen_gruppe a > left join ib_data_infoboxen_config b on > (a.id_infobox_gruppe=b.id_infobox_gruppe) > left join ib_data_infoboxen c on (b.id_infobox=c.id_infobox && > c.aktiv=true ) > order by a.id_infobox_gruppe,b.reihenfolge > > i don't know why, but replacing the "&&" with "AND" helps. > i know that "&&" is not correct, and it was just a typo. >
Thank you for reporting this bug. It will be fixed with the next patches (probably 7.3.0.33 and 7.4.3.11) Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
