Dear Dirs,
I think I' ve found a bug.
Please run the following query
(I know you don' t have my db,
try something similar)
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN month(data_ordine) = 1 then qty else 0 END as jan,
CASE WHEN month(data_ordine) = 2 then qty else 0 END as feb,
CASE WHEN month(data_ordine) = 3 then qty else 0 END as mar,
CASE WHEN month(data_ordine) = 4 then qty else 0 END as apr,
CASE WHEN month(data_ordine) = 5 then qty else 0 END as may,
CASE WHEN month(data_ordine) = 6 then qty else 0 END as jun,
CASE WHEN month(data_ordine) = 7 then qty else 0 END as jul,
CASE WHEN month(data_ordine) = 8 then qty else 0 END as aug,
CASE WHEN month(data_ordine) = 9 then qty else 0 END as sep,
CASE WHEN month(data_ordine) = 10 then qty else 0 END as oct,
CASE WHEN month(data_ordine) = 11 then qty else 0 END as nov,
CASE WHEN month(data_ordine) = 12 then qty else 0 END as 'dec'
FROM ord_tmp;
ERROR GIVEN : ERROR 1105 at line xx : Unknown error
I get the same error with queries like this (create - select - case ).
With version 4.0.1 these queries used to work perfectly.
Workaround : create the query , then insert-select :)
KERNEL : 2.4
VERSION :MySQL-4.0.2-2.i386.rpm
VARIABLES :
back_log 50
basedir /
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620
ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew
win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257
latin5
concurrent_insert OFF
connect_timeout 5
datadir /home/mysql/
delay_key_write OFF
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_boolean_syntax + -><()~*:""&|
have_bdb NO
have_innodb NO
have_isam YES
have_raid NO
have_symlink YES
have_openssl NO
have_query_cache YES
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 16773120
language /usr/share/mysql/english/
large_files_support ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_slow_queries ON
long_query_time 10
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1047552
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_bulk_insert_tree_size 8388608
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options OFF
myisam_sort_buffer_size 8388608
net_buffer_length 7168
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file /var/lib/mysql/mandrake.pid
port 3306
protocol_version 10
record_buffer 131072
record_rnd_buffer 131072
rpl_recovery_rank 0
query_buffer_size 0
query_cache_limit 1048576
query_cache_size 0
query_cache_startup_type 1
safe_show_database OFF
server_id 1
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer 524280
sql_mode 0
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone EDT
tmp_table_size 33554432
tmpdir /home/mysql/tmp/
version 4.0.2-alpha-log
wait_timeout 28800
Note : You did a great job with multi-table delete !!! THX for existing!
Best Regards
Andrea Forghieri
Project Manager
Emmegi S.p.A.
---------------------------------------------------------------------
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
