phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Tables can have schema name but indexes cannot
Date Fri, 12 Aug 2016 15:56:19 GMT
Hi Michael,
SQL dictates that an index must be in the same schema as the table it's
indexing.
Thanks,
James

On Fri, Aug 12, 2016 at 8:50 AM, Michael McAllister <
mmcallister@homeaway.com> wrote:

> Hi
>
>
>
> Is there any reason we can specify the schema name for a table, but not an
> index. I note that the grammar online makes it clear this isn’t part of the
> syntax, but it would be nice if we could do it. To illustrate what I’d
> like:-
>
>
>
> -- Create the table
>
>
>
> CREATE TABLE IF NOT EXISTS MMCALLISTER.TEST
>
> ( c1 INTEGER NOT NULL
>
> , c2 VARCHAR NULL
>
> , c3 VARCHAR NULL
>
> , CONSTRAINT TEST_PK PRIMARY KEY (c1)
>
> );
>
>
>
> -- This does not work
>
>
>
> CREATE INDEX IF NOT EXISTS MMCALLISTER.TEST_IX01
>
> ON MMCALLISTER.TEST
>
> ( c2 )
>
> INCLUDE ( c3 );
>
>
>
> -- This works
>
>
>
> CREATE INDEX IF NOT EXISTS TEST_IX01
>
> ON MMCALLISTER.TEST
>
> ( c2 )
>
> INCLUDE ( c3 );
>
>
>
> Michael McAllister
>
> Staff Data Warehouse Engineer | Decision Systems
>
> mmcallister@HomeAway.com | C: 512.423.7447 | skype: michael.mcallister.ha
> <zimmkate@hotmail.com> | webex: https://h.a/mikewebex
>
> This electronic communication (including any attachment) is confidential.
> If you are not an intended recipient of this communication, please be
> advised that any disclosure, dissemination, distribution, copying or other
> use of this communication or any attachment is strictly prohibited.  If you
> have received this communication in error, please notify the sender
> immediately by reply e-mail and promptly destroy all electronic and printed
> copies of this communication and any attachment.
>

Mime
View raw message