>Description:
Bug in WEEK command??
>How-To-Repeat:
mysql> select week('1997-01-01');
+--------------------+
| week('1997-01-01') |
+--------------------+
| 1 |
+--------------------+
1 row in set (0.00 sec)
mysql> select week('1997-12-31');
+--------------------+
| week('1997-12-31') |
+--------------------+
| 53 |
+--------------------+
1 row in set (0.00 sec)
mysql> select week('1998-01-01');
+--------------------+
| week('1998-01-01') |
+--------------------+
| 0 |
+--------------------+
1 row in set (0.01 sec)
mysql> select week('1998-12-31');
+--------------------+
| week('1998-12-31') |
+--------------------+
| 52 |
+--------------------+
1 row in set (0.01 sec)
>Fix:
Need to know
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
========================================================================
Aldrian Gintingsuka -- Systems Consultant -- Mitra Integrasi Informatika
Phone: +62-21-251-1360 ext. 1414 -- Fax: +62-21-251-2748
Email: aldrian@stripped, aldrian@stripped
------------------------------------------------------------------------
Si tu es contre Dieu, tu es contre l'homme (Enigma: Sadeness part I)
>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: Week in year before 1998 starts from 1 instead of 0
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.22.21 (Source distribution)
>Environment:
System: SunOS vdtelco 5.6 Generic_105181-08 sun4m sparc SUNW,SPARCstation-4
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/local/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='-O6 -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti
-DDONT_USE_DEFAULT_FIELDS' LDFLAGS=''
Configure command: configure --without-docs --without-bench --without-debug
--enable-thread-safe-client --with-low-memory --with-mysqld-user=mysql98
Perl: This is perl, version 5.005_03 built for sun4-solaris-thread