Do you have any secondary indexes on your tables? If so, can you try adding a /*+ NO_INDEX */ hint and let us know if the problem persists. Thanks, James
On Monday, February 24, 2014, James Taylor <[email protected]> wrote: > Do you hav > > On Monday, February 24, 2014, Skanda > <[email protected]<javascript:_e(%7B%7D,'cvml','[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]>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 >>> >>> >>> >> >>
