1. Can't display more than 1 constraint for a table in the object tree.
Primary and foreign keys are displayed under Constraints node. What constraints do you mean?
I mean foreign keys.
Code: Select all
create table test1(
c1 int not null,
primary key(c1)
)
engine=InnoDB;
create table test2(
c2 int not null,
primary key(c2)
)
engine=InnoDB;;
create table test3(
c1 int not null,
c2 int not null,
constraint fk_test3__test1 foreign key (c1) references test1 (c1),
constraint fk_test3__test2 foreign key (c2) references test2 (c2)
)
engine=InnoDB;
It shows only 1 of 2 foreign keys:
www.pichost.ru/out.php/i4752_1.gif
2. Can't display SQL code for a view created using MySQL console.
Maybe you don't have privilege to show view text. In the next build we'll show the error message in this case.
It seems it isn't MyDevStudio bug.
When I logged as root@localhost and have all grants on *.*, I still can't see view_definition from information_schema.VIEWS for views of other definers. But on other hand I can see view text using "show create view". Something is wrong in MySQL security model!
I'd be super if your studio could analyze "show create view"
And I have two bugs more...
1. It seems you've bug in supporting of bigint auto_increment columns:
Code: Select all
create table test(
c1 bigint unsigned not null auto_increment,
primary key (c1)
);
insert into test values (200710000000000001);
And select this big number:
Will produce exception:
Code: Select all
System.OverflowException: Value was either too large or too small for an Int32.
at System.Decimal.ToInt32(Decimal d)
at System.Convert.ToInt32(Decimal value)
at System.Decimal.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Convert.ToInt32(Object value)
at System.Data.Common.Int32Storage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store in c1 Column. Expected type is Int32.
This error appears only in case c1 is auto_increment column.
2. Wrong type detection of the expression with string function:
It treats result as BLOB and there's no button to view its contents:
www.pichost.ru/out.php/i4758_2.gif
I look forward for changes in the next release.
Thank you very much!!!