diff options
| author | unknown <serg@serg.mylan> | 2004-08-13 18:29:25 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-08-13 18:29:25 +0200 |
| commit | b6f6d5b2fd920c5f8c8e611c9b58b43077b21f8d (patch) | |
| tree | 9f1d56d26b0dc04c637b834bdb89d3d7be9af018 /mysql-test/t/func_gconcat.test | |
| parent | 4a0f586bc735abb1b9d0129210ab349cfb629d40 (diff) | |
| download | mariadb-git-b6f6d5b2fd920c5f8c8e611c9b58b43077b21f8d.tar.gz | |
apply UNIQUE constrain correctly for multi-byte charsets
only MyISAM is fixed
include/m_ctype.h:
my_charpos() macro
myisam/mi_key.c:
apply UNIQUE constrain correctly for multi-byte charsets
mysql-test/r/binary.result:
new test
mysql-test/r/key.result:
apply UNIQUE constrain correctly for multi-byte charsets
mysql-test/t/binary.test:
new test
mysql-test/t/func_gconcat.test:
make test to pass w/o InnoDB
mysql-test/t/key.test:
apply UNIQUE constrain correctly for multi-byte charsets
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index d27e5d7d77f..ad19c8414ec 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -215,10 +215,12 @@ DROP TABLE t1; # check null values #1 # +--disable_warnings CREATE TABLE t1 (a_id tinyint(4) NOT NULL default '0', PRIMARY KEY (a_id)) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO t1 VALUES (1),(2),(3); CREATE TABLE t2 (b_id tinyint(4) NOT NULL default '0',b_a tinyint(4) NOT NULL default '0', PRIMARY KEY (b_id), KEY (b_a), CONSTRAINT fk_b_a FOREIGN KEY (b_a) REFERENCES t1 (a_id) ON DELETE CASCADE ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin1; +--enable_warnings INSERT INTO t2 VALUES (1,1),(2,1),(3,1),(4,2),(5,2); SELECT * FROM (SELECT t1.*,GROUP_CONCAT(t2.b_id SEPARATOR ',') as b_list FROM (t1 LEFT JOIN (t2) on t1.a_id = t2.b_a) GROUP BY t1.a_id ) AS xyz; DROP TABLE t2; |