SQL Studio and lowercase name of objects 2007-06-21 - By Lukasz Misztal
Back
Tomas,
thanks for help, for me seems that SQL Studio is also vunerable for
lowercase names. It is frequent for getting definition from exist objects.
Can i also report following bugs in SQL Studio? If not, where can i do
this?
For example:
//-- ---- ---- ---- ---- ---- ----
CREATE TABLE "TableT1"
(
"Id" Fixed (10,0) NOT NULL DEFAULT SERIAL (1),
"Value" Varchar (200) UNICODE
)
//
insert into "TableT1" values (1,'xx')
//
CREATE VIEW "v_TableT1" AS SELECT "Id", NULL AS "NullValue" FROM "TableT1"
//
CREATE INDEX "Aa" ON "TableT1" ("Id" ASC)
//-- ---- ---- ---- ---- ---- ----
And bugs for it:
1) missing null value & wrong name of view
On SQL Studio:
- double click on view "v_TableT1"
- right click on export to SQL Dialog
result is:
CREATE VIEW "V_TABLET1"
(
"Id"
)
AS SELECT "Id", NULL AS "NullValue" FROM "TableT1"
2) wrong name of index
On SQL Studio:
- double click on index "Az"
- right click on export to SQL Dialog
result is:
CREATE INDEX "AA" ON "TableT1" ("Id" ASC)
Best regards,
Lukasz.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
