Derive `next_value.type` from `Sequence.data_type` if available

Fixes #6287

Change-Id: I7d428ed86cd72cd910bfff9058a52c7fcb7c64ac

1 files changed, 5 insertions, 0 deletions

diff --git a/test/sql/test_sequences.py b/test/sql/test_sequences.py
index dd8491d31..3b25ba2ad 100644
--- a/test/sql/test_sequences.py
+++ b/test/sql/test_sequences.py
@@ -1,4 +1,5 @@
 import sqlalchemy as sa
+from sqlalchemy import BigInteger
 from sqlalchemy import Integer
 from sqlalchemy import MetaData
 from sqlalchemy import Sequence
@@ -387,6 +388,10 @@ class SequenceTest(fixtures.TestBase, testing.AssertsCompiledSQL):
         is_false(testing.db.dialect.has_table(connection, "table_1"))
         is_false(testing.db.dialect.has_table(connection, "table_2"))
 
+    def test_next_value_type(self):
+        seq = Sequence("my_sequence", data_type=BigInteger)
+        assert isinstance(seq.next_value().type, BigInteger)
+
 
 class FutureSequenceTest(fixtures.FutureEngineMixin, SequenceTest):
     __requires__ = ("sequences",)