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";

    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,

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?


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

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: 
>Sent from the Apache Derby Developers mailing list archive at Nabble.com.

Best Regards,

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

View raw message