Inconsistent % Wildcard behaviour
Andreas Pardeike <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi,
If I run
drop table if exists t;
create table t (f varchar(32) not null);
alter table t add index (f);
insert into t VALUES ('Guldböcker'),('Presentböcker');
select count(*) from t where f like '%böcker%';
select count(*) from t where f like '%böcker';
I get "1" from the first select and "2" from the second
select. This seems like a bug.
INFO
mysqladmin Ver 8.40 Distrib 4.1.1-alpha, for pc-linux on i686
Server version 4.1.1-alpha-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
> mysqladmin variables
| back_log | 50
| basedir | /usr/
| binlog_cache_size
| 32768
|
character_set | latin1
| character_sets | latin1 big5
cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk
german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7
usa7 win1250 win1251 win1251ukr ujis sjis tis620 | 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 | DISABLED
| have_isam | YES
| have_raid
| NO
|
have_openssl | NO
| init_file |
| innodb_additional_mem_pool_size
| 1048576
|
innodb_buffer_pool_size | 8388608
| innodb_data_file_path |
| innodb_data_home_dir
|
|
innodb_file_io_threads | 4
| innodb_force_recovery | 0
| innodb_thread_concurrency
| 8
|
innodb_flush_log_at_trx_commit | 1
| innodb_fast_shutdown | ON
| innodb_flush_method
|
|
innodb_lock_wait_timeout | 50
| innodb_log_arch_dir |
| innodb_log_archive
| OFF
|
innodb_log_buffer_size | 1048576
| innodb_log_file_size | 5242880
| innodb_log_files_in_group
| 2
|
innodb_log_group_home_dir |
| innodb_mirrored_log_groups | 1
| interactive_timeout
| 28800
|
join_buffer_size | 131072
| key_buffer_size | 8388600
| 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_long_queries
| OFF
|
long_query_time | 10
| low_priority_updates | OFF
| lower_case_table_names
| 0
|
max_allowed_packet | 1048576
| 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_max_extra_sort_file_size | 256
| myisam_max_sort_file_size | 2047
| myisam_recover_options
| 0
|
myisam_sort_buffer_size | 8388608
| net_buffer_length | 16384
| net_read_timeout
| 30
|
net_retry_count | 10
| net_write_timeout | 60
| open_files_limit
| 0
| pid_file
| /var/run/mysqld/mysqld.pid
| port | 3306
| protocol_version | 10
| record_buffer
| 131072
|
record_rnd_buffer | 131072
| query_buffer_size | 0
| safe_show_database
| OFF
| server_id
| 0
| 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
| 2097144
| sql_mode | 0
| table_cache | 64
| table_type
| MYISAM
|
thread_cache_size | 0
| thread_stack | 65536
| transaction_isolation
| READ-COMMITTED
| timezone
| CET
| tmp_table_size | 33554432
| tmpdir | /tmp/
| version
| 3.23.58
|
wait_timeout | 28800
Andreas Pardeike
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]