Hi!
Thank you for your bug report.
It helped us fix a bug . A fix will come in version 4.0.5. This is a
patch that fixes a problem:
===== sql/field.h 1.41 vs edited =====
*** /tmp/field.h-1.41-18621 Wed Oct 16 12:32:31 2002
--- edited/sql/field.h Wed Oct 30 17:24:58 2002
***************
*** 544,549 ****
--- 544,550 ----
enum Item_result result_type () const { return field_length == 8 || field_length
== 14 ? INT_RESULT : STRING_RESULT; }
enum_field_types type() const { return FIELD_TYPE_TIMESTAMP;}
enum ha_base_keytype key_type() const { return HA_KEYTYPE_ULONG_INT; }
+ enum Item_result cmp_type () const { return INT_RESULT; }
void store(const char *to,uint length);
void store(double nr);
void store(longlong nr);
===== sql/item_cmpfunc.cc 1.36 vs edited =====
*** /tmp/item_cmpfunc.cc-1.36-18621 Tue Sep 3 16:50:57 2002
--- edited/sql/item_cmpfunc.cc Wed Oct 30 20:58:53 2002
***************
*** 360,365 ****
--- 360,366 ----
if (args[0]->type() == FIELD_ITEM)
{
Field *field=((Item_field*) args[0])->field;
+ cmp_type=field->cmp_type();
if (field->store_for_compare())
{
if (convert_constant_item(field,&args[1]))
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ 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
