table names& joins

["Livni, Dana" <da...@intel.com>]

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.

Re: table names& joins

[Maryann Xue <ma...@gmail.com>]

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