SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: john.zoetebier@stripped
To: mysql@stripped
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
I created a table with all fields to see what the column type name is.
All field types showed a correct column type, except field type YEAR.
The column type for YEAR = "UNKNOWN"
I use mysql-connector-java-3.0.6-stable-bin.jar
The command to get column typeinfo is instance method:
ResultSetMetaData.getColumnTypeName()
This looks a bug to me in the JDBC connector to me.
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple
lines)>
Create table with field with field type YEAR.
Run Java program to extract column type using
ResultSetMetaData.getColumnTypeName
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: <submitter ID>
>Originator: John Zoetebier
>Organization: Transparent Systems
<organization of PR author (multiple lines)>
>MySQL support: [none]
>Synopsis: ResultSetMetaData.getColumnTypeName bug for fieldtype YEAR
>Severity: <[ non-critical >
>Priority: <[ low ]>
>Category: mysql
>Class: <[ sw-bug ] (one line)>
>Release: mysql-3.23.52 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for suse-linux
on i686
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 3.23.52-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 7 hours 28 min 51 sec
Threads: 3 Questions: 989 Slow queries: 0 Opens: 67 Flush tables: 1
Open tables: 55 Queries per second avg: 0.037
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux tsl010 2.4.19-4GB #1 Fri Sep 13 13:19:15 UTC 2002 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/3.2/specs
Configured with: ../configure --enable-threads=posix --prefix=/usr
--with-local-prefix=/usr/local --infodir=/usr/share/info
--mandir=/usr/share/man --libdir=/usr/lib
--enable-languages=c,c++,f77,objc,java,ada --enable-libgcj
--with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib
--with-system-zlib --enable-shared --enable-__cxa_atexit i486-suse-linux
Thread model: posix
gcc version 3.2
Compilation info: CC='gcc' CFLAGS='-O2 -march=i586 -mcpu=i686
-fmessage-length=0 -DPIC -fPIC' CXX='g++' CXXFLAGS='-O2 -march=i586
-mcpu=i686 -fmessage-length=0 -felide-constructors
-fno-exceptions -fno-rtti
-fPIC -DPIC' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1321674 2002-10-09 05:31 /lib/libc.so.6
-rw-r--r-- 1 root root 23159812 2002-09-10 04:40 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 2002-09-10 04:40 /usr/lib/libc.so
lrwxrwxrwx 1 root root 20 2002-12-02 11:38
/usr/lib/libc-client.so -> libc-client.so.2001a
-rwxr-xr-x 1 root root 735696 2002-09-10 08:47
/usr/lib/libc-client.so.2001a
Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-static' '--with-client-ldflags=-static'
'--without-berkeley-db' '--without-innodb' '--enable-assembler'
'--enable-large-files' '--infodir=/usr/share/info' '--libdir=/usr/lib'
'--libexecdir=/usr/sbin' '--localstatedir=/var/lib/mysql'
'--mandir=/usr/share/man' '--prefix=/usr' '--sysconfdir=/etc'
'--with-mysqld-user=mysql' '--without-debug' '--datadir=/usr/share'
'--includedir=/usr/include' '--with-extra-charsets=complex'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-libwrap'
'CFLAGS=-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -DPIC -fPIC'
'CXXFLAGS=-O2 -march=i586 -mcpu=i686 -fmessage-length=0
-felide-constructors -fno-exceptions
-fno-rtti -fPIC -DPIC'
