>Description:
Using a SELECT CASE during a "CREATE TABLE ... SELECT" statement causes an
error 1105 (Unknown error). The CASE contruction works fine in the SELECT
query, and also works fine on 3.23.49a.
>How-To-Repeat:
Run this script against a test database:
drop table if exists TestCase;
create table TestCase
select
case '2'
when '1' then 'One'
when '2' then 'Two'
when '3' then 'Three'
end as TestField;
drop table if exists TestCase;
>Fix:
Unknown. (Use the SELECT CASE code that's current in the 3.23 branch?)
>Submitter-Id: <submitter ID>
>Originator: Daniel Butler
>Organization: Yup Dot Com
>MySQL support: none
>Synopsis: SELECT CASE doesn't work during CREATE TABLE in 4.0.2
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.2-alpha (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.30 Distrib 4.0.2-alpha, for pc-linux-gnu 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 4.0.2-alpha
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 21 hours 44 min 52 sec
Threads: 1 Questions: 443 Slow queries: 0 Opens: 59 Flush tables: 1 Open tables:
31 Queries per second avg: 0.006
>Environment:
System: Linux www.xxxxxxxxxx.com 2.2.17 #11 SMP Tue Oct 3 15:31:25 EDT 2000 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc /bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs
gcc version 2.95.3 20010125 (prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Sep 25 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure --without-innodb
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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