commit 587084d19ff57808c77c62b6b7849ef11e17842e
author Shawn O. Pearce <sop@google.com> Mon Jun 20 07:58:33 2011 -0700
committer Shawn O. Pearce <sop@google.com> Mon Jun 20 07:59:39 2011 -0700
tree 9cf8dbad53141e93e8c470c753b4353a6ffbb69b
parent 22f29ef8fb5a3d12006a49f1877227ed76da78cf

Don't delete values from MySQL sequence tables

At server restart MySQL uses the maximum value in the table's
auto_increment column to  restart the sequence. Deleting rows
causes this to always be 0, making sequences restart from 1 on
the next server start.

Change-Id: I50df069da1266161d21178359b45e6328f57e0c0

pom.xml

diff --git a/pom.xml b/pom.xml
index a494b3b..4852e57 100644
--- a/pom.xml
+++ b/pom.xml
@@ -21,7 +21,7 @@
   <groupId>gwtorm</groupId>
   <artifactId>gwtorm</artifactId>
   <packaging>jar</packaging>
-  <version>1.1.4</version>
+  <version>1.1.5</version>
   <name>gwtorm</name>
   <description>Tiny ORM</description>
   <url>http://android.git.kernel.org/?p=tools/gwtorm.git</url>

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

diff --git a/src/main/java/com/google/gwtorm/schema/sql/DialectMySQL.java b/src/main/java/com/google/gwtorm/schema/sql/DialectMySQL.java
index 98cf63e..bc787da 100644
--- a/src/main/java/com/google/gwtorm/schema/sql/DialectMySQL.java
+++ b/src/main/java/com/google/gwtorm/schema/sql/DialectMySQL.java
@@ -113,7 +113,6 @@
         } finally {
           rs.close();
         }
-        st.execute("DELETE FROM " + seqname + " WHERE s=" + r);
         return r;
       } finally {
         st.close();