diff options
| -rw-r--r-- | src/test/regress/expected/func_index.out | 9 | ||||
| -rw-r--r-- | src/test/regress/sql/func_index.sql | 9 |
2 files changed, 12 insertions, 6 deletions
diff --git a/src/test/regress/expected/func_index.out b/src/test/regress/expected/func_index.out index e616ea2e55..307ac97b4b 100644 --- a/src/test/regress/expected/func_index.out +++ b/src/test/regress/expected/func_index.out @@ -1,3 +1,4 @@ +begin; create table keyvalue(id integer primary key, info jsonb); create index nameindex on keyvalue((info->>'name')) with (recheck_on_update=false); insert into keyvalue values (1, '{"name": "john", "data": "some data"}'); @@ -8,7 +9,8 @@ select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); 0 (1 row) -drop table keyvalue; +rollback; +begin; create table keyvalue(id integer primary key, info jsonb); create index nameindex on keyvalue((info->>'name')) with (recheck_on_update=true); insert into keyvalue values (1, '{"name": "john", "data": "some data"}'); @@ -33,7 +35,8 @@ select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); 2 (1 row) -drop table keyvalue; +rollback; +begin; create table keyvalue(id integer primary key, info jsonb); create index nameindex on keyvalue((info->>'name')); insert into keyvalue values (1, '{"name": "john", "data": "some data"}'); @@ -58,4 +61,4 @@ select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); 2 (1 row) -drop table keyvalue; +rollback; diff --git a/src/test/regress/sql/func_index.sql b/src/test/regress/sql/func_index.sql index b08f7544fc..86f8c71179 100644 --- a/src/test/regress/sql/func_index.sql +++ b/src/test/regress/sql/func_index.sql @@ -1,10 +1,12 @@ +begin; create table keyvalue(id integer primary key, info jsonb); create index nameindex on keyvalue((info->>'name')) with (recheck_on_update=false); insert into keyvalue values (1, '{"name": "john", "data": "some data"}'); update keyvalue set info='{"name": "john", "data": "some other data"}' where id=1; select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); -drop table keyvalue; +rollback; +begin; create table keyvalue(id integer primary key, info jsonb); create index nameindex on keyvalue((info->>'name')) with (recheck_on_update=true); insert into keyvalue values (1, '{"name": "john", "data": "some data"}'); @@ -14,8 +16,9 @@ update keyvalue set info='{"name": "smith", "data": "some other data"}' where id select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); update keyvalue set info='{"name": "smith", "data": "some more data"}' where id=1; select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); -drop table keyvalue; +rollback; +begin; create table keyvalue(id integer primary key, info jsonb); create index nameindex on keyvalue((info->>'name')); insert into keyvalue values (1, '{"name": "john", "data": "some data"}'); @@ -25,6 +28,6 @@ update keyvalue set info='{"name": "smith", "data": "some other data"}' where id select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); update keyvalue set info='{"name": "smith", "data": "some more data"}' where id=1; select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); -drop table keyvalue; +rollback; |