The query was running ok until I added the "(select zs.lng+zd.lng from dual)" subquery
why didn't you just use zs.lng+zd.lng instead of the sub-select?
here's a much smaller test-case ;-) (btw: the table a is the one from my last bug-report *g*)
crashes: select (select id+id2 from sysdba.dual) from a works: select id+id2 from sysdba.dual
CREATE TABLE "DJH"."A"
(
"ID" Integer,
"ID2" Integer
)
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
