You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by adhoc334 <jk...@gmail.com> on 2010/08/17 05:41:50 UTC

invalid table name if too many dots (".") in it?

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.

Re: invalid table name if too many dots (".") in it?

Posted by Eranda Sooriyabandara <er...@gmail.com>.

Hi guys,
If adding something,
keywords for a table name is perfectly ok [1]. I don't think this is
included to 10.6.1 but in the future releases it will be.
thanks

[1]-https://issues.apache.org/jira/browse/DERBY-2785

Re: invalid table name if too many dots (".") in it?

Posted by Nirmal Fernando <ni...@gmail.com>.

Thanks Lily for correcting me!! :)

On Tue, Aug 17, 2010 at 10:19 AM, Lily Wei <li...@yahoo.com> wrote:

> 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 <ni...@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 <jk...@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.
>
>


-- 
Best Regards,
Nirmal

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

Re: invalid table name if too many dots (".") in it?

Posted by Lily Wei <li...@yahoo.com>.

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 <ni...@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 <jk...@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.

Re: invalid table name if too many dots (".") in it?

Posted by Nirmal Fernando <ni...@gmail.com>.

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 <jk...@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.