ctype_cp1250_ch.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- -- source include/have_cp1250_ch.inc
- SHOW COLLATION LIKE 'cp1250_czech_cs';
- #
- # Bugs: #8840: Empty string comparison and character set 'cp1250'
- #
- CREATE TABLE t1 (a char(16)) character set cp1250 collate cp1250_czech_cs;
- INSERT INTO t1 VALUES ('');
- SELECT a, length(a), a='', a=' ', a=' ' FROM t1;
- DROP TABLE t1;
- #
- # Bug#9759 Empty result with 'LIKE' and cp1250_czech_cs
- #
- CREATE TABLE t1 (
- popisek varchar(30) collate cp1250_general_ci NOT NULL default '',
- PRIMARY KEY (`popisek`)
- );
- INSERT INTO t1 VALUES ('2005-01-1');
- SELECT * FROM t1 WHERE popisek = '2005-01-1';
- SELECT * FROM t1 WHERE popisek LIKE '2005-01-1';
- drop table t1;
- #
- # Bug#13347: empty result from query with like and cp1250 charset
- #
- set names cp1250;
- CREATE TABLE t1
- (
- id INT AUTO_INCREMENT PRIMARY KEY,
- str VARCHAR(32) CHARACTER SET cp1250 COLLATE cp1250_czech_cs NOT NULL default '',
- UNIQUE KEY (str)
- );
- INSERT INTO t1 VALUES (NULL, 'a');
- INSERT INTO t1 VALUES (NULL, 'aa');
- INSERT INTO t1 VALUES (NULL, 'aaa');
- INSERT INTO t1 VALUES (NULL, 'aaaa');
- INSERT INTO t1 VALUES (NULL, 'aaaaa');
- INSERT INTO t1 VALUES (NULL, 'aaaaaa');
- INSERT INTO t1 VALUES (NULL, 'aaaaaaa');
- select * from t1 where str like 'aa%';
- drop table t1;
- # End of 4.1 tests