Why does update table not update data?

David_P_1

 

 

I want to update 'ca' to 'CA'. 

 

 

dbadmin=> select version();

 Vertica Analytic Database v7.1.2-0

(1 row)

 

 

dbadmin=> update tran_gw

dbadmin-> set merchant_name='CA'

dbadmin-> where merchant_state='ca';

OUTPUT

--------

   1184

(1 row)

 

dbadmin=> commit;

COMMIT

 

dbadmin=> select count(*)

dbadmin-> from tran_gw

dbadmin-> where merchant_state='ca';

count

-------

  1184

(1 row)

 

dbadmin=> select count(*)

dbadmin-> from tran_gw

dbadmin-> where merchant_state='CA';

  count   

----------

53838315

(1 row)

 

 

I update data, but the data does not change?

Sharon_Cutter

Because you're setting merchant_name to 'CA' instead of merchant_state.

 

  --Sharon