RE: Table sizes -a unknown table is the largest

Hi Wolfgang,
> It seems you created the table m with quotes.
>If you used the Table Definition Dialog of SQL Studio you should check
>the upper case option.
        No I do not use the table definition dialog to create
tables.This table "m" was a table of mine called "calldetailrecord" that
was somehow renamed to "m". I have no idea how/why this happened.

> Please check if you have any filter (which is case sensitive) for the
>catalog tree.
        I am unaware of these "filters" you speak of. How can I set up a
filter?? Is there a default filter??
Regards,
Ajit


-----Original Message-----
From: Auer, Wolfgang [mailto:wolfgang.auer@xxxxxxx] 
Sent: Tuesday, February 22, 2005 7:01 PM
To: Ajit Aranha
Subject: RE: Table sizes -a unknown table is the largest

Hello Ajit,  

It seems you created the table m with quotes.
If you used the Table Definition Dialog of SQL Studio you should check
the upper case option.

Please check if you have any filter (which is case sensitive) for the
catalog tree.

Regards
Wolfgang



-----Original Message-----
From: Ajit Aranha [mailto:ajit@xxxxxxxxxxxx] 
Sent: Dienstag, 22. Februar 2005 11:43
To: Auer, Wolfgang
Cc: Zabach, Elke; maxdb@xxxxxxxxxxxxxxx
Subject: RE: Table sizes -a unknown table is the largest

Hi Wolfgang,

SQLStudio version is 7.4.3.3

Select * from tables where tablename='m' returns:

OWNER   TABLENAME       PRIVILEGES      TYPE    TABLETYPE
CREATEDATE      CREATETIME      UPDSTATDATE     UPDSTATTIME
ALTERDATE       ALTERTIME       UNLOADED        SAMPLE_PERCENT
SAMPLE_ROWS     COMMENT TABLEID 
ONMOBILE        m       SEL+UPD+DEL+INS+REF+IND+ALT+    TABLE   TABLE
2003-08-19      21:32:15        2003-08-19      21:32:15
2004-07-14      13:31:11        NO      ?
        20000   ?       00000000000002C0        

I noticed that the tablename m is in lowercase,while other tablenames
are in uppercase in the "table" view

Also select * from onmobile.m does not work. (says unknown tablename m.
Yes I am connected as the user ONMOBILE)

Select * from m works however.

Regards,
Ajit


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx