<reponame>Zhaojia2019/cubrid-testcases<filename>sql/_04_operator_function/_08_click_counter/_003_complex/cases/1011.sql<gh_stars>1-10
--[er]test incr, decr using expressions as its operand
CREATE CLASS board (
id  INT, title  VARCHAR(100), content  VARCHAR(4000), read_count  INT ,edit_count INT);
INSERT INTO board VALUES (1, 'aaa', 'text...', 0,10);
INSERT INTO board VALUES (2, 'bbb', 'text...', 0,0);
INSERT INTO board VALUES (3, 'ccc', 'text...', 0,0);

select incr(read_count+1) from board where id=1;
select decr(read_count-1) from board where id=1;

drop class board;
