phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: table names& joins
Date Thu, 30 Jan 2014 15:36:11 GMT
Hi Dana,

This might be caused by using case-sensitive table names. An easy
walk-around can be creating tables and using them without quotation marks.
We will soon try to fix the problem, though.


Thanks,
Maryann


On Thu, Jan 30, 2014 at 9:16 AM, Livni, Dana <dana.livni@intel.com> wrote:

> Hi,
> In our project we are using the current master branch
> (phoenix-core-3.0.0-SNAPSHOT).
>
> We're trying to use the join operation but when running on table with
> lower case names we are getting an error.
>
> Example query:
> select * from "table1" inner join "table2" on "col1" ="col2";
>
> The error:
> Error: ERROR 1012 (42M03): Table undefined. tableName=TABLE2
> (state=42M03,code=1012)
>
> Did anyone encounter this problem in the past?
> Is there any solution planned for it?
>
> Thanks
> Dana
>
>
> ---------------------------------------------------------------------
> Intel Electronics Ltd.
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
>



-- 
Thanks,
Maryann

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message