Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 21 Feb 2007 @ 12:28:14 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: SUBSTR query
From:   Barry Hull

  I've tried the above and it works. Thank you very much, for your help.  

  Can anyone explain what happened here? Why the Select worked as it was but the Update needed changing to the above?  

I would have expected the SELECT to work the same as the UPDATE (i.e. to fail with the error). I suspect that in the SELECT, the optimizer is re-ordering the conditions as someone else stated, and that this allowed the SELECT to work.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020