diff options
Diffstat (limited to 'src/test/regress/expected/func_index.out')
-rw-r--r-- | src/test/regress/expected/func_index.out | 64 |
1 files changed, 0 insertions, 64 deletions
diff --git a/src/test/regress/expected/func_index.out b/src/test/regress/expected/func_index.out deleted file mode 100644 index 307ac97b4bc..00000000000 --- a/src/test/regress/expected/func_index.out +++ /dev/null @@ -1,64 +0,0 @@ -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); - pg_stat_get_xact_tuples_hot_updated -------------------------------------- - 0 -(1 row) - -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"}'); -update keyvalue set info='{"name": "john", "data": "some other data"}' where id=1; -select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); - pg_stat_get_xact_tuples_hot_updated -------------------------------------- - 1 -(1 row) - -update keyvalue set info='{"name": "smith", "data": "some other data"}' where id=1; -select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); - pg_stat_get_xact_tuples_hot_updated -------------------------------------- - 1 -(1 row) - -update keyvalue set info='{"name": "smith", "data": "some more data"}' where id=1; -select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); - pg_stat_get_xact_tuples_hot_updated -------------------------------------- - 2 -(1 row) - -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"}'); -update keyvalue set info='{"name": "john", "data": "some other data"}' where id=1; -select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); - pg_stat_get_xact_tuples_hot_updated -------------------------------------- - 1 -(1 row) - -update keyvalue set info='{"name": "smith", "data": "some other data"}' where id=1; -select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); - pg_stat_get_xact_tuples_hot_updated -------------------------------------- - 1 -(1 row) - -update keyvalue set info='{"name": "smith", "data": "some more data"}' where id=1; -select pg_stat_get_xact_tuples_hot_updated('keyvalue'::regclass); - pg_stat_get_xact_tuples_hot_updated -------------------------------------- - 2 -(1 row) - -rollback; |