From c99e85259cdc423e88688dda7101ea3b5846aed5 Mon Sep 17 00:00:00 2001
From: Alain Spineux <alain@baculasystems.com>
Date: Fri, 2 Sep 2022 11:35:37 +0200
Subject: [PATCH] regress: tweak snapshot-lvm-test for sqlite

- the auto numbering is not the same between pgsql and sqlite
  - the counter are shared by all "serial" in pgsql
  - while each "auto increment" have there own counter
---
 regress/tests/snapshot-lvm-test | 15 +++++++++++----
 1 file changed, 11 insertions(+), 4 deletions(-)

diff --git a/regress/tests/snapshot-lvm-test b/regress/tests/snapshot-lvm-test
index 3339d9794..4fac7da16 100755
--- a/regress/tests/snapshot-lvm-test
+++ b/regress/tests/snapshot-lvm-test
@@ -10,6 +10,13 @@ TestName="snapshot-lvm-test"
 JobName=Incremental
 . scripts/functions
 
+SNAP1=1
+SNAP3=3
+if [ x$WHICHDB != x"--with-sqlite3" ]; then
+   # the numbering is different when using sqlite
+   SNAP3=2
+fi
+
 ${rscripts}/cleanup
 ${rscripts}/copy-test-confs
 
@@ -113,12 +120,12 @@ list files jobid=1
 @$out ${tmp}/list1.snap_listclient
 snapshot listclient
 @$out ${tmp}/list1.snap_update
-snapshot update client snapshotid=1 comment="test1"
-snapshot update client snapshotid=1 retention=3
+snapshot update client snapshotid=$SNAP1 comment="test1"
+snapshot update client snapshotid=$SNAP1 retention=3
 @$out ${tmp}/list1.snap_list2
-.jlist snapshot snapshotid=1
+.jlist snapshot snapshotid=$SNAP1
 @$out ${tmp}/list1.snap_list22
-.jlist snapshot snapshotid=3
+.jlist snapshot snapshotid=$SNAP3
 @$out ${tmp}/list1.snap_prune
 @sleep 4
 snapshot prune client yes
-- 
2.47.3