[Checkins] SVN: relstorage/trunk/relstorage/adapters/schema.py The history-free PL/SQL needs an update too

[Shane Hathaway]

Log message for revision 120115:
  The history-free PL/SQL needs an update too
  

Changed:
  U   relstorage/trunk/relstorage/adapters/schema.py

-=-
Modified: relstorage/trunk/relstorage/adapters/schema.py
===================================================================
--- relstorage/trunk/relstorage/adapters/schema.py	2011-02-05 11:10:39 UTC (rev 120114)
+++ relstorage/trunk/relstorage/adapters/schema.py	2011-02-05 11:18:04 UTC (rev 120115)
@@ -19,7 +19,7 @@
 from zope.interface import implements
 import re
 
-relstorage_op_version = '1.5a'
+relstorage_op_version = '1.5A'
 log = logging.getLogger("relstorage")
 
 history_preserving_schema = """
@@ -715,8 +715,11 @@
         FORALL indx IN zoids.first..zoids.last
             DELETE FROM object_state WHERE zoid = zoids(indx);
         FORALL indx IN zoids.first..zoids.last
-            INSERT INTO object_state (zoid, tid, state) VALUES
-            (zoids(indx), tids(indx), states(indx));
+            INSERT INTO object_state (zoid, tid, state_size, state) VALUES (
+                zoids(indx),
+                tids(indx),
+                COALESCE(LENGTH(states(indx)), 0),
+                states(indx));
     END restore;
 END relstorage_op;
 /