commit c6d31993b63ffb8a03ff00dd9b01190ea7e2613e
author Thomas Meyer <thomas.m3y3r@googlemail.com> Sat Oct 03 19:59:51 2015 +0200
committer Thomas Meyer <thomas.m3y3r@googlemail.com> Sat Oct 03 20:00:12 2015 +0200
tree b4c5cd86326f4a8693626d002e39500541532299
parent 233c781514ec195984eb3161ba1afbbde03ee1ac

CreateSequenceSql: Explicitly start sequences with 1

Different database dialects start sequences with different values. Make
the starting value explicit.

Change-Id: I508f87931a8ab98426ebc0cd791e7edda121bb6d

src/main/java/com/google/gwtorm/schema/sql/SqlDialect.java

diff --git a/src/main/java/com/google/gwtorm/schema/sql/SqlDialect.java b/src/main/java/com/google/gwtorm/schema/sql/SqlDialect.java
index 3c68117..66f444d 100644
--- a/src/main/java/com/google/gwtorm/schema/sql/SqlDialect.java
+++ b/src/main/java/com/google/gwtorm/schema/sql/SqlDialect.java
@@ -192,10 +192,12 @@
     r.append("CREATE SEQUENCE ");
     r.append(seq.getSequenceName());
 
-    if (s.startWith() > 0) {
-      r.append(" START WITH ");
-      r.append(s.startWith());
-    }
+    /*
+     * Some gwtorm users seems to imply a start of 1, enforce this constraint
+     * here explicitly
+     */
+    r.append(" START WITH ");
+    r.append(s.startWith() > 0 ? s.startWith() : 1);
 
     if (s.cache() > 0) {
       r.append(" CACHE ");