MOD function for INT8

Posted in 2007

san — Wed, 28 Mar 2007 10:29:06 +0400 — source: Usenet: comp.databases.informix

Have some strange result: SELECT MOD(source, 4294967296) FROM some_table always returns 0 regadless of source value, where source is INT8 with values more than 4294967296, 4294967296 is MAX_UINT If I replace 4294967296 with 4294967295 or 4294967297, it works right. I use IDS 9.40 UC2 on Suse Linux 9.2 -- Andrew Svihnushin Email: san@inist.ru Software developer, INIST Ltd.