Think this bug might have been fixed on master branch. Skanda, mind if you try with the master branch just to confirm?
Thanks, Maryann On Tue, Feb 25, 2014 at 2:06 PM, James Taylor <[email protected]>wrote: > Thanks for the info, Skanda. Would you mind filing a JIRA and we'll get > this fixed up? It'd be helpful if you include a unit test if possible. > > Thanks, > James > > > On Mon, Feb 24, 2014 at 10:21 PM, Skanda <[email protected]>wrote: > >> 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 >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>> >> > -- Thanks, Maryann
