diff options
| author | sachin <sachin.setiya@mariadb.com> | 2019-02-25 00:46:48 +0530 |
|---|---|---|
| committer | sachin <sachin.setiya@mariadb.com> | 2019-02-25 01:00:01 +0530 |
| commit | 9011fa1ace3c6a49afdf05c714844d938a8c6f99 (patch) | |
| tree | 79307d259bcf6070f45f89a154cf7befde5706f4 /mysql-test/main/long_unique.test | |
| parent | 6471c156f1b406973f2455bcf333f1b4bcf1198b (diff) | |
| download | mariadb-git-bb-10.4-blob-index-final.tar.gz | |
Long Index is only allowed for unique keys not normal index.bb-10.4-blob-index-final
Diffstat (limited to 'mysql-test/main/long_unique.test')
| -rw-r--r-- | mysql-test/main/long_unique.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique.test b/mysql-test/main/long_unique.test index 4d5ecba799f..9fee6d518f2 100644 --- a/mysql-test/main/long_unique.test +++ b/mysql-test/main/long_unique.test @@ -512,4 +512,17 @@ while ($count) --eval $insert_data_2 drop table t1; +--error ER_BLOB_KEY_WITHOUT_LENGTH +create table t1(a blob , key(a)); +create table t1(a blob); +--error ER_BLOB_KEY_WITHOUT_LENGTH +alter table t1 add index(a); +drop table t1; + +--error ER_BLOB_KEY_WITHOUT_LENGTH +create table t1(a text , key(a)); +create table t1(a varchar(4000)); +alter table t1 add index(a); +show create table t1; +drop table t1; set @@GLOBAL.max_allowed_packet= @allowed_packet; |