Hi, For the query delete from test where "v2"='dummy'; the field v2 alone is being passed with double-quotes to NamedNode(String name). Other primary keys of the table (k1,k2 in my case) are not being double-quoted, hence the normalizeIdentifier converts them into upper-case.
Regards, Skanda On Tue, Feb 25, 2014 at 10:52 AM, Skanda <[email protected]> wrote: > 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 >>>>> >>>>> >>>>> >>>> >>>> >
