Hi, Shubham! On Mar 20, Shubham Barai wrote:
Hi Sergei,
As I told you, I was working on prototype just for blobs. I was having some issue with key definition between MariaDB .frm file and information in the MyISAM storage engine. I have solved that problem temporarily. Here is my output
MariaDB [database1]> set storage_engine=myisam; Query OK, 0 rows affected (0.00 sec) MariaDB [mydb]> create table table1(a int,b1 blob,b2 longblob,unique(a,b1,b2(5))); Query OK, 0 rows affected (0.09 sec) MariaDB [mydb]> insert into table1 values(4,3333333,55555555); Query OK, 1 row affected (0.00 sec) MariaDB [mydb]> insert into table1 values(4,3333333,55555); ERROR 1169 (23000): Can't write, because of unique constraint, to table 'table1' MariaDB [mydb]> insert into table1 values(4,3333333,55555555); ERROR 1169 (23000): Can't write, because of unique constraint, to table 'table1' MariaDB [mydb]> insert into table1 values(4,333333453,55555555); Query OK, 1 row affected (0.00 sec) 3 rows in set (0.00 sec) MariaDB [mydb]> insert into table1 values(5,333333453,55555555); Query OK, 1 row affected (0.00 sec) MariaDB [mydb]> insert into table1 values(5,333333453,55555); ERROR 1169 (23000): Can't write, because of unique constraint, to table 'table1' MariaDB [mydb]> show indexes from table1; +--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | +--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+ | table1 | 0 | a | 1 | a | A | NULL | NULL | NULL | YES | BTREE | | table1 | 0 | a | 2 | b1 | A | NULL | NULL | NULL | YES | BTREE | | table1 | 0 | a | 3 | b2 | A | 0 | 5 | NULL | YES | BTREE | +--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+ 3 rows in set (0.00 sec)
Any suggestions would be helpful.
Frankly speaking, I'd suggest you not to miss a deadline and submit it a proposal now :) You apparently have more than enough information already to understand the project and to create a good proposal. As for the code - I don't really understand what you're asking about. Are you trying to say that something in the output above is wrong? Is SHOW INDEXES incorrect? Regards, Sergei Chief Architect MariaDB and security@mariadb.org