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 [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
