mpp20207_update.ans

-- start_ignore
SET optimizer=on;
SET
SET optimizer_log=on;
SET
-- end_ignore
-- @author prabhd 
-- @created 2012-12-05 12:00:00 
-- @modified 2012-12-05 12:00:00 
-- @tags dml 
-- @db_name dmldb
-- @description Mpp-20207
\echo --start_ignore
--start_ignore
set gp_enable_column_oriented_table=on;
psql:mpp20207_update_orca.sql:14: ERROR:  unrecognized configuration parameter "gp_enable_column_oriented_table"
\echo --end_ignore
--end_ignore
ALTER TABLE altable DROP COLUMN b;
ALTER TABLE
ALTER TABLE altable ADD CONSTRAINT c_check CHECK (c > 0);
ALTER TABLE
INSERT INTO altable(a, c) VALUES(0, 10);
INSERT 0 1
SELECT * FROM altable ORDER BY 1;
 a | c  
---+----
 0 | 10
(1 row)

UPDATE altable SET c = -10;
psql:mpp20207_update_orca.sql:21: ERROR:  One or more assertions failed  (seg1 slice1 antova-mbp.local:40011 pid=39781)
DETAIL:  Check constraint c_check for table altable was violated
SELECT * FROM altable ORDER BY 1;
 a | c  
---+----
 0 | 10
(1 row)

UPDATE altable SET c = 1;
UPDATE 1
SELECT * FROM altable ORDER BY 1;
 a | c 
---+---
 0 | 1
(1 row)