From 1e15e9aaece89661386111a20613e68929628882 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Mon, 25 Jun 2012 14:26:45 -0400
Subject: [PATCH] merge next() compatibility

---
 lib/sqlalchemy/sql/compiler.py  | 2 +-
 lib/sqlalchemy/util/__init__.py | 2 +-
 lib/sqlalchemy/util/compat.py   | 5 +++++
 3 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py
index bc81da22c5..2ba581384f 100644
--- a/lib/sqlalchemy/sql/compiler.py
+++ b/lib/sqlalchemy/sql/compiler.py
@@ -286,7 +286,7 @@ class SQLCompiler(engine.Compiled):
         poscount = itertools.count(1)
         self.string = re.sub(
                         r'\[_POSITION\]', 
-                        lambda m:str(next(poscount)), 
+                        lambda m:str(util.next(poscount)), 
                         self.string)
 
     @util.memoized_property
diff --git a/lib/sqlalchemy/util/__init__.py b/lib/sqlalchemy/util/__init__.py
index 13914aa7dc..ac5de443be 100644
--- a/lib/sqlalchemy/util/__init__.py
+++ b/lib/sqlalchemy/util/__init__.py
@@ -7,7 +7,7 @@
 from compat import callable, cmp, reduce, defaultdict, py25_dict, \
     threading, py3k_warning, jython, pypy, win32, set_types, buffer, pickle, \
     update_wrapper, partial, md5_hex, decode_slice, dottedgetter,\
-    parse_qsl, any, contextmanager
+    parse_qsl, any, contextmanager, next
 
 from _collections import NamedTuple, ImmutableContainer, immutabledict, \
     Properties, OrderedProperties, ImmutableProperties, OrderedDict, \
diff --git a/lib/sqlalchemy/util/compat.py b/lib/sqlalchemy/util/compat.py
index 99b92b1e34..534adc42b1 100644
--- a/lib/sqlalchemy/util/compat.py
+++ b/lib/sqlalchemy/util/compat.py
@@ -40,6 +40,11 @@ else:
 
     set_types = set, sets.Set
 
+if sys.version_info < (2, 6):
+    def next(iter):
+        return iter.next()
+else:
+    next = next
 if py3k_warning:
     import pickle
 else:
-- 
2.47.2