diff options
| author | unknown <tomas@poseidon.mysql.com> | 2007-01-23 00:34:00 +0700 |
|---|---|---|
| committer | unknown <tomas@poseidon.mysql.com> | 2007-01-23 00:34:00 +0700 |
| commit | 5f9e20de6ccb1d9d2dbdb9640c70d59405f6bf32 (patch) | |
| tree | 71286fe67e9ab24c58bf123b822599a5141e687a /mysql-test/t/ndb_basic.test | |
| parent | 030e5f9225060675bc19d2eb02931542750cd001 (diff) | |
| download | mariadb-git-5f9e20de6ccb1d9d2dbdb9640c70d59405f6bf32.tar.gz | |
bug#25746 ndb: 4209 error with 2 VARCHAR primary keys
- make sure keys are copied correctly when varchar has 2 length bytes
- test case
mysql-test/r/ndb_basic.result:
bug#25746 ndb: 4209 error with 2 VARCHAR primary keys
- test case
mysql-test/t/ndb_basic.test:
bug#25746 ndb: 4209 error with 2 VARCHAR primary keys
- test case
sql/ha_ndbcluster.cc:
bug#25746 ndb: 4209 error with 2 VARCHAR primary keys
- make sure keys are copied correctly when varchar has 2 length bytes
Diffstat (limited to 'mysql-test/t/ndb_basic.test')
| -rw-r--r-- | mysql-test/t/ndb_basic.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test index 6c1a4e44f4b..a1ceddcd183 100644 --- a/mysql-test/t/ndb_basic.test +++ b/mysql-test/t/ndb_basic.test @@ -710,3 +710,22 @@ drop table t1; --error 1 --exec $MY_PERROR --ndb 1186 2>&1 +# +# Bug #25746 - VARCHAR UTF8 PK issue +# - prior to bugfix 4209, illegal length parameter would be +# returned in SELECT * + +CREATE TABLE t1 ( +a VARBINARY(40) NOT NULL, +b VARCHAR (256) CHARACTER SET UTF8 NOT NULL, +c VARCHAR(256) CHARACTER SET UTF8 NOT NULL, +PRIMARY KEY (b,c)) ENGINE=ndbcluster; +INSERT INTO t1 VALUES +("a","ab","abc"),("b","abc","abcd"),("c","abc","ab"),("d","ab","ab"),("e","abc","abc"); +SELECT * FROM t1 ORDER BY a; +DROP TABLE t1; + +# End of 5.0 tests +--echo End of 5.0 tests + + |