diff options
| author | unknown <jonas@perch.ndb.mysql.com> | 2005-12-14 10:57:09 +0100 |
|---|---|---|
| committer | unknown <jonas@perch.ndb.mysql.com> | 2005-12-14 10:57:09 +0100 |
| commit | 2c808bed240141a6d35fe4cf49bbf899210d6a77 (patch) | |
| tree | 4e0d38eb2ad2f5d39885b554678ac2bb5ad24f3b /mysql-test | |
| parent | 01c7bd20b9fc28530387eeb5e3165f9ad8535301 (diff) | |
| download | mariadb-git-2c808bed240141a6d35fe4cf49bbf899210d6a77.tar.gz | |
bug#15682 - ndb - invalid handling of varchar in position/rnd_pos
mysql-test/r/ndb_basic.result:
bug#15682 - invalid handling of varchar in position/rnd_pos
mysql-test/t/ndb_basic.test:
bug#15682 - invalid handling of varchar in position/rnd_pos
ndb/src/kernel/blocks/dbtc/Dbtc.hpp:
New error code for invalid key
ndb/src/kernel/blocks/dbtc/DbtcMain.cpp:
Handle invalid key gracefully
ndb/src/kernel/vm/SimulatedBlock.cpp:
Handle invalid key gracefully
ndb/src/ndbapi/ndberror.c:
New error code
sql/ha_ndbcluster.cc:
Fix varchar keys in position/rnd_pos
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/ndb_basic.test | 11 |
2 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result index a374f845933..32328b7f0c3 100644 --- a/mysql-test/r/ndb_basic.result +++ b/mysql-test/r/ndb_basic.result @@ -673,3 +673,19 @@ select * from atablewithareallylongandirritatingname; a 2 drop table atablewithareallylongandirritatingname; +create table t1 (f1 varchar(50), f2 text,f3 int, primary key(f1)) engine=NDB; +insert into t1 (f1,f2,f3)VALUES("111111","aaaaaa",1); +insert into t1 (f1,f2,f3)VALUES("222222","bbbbbb",2); +select * from t1 order by f1; +f1 f2 f3 +111111 aaaaaa 1 +222222 bbbbbb 2 +select * from t1 order by f2; +f1 f2 f3 +111111 aaaaaa 1 +222222 bbbbbb 2 +select * from t1 order by f3; +f1 f2 f3 +111111 aaaaaa 1 +222222 bbbbbb 2 +drop table t1; diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test index 1c78a4b8744..6af56a21372 100644 --- a/mysql-test/t/ndb_basic.test +++ b/mysql-test/t/ndb_basic.test @@ -615,3 +615,14 @@ create table atablewithareallylongandirritatingname (a int); insert into atablewithareallylongandirritatingname values (2); select * from atablewithareallylongandirritatingname; drop table atablewithareallylongandirritatingname; + +# +# Bug#15682 +# +create table t1 (f1 varchar(50), f2 text,f3 int, primary key(f1)) engine=NDB; +insert into t1 (f1,f2,f3)VALUES("111111","aaaaaa",1); +insert into t1 (f1,f2,f3)VALUES("222222","bbbbbb",2); +select * from t1 order by f1; +select * from t1 order by f2; +select * from t1 order by f3; +drop table t1; |