fuck you! this is the four time! can you say me before! -------------------------------------------------------------------------- INFOTEL TELEMATICA Srl Tel 0541 775927 - Fax 0541 775933 Sede operativa : Via Nuova Circonvallazione 57/c - 47900 Rimini (RN) Sede legale : Via Mazzoni 38 - 47900 Rimini (RN) Internet : http://www.infotel.it e-mail : [EMAIL PROTECTED] ------------------------------------------------------- ------------------- ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "WebMaster - Infotel Telematica S.r.l." <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 9:52 PM Subject: Re: FLOAT EQUAL OPERATOR
> Your message cannot be posted to [EMAIL PROTECTED] because it did not > follow the format expected by our spam/off-topic filter. To this list we > accept only repeatable bugs reports, meaning that you can describe a > set of steps we can follow to repeat the bug on our systems. > > If you are having problems with MySQL but are unable to provide the required > description, and have not purchased a support contract from MySQL AB, > you should send your message to [EMAIL PROTECTED] and possibly one of our > knowledgable users or developers will help you. However, we do not guarantee > that every message on [EMAIL PROTECTED] will be answered. We can afford > to provide free code, but unfortunately, we cannot afford to provide > guaranteed free support on top of that. We do, nevertheless, fix our bugs > regardless of who reports them and whose systems they affect, and will > investigate your problem if you can prove to us with a test case that the > error is in our code and not yours. > > If you have purchased a support contract from MySQL AB, you should follow > the standard support request procedure to report this problem. Support > contracts are available at https://order.mysql.com/. > > If you are able to describe how we can repeat the problem, include the string > "How-To-Repeat:" in the body of your message, followed by the detailed > description of what we need to do to make it happen, and our filter will > accept your message. If you use mysqlbug script, which comes with the MySQL > distribution, to post the message, it will be automatically accepted. > > You have written the following: > > ---start of your message---- > MySQL don't detect the equal float numbers if aren't ineger, left float > alwais greater then right float es. 1.1 > 1.1 = true. > > o mysqladmin version > > mysqladmin Ver 8.21 Distrib 3.23.39, for slackware-linux-gnu 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 3.23.39-log > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /var/run/mysql/mysql.sock > Uptime: 14 days 16 hours 30 min 5 sec > > Threads: 1 Questions: 93427 Slow queries: 0 Opens: 658 Flush tables: 1 > Open tables: 64 Queries per second avg: 0.074 > > o manufacturer and model of the machine > hp netserver lc 2000 > > o uname -a > Linux intranet 2.2.19 #59 Wed Jun 20 21:47:29 PDT 2001 i686 unknown > > o top > 1:06pm up 15 days, 29 min, 3 users, load average: 0.14, 0.10, 0.13 > 77 processes: 76 sleeping, 1 running, 0 zombie, 0 stopped > CPU states: 2.4% user, 0.8% system, 0.0% nice, 0.7% idle > Mem: 257412K av, 245084K used, 12328K free, 113944K shrd, 46844K > buff > Swap: 530104K av, 552K used, 529552K free 106924K > cached > > o compiler > gcc 2.95.3 > > o problems with SELECT statements > > mysql> SHOW VARIABLES; > +---------------------------------+----------------------------------------- > -------------------------------------------------------------------------- -- > --------------------------------------+ > | Variable_name | Value > | > +---------------------------------+----------------------------------------- > -------------------------------------------------------------------------- -- > --------------------------------------+ > | ansi_mode | OFF > > | > | back_log | 50 > | > | basedir | /usr/ > | > | binlog_cache_size | 32768 > | > | character_set | latin1 > | > | character_sets | latin1 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 | ON > | > | connect_timeout | 5 > | > | datadir | /var/lib/mysql/ > | > | delay_key_write | ON > | > | delayed_insert_limit | 100 > | > | delayed_insert_timeout | 300 > | > | delayed_queue_size | 1000 > | > | flush | OFF > | > | flush_time | 0 > | > | have_bdb | NO > | > | have_gemini | NO > | > | have_innodb | NO > | > | have_isam | YES > | > | have_raid | YES > | > | have_ssl | NO > | > | init_file | > | > | interactive_timeout | 28800 > | > | join_buffer_size | 131072 > | > | key_buffer_size | 16773120 > | > | language | /usr/share/mysql/italian/ > | > | large_files_support | ON > | > | locked_in_memory | OFF > | > | log | OFF > | > | log_update | OFF > | > | log_bin | ON > | > | log_slave_updates | OFF > | > | 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_recover_options | OFF > | > | myisam_max_extra_sort_file_size | 256 > | > | myisam_max_sort_file_size | 2047 > | > | 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/intranet.pid > | > | port | 3306 > | > | protocol_version | 10 > | > | record_buffer | 131072 > | > | query_buffer_size | 0 > | > | safe_show_database | OFF > | > | server_id | 1 > | > | skip_locking | ON > | > | skip_networking | OFF > | > | skip_show_database | OFF > | > | slow_launch_time | 2 > | > | socket | /var/run/mysql/mysql.sock > | > | sort_buffer | 524280 > | > | table_cache | 64 > | > | table_type | MYISAM > | > | thread_cache_size | 0 > | > | thread_stack | 65536 > | > | transaction_isolation | READ-COMMITTED > | > | timezone | CEST > | > | tmp_table_size | 33554432 > | > | tmpdir | /tmp/ > | > | version | 3.23.39-log > | > | wait_timeout | 28800 > | > +---------------------------------+----------------------------------------- > -------------------------------------------------------------------------- -- > --------------------------------------+ > 79 rows in set (0.00 sec) > > mysql> SHOW TABLES; > +----------------+ > | Tables_in_test | > +----------------+ > | float_bug | > | testac | > +----------------+ > 2 rows in set (0.00 sec) > > mysql> SHOW TABLES\G > *************************** 1. row *************************** > Tables_in_test: float_bug > *************************** 2. row *************************** > Tables_in_test: testac > 2 rows in set (0.00 sec) > > mysql> SHOW COLUMNS FROM float_bug\G > *************************** 1. row *************************** > Field: f > Type: float > Null: YES > Key: > Default: NULL > Extra: > 1 row in set (0.00 sec) > > mysql> SELECT * FROM float_bug\G > *************************** 1. row *************************** > f: 1.1 > *************************** 2. row *************************** > f: 1 > 2 rows in set (0.00 sec) > > mysql> EXPLAIN SELECT * FROM float_bug\G > *************************** 1. row *************************** > table: float_bug > type: ALL > possible_keys: NULL > key: NULL > key_len: NULL > ref: NULL > rows: 2 > Extra: > 1 row in set (0.00 sec) > > mysql> EXPLAIN SELECT * FROM float_bug WHERE f=1.1\G > *************************** 1. row *************************** > table: float_bug > type: ALL > possible_keys: NULL > key: NULL > key_len: NULL > ref: NULL > rows: 2 > Extra: where used > 1 row in set (0.00 sec) > > mysql> FLUSH STATUS; > Query OK, 0 rows affected (0.00 sec) > > mysql> SELECT * FROM float_bug WHERE f=1.1; > Empty set (0.00 sec) > > mysql> SHOW STATUS; > +--------------------------+---------+ > | Variable_name | Value | > +--------------------------+---------+ > | Aborted_clients | 0 | > | Aborted_connects | 0 | > | Bytes_received | 56 | > | Bytes_sent | 48 | > | Connections | 11325 | > | Created_tmp_disk_tables | 0 | > | Created_tmp_tables | 0 | > | Created_tmp_files | 0 | > | Delayed_insert_threads | 0 | > | Delayed_writes | 0 | > | Delayed_errors | 0 | > | Flush_commands | 1 | > | Handler_delete | 0 | > | Handler_read_first | 0 | > | Handler_read_key | 0 | > | Handler_read_next | 0 | > | Handler_read_prev | 0 | > | Handler_read_rnd | 0 | > | Handler_read_rnd_next | 3 | > | Handler_update | 0 | > | Handler_write | 0 | > | Key_blocks_used | 94 | > | Key_read_requests | 0 | > | Key_reads | 0 | > | Key_write_requests | 0 | > | Key_writes | 0 | > | Max_used_connections | 0 | > | Not_flushed_key_blocks | 0 | > | Not_flushed_delayed_rows | 0 | > | Open_tables | 64 | > | Open_files | 130 | > | Open_streams | 0 | > | Opened_tables | 0 | > | Questions | 113957 | > | Select_full_join | 0 | > | Select_full_range_join | 0 | > | Select_range | 0 | > | Select_range_check | 0 | > | Select_scan | 1 | > | Slave_running | OFF | > | Slave_open_temp_tables | 0 | > | Slow_launch_threads | 0 | > | Slow_queries | 0 | > | Sort_merge_passes | 0 | > | Sort_range | 0 | > | Sort_rows | 0 | > | Sort_scan | 0 | > | Table_locks_immediate | 1 | > | Table_locks_waited | 0 | > | Threads_cached | 0 | > | Threads_created | 11324 | > | Threads_connected | 1 | > | Threads_running | 1 | > | Uptime | 1379121 | > +--------------------------+---------+ > 54 rows in set (0.00 sec) > > mysql> EXPLAIN SELECT * FROM float_bug WHERE f=1\G > *************************** 1. row *************************** > table: float_bug > type: ALL > possible_keys: NULL > key: NULL > key_len: NULL > ref: NULL > rows: 2 > Extra: where used > 1 row in set (0.00 sec) > > mysql> FLUSH STATUS; > Query OK, 0 rows affected (0.00 sec) > > mysql> SELECT * FROM float_bug WHERE f=1; > +------+ > | f | > +------+ > | 1 | > +------+ > 1 row in set (0.00 sec) > > mysql> SHOW STATUS; > +--------------------------+---------+ > | Variable_name | Value | > +--------------------------+---------+ > | Aborted_clients | 0 | > | Aborted_connects | 0 | > | Bytes_received | 54 | > | Bytes_sent | 54 | > | Connections | 11325 | > | Created_tmp_disk_tables | 0 | > | Created_tmp_tables | 0 | > | Created_tmp_files | 0 | > | Delayed_insert_threads | 0 | > | Delayed_writes | 0 | > | Delayed_errors | 0 | > | Flush_commands | 1 | > | Handler_delete | 0 | > | Handler_read_first | 0 | > | Handler_read_key | 0 | > | Handler_read_next | 0 | > | Handler_read_prev | 0 | > | Handler_read_rnd | 0 | > | Handler_read_rnd_next | 3 | > | Handler_update | 0 | > | Handler_write | 0 | > | Key_blocks_used | 94 | > | Key_read_requests | 0 | > | Key_reads | 0 | > | Key_write_requests | 0 | > | Key_writes | 0 | > | Max_used_connections | 0 | > | Not_flushed_key_blocks | 0 | > | Not_flushed_delayed_rows | 0 | > | Open_tables | 64 | > | Open_files | 130 | > | Open_streams | 0 | > | Opened_tables | 0 | > | Questions | 113961 | > | Select_full_join | 0 | > | Select_full_range_join | 0 | > | Select_range | 0 | > | Select_range_check | 0 | > | Select_scan | 1 | > | Slave_running | OFF | > | Slave_open_temp_tables | 0 | > | Slow_launch_threads | 0 | > | Slow_queries | 0 | > | Sort_merge_passes | 0 | > | Sort_range | 0 | > | Sort_rows | 0 | > | Sort_scan | 0 | > | Table_locks_immediate | 1 | > | Table_locks_waited | 0 | > | Threads_cached | 0 | > | Threads_created | 11324 | > | Threads_connected | 1 | > | Threads_running | 1 | > | Uptime | 1379138 | > +--------------------------+---------+ > 54 rows in set (0.00 sec) > > mysql> EXPLAIN SELECT * FROM float_bug WHERE f>1.1\G > *************************** 1. row *************************** > table: float_bug > type: ALL > possible_keys: NULL > key: NULL > key_len: NULL > ref: NULL > rows: 2 > Extra: where used > 1 row in set (0.00 sec) > > mysql> FLUSH STATUS; > Query OK, 0 rows affected (0.00 sec) > > mysql> SELECT * FROM float_bug WHERE f>1.1; > +------+ > | f | > +------+ > | 1.1 | > +------+ > 1 row in set (0.00 sec) > > mysql> SHOW STATUS; > +--------------------------+---------+ > | Variable_name | Value | > +--------------------------+---------+ > | Aborted_clients | 0 | > | Aborted_connects | 0 | > | Bytes_received | 56 | > | Bytes_sent | 56 | > | Connections | 11325 | > | Created_tmp_disk_tables | 0 | > | Created_tmp_tables | 0 | > | Created_tmp_files | 0 | > | Delayed_insert_threads | 0 | > | Delayed_writes | 0 | > | Delayed_errors | 0 | > | Flush_commands | 1 | > | Handler_delete | 0 | > | Handler_read_first | 0 | > | Handler_read_key | 0 | > | Handler_read_next | 0 | > | Handler_read_prev | 0 | > | Handler_read_rnd | 0 | > | Handler_read_rnd_next | 3 | > | Handler_update | 0 | > | Handler_write | 0 | > | Key_blocks_used | 94 | > | Key_read_requests | 0 | > | Key_reads | 0 | > | Key_write_requests | 0 | > | Key_writes | 0 | > | Max_used_connections | 0 | > | Not_flushed_key_blocks | 0 | > | Not_flushed_delayed_rows | 0 | > | Open_tables | 64 | > | Open_files | 130 | > | Open_streams | 0 | > | Opened_tables | 0 | > | Questions | 113965 | > | Select_full_join | 0 | > | Select_full_range_join | 0 | > | Select_range | 0 | > | Select_range_check | 0 | > | Select_scan | 1 | > | Slave_running | OFF | > | Slave_open_temp_tables | 0 | > | Slow_launch_threads | 0 | > | Slow_queries | 0 | > | Sort_merge_passes | 0 | > | Sort_range | 0 | > | Sort_rows | 0 | > | Sort_scan | 0 | > | Table_locks_immediate | 1 | > | Table_locks_waited | 0 | > | Threads_cached | 0 | > | Threads_created | 11324 | > | Threads_connected | 1 | > | Threads_running | 1 | > | Uptime | 1379166 | > +--------------------------+---------+ > 54 rows in set (0.00 sec) > > o mysqladmin variables extended-status processlist > > +---------------------------------+----------------------------------------- > -------------------------------------------------------------------------- -- > --------------------------------------+ > | Variable_name | Value > | > +---------------------------------+----------------------------------------- > -------------------------------------------------------------------------- -- > --------------------------------------+ > | ansi_mode | OFF > | > | back_log | 50 > | > | basedir | /usr/ > | > | binlog_cache_size | 32768 > | > | character_set | latin1 > | > | character_sets | latin1 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 | ON > | > | connect_timeout | 5 > | > | datadir | /var/lib/mysql/ > | > | delay_key_write | ON > | > | delayed_insert_limit | 100 > | > | delayed_insert_timeout | 300 > | > | delayed_queue_size | 1000 > | > | flush | OFF > | > | flush_time | 0 > | > | have_bdb | NO > > | > | have_gemini | NO > | > | have_innodb | NO > | > | have_isam | YES > | > | have_raid | YES > | > | have_ssl | NO > | > | init_file | > | > | interactive_timeout | 28800 > | > | join_buffer_size | 131072 > | > | key_buffer_size | 16773120 > | > | language | /usr/share/mysql/italian/ > | > | large_files_support | ON > | > | locked_in_memory | OFF > | > | log | OFF > | > | log_update | OFF > | > | log_bin | ON > | > | log_slave_updates | OFF > | > | 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_recover_options | OFF > | > | myisam_max_extra_sort_file_size | 256 > | > | myisam_max_sort_file_size | 2047 > | > | 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/intranet.pid > | > | port | 3306 > | > | protocol_version | 10 > | > | record_buffer | 131072 > | > | query_buffer_size | 0 > | > | safe_show_database | OFF > | > | server_id | 1 > | > | skip_locking | ON > | > | skip_networking | OFF > | > | skip_show_database | OFF > | > | slow_launch_time | 2 > | > | socket | /var/run/mysql/mysql.sock > | > | sort_buffer | 524280 > > | > | table_cache | 64 > | > | table_type | MYISAM > | > | thread_cache_size | 0 > | > | thread_stack | 65536 > | > | transaction_isolation | READ-COMMITTED > | > | timezone | CEST > | > | tmp_table_size | 33554432 > | > | tmpdir | /tmp/ > | > | version | 3.23.39-log > | > | wait_timeout | 28800 > | > +---------------------------------+----------------------------------------- > -------------------------------------------------------------------------- -- > --------------------------------------+ > +--------------------------+----------+ > | Variable_name | Value | > +--------------------------+----------+ > | Aborted_clients | 0 | > | Aborted_connects | 69 | > | Bytes_received | 9170042 | > | Bytes_sent | 29422257 | > | Connections | 9994 | > | Created_tmp_disk_tables | 2206 | > | Created_tmp_tables | 2208 | > | Created_tmp_files | 0 | > | Delayed_insert_threads | 0 | > | Delayed_writes | 0 | > | Delayed_errors | 0 | > | Flush_commands | 1 | > | Handler_delete | 88 | > | Handler_read_first | 4790 | > | Handler_read_key | 1109 | > | Handler_read_next | 129 | > | Handler_read_prev | 0 | > | Handler_read_rnd | 12407 | > | Handler_read_rnd_next | 415149 | > | Handler_update | 271 | > | Handler_write | 29294 | > | Key_blocks_used | 54 | > | Key_read_requests | 19717 | > | Key_reads | 26 | > | Key_write_requests | 352 | > | Key_writes | 280 | > | Max_used_connections | 2 | > | Not_flushed_key_blocks | 0 | > | Not_flushed_delayed_rows | 0 | > | Open_tables | 64 | > | Open_files | 130 | > | Open_streams | 0 | > | Opened_tables | 653 | > | Questions | 93400 | > | Select_full_join | 2441 | > | Select_full_range_join | 0 | > | Select_range | 0 | > | Select_range_check | 0 | > | Select_scan | 37391 | > | Slave_running | OFF | > | Slave_open_temp_tables | 0 | > | Slow_launch_threads | 0 | > | Slow_queries | 0 | > | Sort_merge_passes | 0 | > | Sort_range | 0 | > | Sort_rows | 12407 | > | Sort_scan | 3092 | > | Table_locks_immediate | 70972 | > | Table_locks_waited | 0 | > | Threads_cached | 0 | > | Threads_created | 9993 | > | Threads_connected | 1 | > | Threads_running | 1 | > | Uptime | 1267117 | > +--------------------------+----------+ > +------+-------+-----------+----+---------+------+-------+------------------ > + > | Id | User | Host | db | Command | Time | State | Info > | > +------+-------+-----------+----+---------+------+-------+------------------ > + > | 9993 | pedro | localhost | | Query | 0 | | show processlist > | > +------+-------+-----------+----+---------+------+-------+------------------ > + > > > > ---end of your message------- > > MySQL Development Team > --------------------------------------------------------------------- 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