Hi James, I don't have any secondary indexes for the table. There is no difference with NO_INDEX also, anyways.
delete /*+ NO_INDEX */ from test where "v2"='dummy'; Error: ERROR 504 (42703): Undefined column. columnName=K1 (state=42703,code=504) Despite having the columns in lowercase, the getColumn(String name) in PTableImpl always gets the column names in upper-case. Regards, Skanda On Mon, Feb 24, 2014 at 10:32 PM, James Taylor <[email protected]>wrote: > 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]> 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 >>>> >>>> >>>> >>> >>>
