Sorry I get the below exception when I try to do a delete from table :
Error: ERROR 504 (42703): Undefined column. columnName=K1
(state=42703,code=504)
Example table : create table "test"("k1" varchar,"k2" varchar,"d"."v1"
unsigned_int,"d"."v2" varchar CONSTRAINT pk PRIMARY KEY("k1","k2"));
Query : delete from "test" where "v2"='dummy';
On Mon, Feb 24, 2014 at 6:12 PM, Skanda <[email protected]> wrote:
> Hi,
>
> The delete command doesn't work for tables and columns that are defined to
> be in lower-case.
> I'm getting the following exception :
>
> Error: ERROR 1012 (42M03): Table undefined. tableName=test
> (state=42M03,code=1012)
>
> The same works for tables and columns in upper-case.
>
> Example table : create table "test"(k1 varchar,k2 varchar,"d"."v1"
> unsigned_int,"d"."v2" varchar CONSTRAINT pk PRIMARY KEY(k1,k2));
>
> Query : delete from "test" where "v2"='dummy';
>
> Regards,
> Skanda
>
>
>
