Bug #14054 what div_precision increment do?

• Submitted: 15 Oct 2005 23:57
• Modified: 16 Oct 2005 1:02
• Reporter: Roberto Spadim (Basic Quality Contributor)
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S4 (Feature request)
• Version: all
• OS: Any (all)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[15 Oct 2005 23:57] Roberto Spadim

Description:
no documentation was founded on mysql docs about div_precision_increment variable, what it do?

How to repeat:
??

Suggested fix:
put a comment about it

[16 Oct 2005 1:02] MySQL Verification Team

Please see:

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

div_precision_increment

This variable indicates the number of digits of precision by which to increase the
result of division operations performed with the / operator. 
The default value is 4. The minimum and maximum values are 0 and 30, respectively.
The following example illustrates the effect of increasing the default value.

mysql> SELECT 1/7;
+--------+
| 1/7    |
+--------+
| 0.1429 |
+--------+
mysql> SET div_precision_increment = 12;
mysql> SELECT 1/7;
+----------------+
| 1/7            |
+----------------+
| 0.142857142857 |
+----------------+

This variable was added in MySQL 5.0.6.