From 1f3e5d9826fe989f2212745f6b3592b2ef9b5e32 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 21 Apr 2016 10:36:19 -0400 Subject: Fix result set handling for case insensitive dupe cols Fixed bug where when using ``case_sensitive=False`` with an :class:`.Engine`, the result set would fail to correctly accomodate for duplicate column names in the result set, causing an error when the statement is executed in 1.0, and preventing the "ambiguous column" exception from functioning in 1.1. Change-Id: If582bb9fdd057e4da3ae42f7180b17d1a1a2d98e Fixes: #3690 --- test/sql/test_resultset.py | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'test/sql') diff --git a/test/sql/test_resultset.py b/test/sql/test_resultset.py index ba85fb82e..f74e51f62 100644 --- a/test/sql/test_resultset.py +++ b/test/sql/test_resultset.py @@ -688,6 +688,21 @@ class ResultProxyTest(fixtures.TablesTest): lambda: row[u2.c.user_id] ) + @testing.requires.duplicate_names_in_cursor_description + def test_ambiguous_column_case_sensitive(self): + eng = engines.testing_engine(options=dict(case_sensitive=False)) + + row = eng.execute(select([ + literal_column('1').label('SOMECOL'), + literal_column('1').label('SOMECOL'), + ])).first() + + assert_raises_message( + exc.InvalidRequestError, + "Ambiguous column name", + lambda: row['somecol'] + ) + @testing.requires.duplicate_names_in_cursor_description def test_ambiguous_column_contains(self): users = self.tables.users -- cgit v1.2.1