SqlDbx Forum

garbuya

Member

Bug in Edit/Replace

Lets type and highlight the following code

   MERGE INTO SLS_DTL MSTR
   USING PROD_COST_HIST COST
   ON(    COST.DIV_NBR  = MSTR.DIV_NBR
      AND COST.PROD_NBR = MSTR.PROD_NBR
     )
   WHEN MATCHED THEN UPDATE
    SET MSTR.UNIT_COST      = COST.UNIT_PRICE
   ;

Now do the foollowing:
1. Press Ctrl+H, check "Match whole word", pick "Selection only", Find=MSTR, Replace with=TGT and click 'Replace All"
2. Click OK. You are back to the replace window.
3. Now change Find=COST,Replace with=SRC  (note that "Match whole word", pick "Selection only" remains unchanged) and click 'Replace All"
3. Click OK and close window

Wow! Look what we got!
   MERGE INTO SLS_DTL TGT
   USING PROD_COST_HISTSRCT   <==== what is this?
   ON(    SRC.DIV_NBR  = TGT.DIV_NBR
      AND SRC.PROD_NBR = TGT.PROD_NBR
     )
   WHEN MATCHED THEN UPDATE
    SET TGT.UNIT_COST      =SRCT.UNIT_PRICE  <========= and this?
   ;

I tried it several times with the same result

sqldbxhelp

Administrator

Re: Bug in Edit/Replace

Thank you very much. This is definitely a bug.
It will be fixed in a next release