commit f4f8bccbd4e2c3979a83d5b2f49e16a99a3a2016
author Julien Nabet <serval2412@yahoo.fr> Mon Sep 09 22:12:38 2019 +0200
committer Julien Nabet <serval2412@yahoo.fr> Mon Sep 09 22:57:02 2019 +0200
tree 208055335100c1dde32f3d2e3724c9fd2db4daf4
parent f27ce3b2f6ec4646fe032459797b3d09e72d4ad8

Related tdf#127040: fix START WITH

Change-Id: I1dc5223015b787bcc122617d8ad9db6fabad20b2
Reviewed-on: https://gerrit.libreoffice.org/78787
Tested-by: Jenkins
Reviewed-by: Julien Nabet <serval2412@yahoo.fr>

dbaccess/source/filter/hsqldb/fbcreateparser.cxx

diff --git a/dbaccess/source/filter/hsqldb/fbcreateparser.cxx b/dbaccess/source/filter/hsqldb/fbcreateparser.cxx
index 756b2bd..edb3fcd 100644
--- a/dbaccess/source/filter/hsqldb/fbcreateparser.cxx
+++ b/dbaccess/source/filter/hsqldb/fbcreateparser.cxx
@@ -184,7 +184,11 @@
            // start with 0:
            // HSQLDB: first value will be 0.
            // Firebird: first value will be 1.
            sSql.append(columnIter->getStartValue() - 1);
            // but we can't put -1 for Firebird in case HSQLDB begins to 0
            sal_Int32 nStartValue = columnIter->getStartValue();
            if (nStartValue)
                --nStartValue;
            sSql.append(nStartValue);
            sSql.append(")");
        }
        else if (!columnIter->isNullable())