general error 800 - implicit SERVERDB restart

[Sven Köhler]

hi,

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.


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general