Do you hav
On Monday, February 24, 2014, Skanda <[email protected]> wrote:
> 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]<javascript:_e(%7B%7D,'cvml','[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
>>
>>
>>
>
>
