EXT / MASTERLINE BRETAUD Eric wrote: > > select MOD(10/3,3) from dual > -3016, Invalid numeric constant > > and > > select MOD(10+0/3,3) from dual > 1 > > Works fine if I had +0 before / > so, is it a bug or something else ?
MOD is only allowed for integer, this is not said in the docu very explicit, only by using this sentence: Operands are integers, operators are DIV, MOD The first mod is a 3.3333333333 MOD 3 (first is no integer--> error) The second mod is a 10 MOD 3 (both are integer--> working ok) --> your both mods look equal at the first glance, but try to do different things. It is not just a case of +0. Therefore I do not agree this being a bug, this is a feature whose restrictions could be written a liitle bit more clearly. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
