On Friday 10 January 2003 21:43, you wrote:
> > mysql> UPDATE t SET d=UNIX_TIMESTAMP(DATE_ADD(c, interval (b) day)) / 1;
> > ERROR 1105: Unknown error
Thanks for bug report!
This is a patch from Sinisa Milivojevic:
===== sql/item.cc 1.24 vs edited =====
*** /tmp/item.cc-1.24-3175 Tue Dec 3 13:08:21 2002
--- edited/sql/item.cc Fri Jan 10 21:38:55 2003
***************
*** 505,511 ****
{
double nr=val();
if (null_value)
! return set_field_to_null(field);
field->set_notnull();
field->store(nr);
}
--- 505,511 ----
{
double nr=val();
if (null_value)
! return set_field_to_null_with_conversions(field, no_conversions);
field->set_notnull();
field->store(nr);
}
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
