db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lily Wei <lily...@yahoo.com>
Subject Re: invalid table name if too many dots (".") in it?
Date Tue, 17 Aug 2010 04:49:52 GMT
Hi there:
    I believe it is legal for derby if you have delimiter around it.

    For example:
    ij> create table "table.subtable.etc.notes" (a int);
    0 rows inserted/updated/deleted
    ij> insert into "table.subtable.etc.notes" values (1);
    1 row inserted/updated/deleted
    ij> select * from "table.subtable.etc.notes";
    A
    -----------
    1

    1 row selected

    However, due to reasons in turn of "." and keyword "table",  I will think 
twice in turn of the table name I end up choosing.


Hope this help,
Lily




________________________________
From: Nirmal Fernando <nirmal070125@gmail.com>
To: derby-dev@db.apache.org
Sent: Mon, August 16, 2010 9:04:55 PM
Subject: Re: invalid table name if too many dots (".") in it?

Hi,

As I can see "table.subtable.etc.notes" is not a valid table name for two 
reasons:

1) You cannot use "." more than once. 
2) You cannot use "table.a" as a table name since it contains the word "table"

Hope this helps!



On Tue, Aug 17, 2010 at 9:11 AM, adhoc334 <jkoontz2010@gmail.com> wrote:


>if i'm creating a table called table.subtable.etc.notes, would i get an error
>because there are too many dots in it?
>--
>View this message in context: 
>http://old.nabble.com/invalid-table-name-if-too-many-dots-%28%22.%22%29-in-it--tp29449214p29449214.html
>
>Sent from the Apache Derby Developers mailing list archive at Nabble.com.
>
>


-- 
Best Regards,
Nirmal

C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.



      
Mime
View raw message