AW: SQL Studio and lowercase name of objects 2007-06-21 - By Auer, Wolfgang
Back
Hello Lukasz,
Thank you for your hints.
If you work a lot with lower case identifiers please switch off the preference
"Identifiers in Create Dialogs Uppercase". (Session->Settings->General)
The View-Dialog and Index-Dialog will then not upper names.
The behaviour of the View-Dialog with "expressions columns" will be improved in
a future version of SQL Studio.
regards
Wolfgang
Wolfgang Auer
Developer
MaxDB&liveCache
mailto:wolfgang.auer@(protected)
http://www.sap.com
Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), L?o Apotheker
(stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard
Oswald, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso
Plattner
Registergericht/Commercial Register Mannheim No HRB 350269
Diese E-Mail kann Betriebs- oder Gesch?ftsgeheimnisse oder sonstige
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrt?mlich
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielf?ltigung
oder Weitergabe der E-Mail ausdr?cklich untersagt.
Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen
Dank.
This e-mail may contain trade secrets or privileged, undisclosed, or otherwise
confidential information. If you have received this e-mail in error, you are
hereby notified that any review, copying, or distribution of it is strictly
prohibited. Please inform us immediately and destroy the original transmittal.
Thank you for your cooperation.
-- --Urspr?ngliche Nachricht-- --
Von: Lukasz Misztal [mailto:miszluk@(protected)]
Gesendet: Donnerstag, 21. Juni 2007 12:08
An: Anhaus, Thomas; maxdb
Betreff: SQL Studio and lowercase name of objects
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=wolfgang.auer@(protected)
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
