>Description: We've got a specific UPDATE that will cause:
>How-To-Repeat: CREATE TABLE `t` ( `a` varchar(16) NOT NULL default '', `b` smallint(6) NOT NULL default '0', `c` datetime NOT NULL default '0000-00-00 00:00:00', `d` smallint(6) NOT NULL default '0', ) TYPE=MyISAM; INSERT INTO t SET a = ""; mysql> UPDATE t SET d=UNIX_TIMESTAMP(DATE_ADD(c, interval (b) day)) / 1; ERROR 1105: Unknown error >Fix: >Submitter-Id: [EMAIL PROTECTED] >Originator: Kevin Day >Organization: Stile Project, Inc. >MySQL support: none >Synopsis: 4.0.7 - UPDATE / ERROR 1105 >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.6-gamma (Source distribution) >Server: /usr/local/bin/mysqladmin Ver 8.38 Distrib 4.0.6-gamma, for >unknown-freebsd4.7 on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.6-gamma-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 13 days 23 hours 43 min 11 sec >Environment: System: FreeBSD server12.stileproject.com 4.7-RELEASE FreeBSD 4.7-RELEASE #0: Sun Oct 27 02:20:13 CST 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/SERVER i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.4 20020320 [FreeBSD] Compilation info: CC='gcc' CFLAGS='-march=pentiumpro -mcpu=pentiumpro -O6 -fomit-frame-pointer -fexpensive-optimizations' CXX='g++' CXXFLAGS='-march=pentiumpro -mcpu=pentiumpro -O6 -fomit-frame-pointer -fexpensive-optimizations' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 1218496 Oct 9 07:43 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Oct 10 15:54 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 574916 Oct 9 07:43 /usr/lib/libc.so.4 Configure command: ./configure '--without-innodb' '--enable-assembler' '--with-mysqld-ldflags=--static' '--without-docs' 'CFLAGS=-march=pentiumpro -mcpu=pentiumpro -O6 -fomit-frame-pointer -fexpensive-optimizations' 'CXXFLAGS=-march=pentiumpro -mcpu=pentiumpro -O6 -fomit-frame-pointer -fexpensive-optimizations' Perl: This is perl, version 5.005_03 built for i386-freebsd --------------------------------------------------------------------- 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
