Fix subtransactions test

orioledb · Nov 29, 2024 · 14df974 · 14df974
1 parent c494580
commit 14df974
Show file tree

Hide file tree

Showing 2 changed files with 2 additions and 24 deletions.
diff --git a/expected/subtransactions.out b/expected/subtransactions.out
@@ -771,7 +771,7 @@ FETCH FROM abc;
 (0 rows)
 
 ROLLBACK;
--- Check for logical xid overflow
+-- Check for logical xid assignment
 BEGIN;
 DO $$
 BEGIN
@@ -782,18 +782,6 @@ BEGIN
     END LOOP;
 END;$$;
 ROLLBACK;
-BEGIN;
-DO $$
-BEGIN
-    FOR i IN 1..100000 LOOP
-        BEGIN
-	    RAISE reading_sql_data_not_permitted;
-	EXCEPTION WHEN reading_sql_data_not_permitted THEN END;
-    END LOOP;
-END;$$;
-ERROR:  not enough logical xids
-CONTEXT:  PL/pgSQL function inline_code_block line 4 during statement block entry
-ROLLBACK;
 DROP EXTENSION orioledb CASCADE;
 NOTICE:  drop cascades to table o_subtrans
 DROP SCHEMA subtransactions CASCADE;

diff --git a/sql/subtransactions.sql b/sql/subtransactions.sql
@@ -413,7 +413,7 @@ ROLLBACK TO s1;
 FETCH FROM abc;
 ROLLBACK;
 
--- Check for logical xid overflow
+-- Check for logical xid assignment
 BEGIN;
 DO $$
 BEGIN
@@ -424,16 +424,6 @@ BEGIN
     END LOOP;
 END;$$;
 ROLLBACK;
-BEGIN;
-DO $$
-BEGIN
-    FOR i IN 1..100000 LOOP
-        BEGIN
-	    RAISE reading_sql_data_not_permitted;
-	EXCEPTION WHEN reading_sql_data_not_permitted THEN END;
-    END LOOP;
-END;$$;
-ROLLBACK;
 
 DROP EXTENSION orioledb CASCADE;
 DROP SCHEMA subtransactions CASCADE;