Hi!
>>>>> "ydbxmhc" == ydbxmhc <Paul> writes:
ydbxmhc> Good day, everyone, and thank you for your time!
ydbxmhc> I am not a member of the mailing list (I had to swear them off as
ydbxmhc> addictive =o) but am posting this question in the hope that some
ydbxmhc> generous soul will assist me anyway.
<cut>
ydbxmhc> Is there a way to
mysql> create table xmp (
-> this real(5,4)
-> );
ydbxmhc> Query OK, 0 rows affected (0.01 sec)
ydbxmhc> so that
mysql> desc xmp;
ydbxmhc> doesn't come back with
ydbxmhc> +-------+-------------+
ydbxmhc> | this | double(6,4) |
ydbxmhc> +-------+-------------+
There was a bug in MySQL where it accidently converted double(X+1,X)
t double(X+2,X) because MySQL thought that the first version was an
illegal type (as it was in MySQL 3.23)
(For example double(3,3) is an illegal type and is converted to
double(4,3))
Here is a patch that fixes this (This will be in 3.23.51 and 4.0.2)
((/my/mysql-3.23)) bk diffs -c sql/sql_parse.cc
===== sql/sql_parse.cc 1.143 vs edited =====
*** /tmp/sql_parse.cc-1.143-728 Tue Apr 16 16:29:04 2002
--- edited/sql/sql_parse.cc Fri Apr 26 13:44:05 2002
***************
*** 2432,2440 ****
uint sign_len=type_modifier & UNSIGNED_FLAG ? 0 : 1;
if (new_field->length && new_field->decimals &&
! new_field->length < new_field->decimals+2 &&
new_field->decimals != NOT_FIXED_DEC)
! new_field->length=new_field->decimals+2; /* purecov: inspected */
switch (type) {
case FIELD_TYPE_TINY:
--- 2432,2440 ----
uint sign_len=type_modifier & UNSIGNED_FLAG ? 0 : 1;
if (new_field->length && new_field->decimals &&
! new_field->length < new_field->decimals+1 &&
new_field->decimals != NOT_FIXED_DEC)
! new_field->length=new_field->decimals+1; /* purecov: inspected */
switch (type) {
case FIELD_TYPE_TINY:
Regards,
Monty
PS: In MySQL 4.1 MySQL will also remember that you used real() instead
of reporting double()
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
