Warning: Table '.\dcgforum\cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://forums.dataphor.org/index.php?q=node/38' in C:\Sites\DCGForum\includes\database.mysql.inc on line 172
iDiv Oracle mapping is wrong | Dataphor Forums

iDiv Oracle mapping is wrong

For OracleDevice, iDiv(Decimal, Decimal) is mapped as floor(cast(ALeftValue as decimal) / cast(ARightValue as decimal)). This is wrong, since cast(x as decimal) rounds x to the nearest integer. Thus, 29.8 div 5 is 6 on OracleDevice, not 5.

Mappings Fixed

Hi Jon,

Thanks for the post, I have corrected the mappings in both the Oracle and MSSQL devices. They no longer cast their arguments.

Regards,
Bryn Rhodes
Database Consulting Group LLC


Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: LOCK TABLES cache_page WRITE</em> in <em>C:\\Sites\\DCGForum\\includes\\database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://forums.dataphor.org/index.php?q=node/38', '', '54.196.190.32', 1542386230) in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: UPDATE cache_page SET data = &amp;#039;\\0\\0\\0\\0\\0\\0Xr6}LaL;ɌIZR.v\\&amp;quot;Mlqvod \\&amp;quot;1!\\0m)Ӈ|D|IwHYv$O-\\ne8{v&amp;lt;ѳ}0uG0vj0&amp;lt;ѻ&amp;lt;8J\\&amp;#039;q AZY7}鵭hgL6HU =t?c2x\\\\zж8,v-l[a3&amp;gt; ^herVB&amp;amp; k?YVJc܌jU-\\&amp;quot;w8xJZ.,Q6,_ؐ{\\0QʴvRڹA8\\ZgBͳgp\\&amp;#039;. |&amp;gt;¹ȸ 09;\\0Xg≜%&amp;lt;\\\\*3vgf8\\&amp;quot;c&amp;lt;y,cYMy*.ibM~0s&amp;lt;c&amp;gt;gefW in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Incorrect string value: &amp;#039;\\x8B\\x08\\0\\0...&amp;#039; for column &amp;#039;session&amp;#039; at row 1\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;3q43mno388t6dk1sh2etgs19p7&amp;#039;, 0, 0, &amp;#039;54.196.190.32&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:195:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is marked as crashed and should be repaired\\nquery: LOCK TABLES cache_page WRITE in C:\\\\Sites\\\\DCGForum\\\\includes\\\\database.mysql.inc on line 172.\\&amp;quot;;i:1;s:2365:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is mark in C:\Sites\DCGForum\includes\database.mysql.inc on line 172