summaryrefslogtreecommitdiff
path: root/test/sql
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-01-20 21:00:08 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-01-20 21:00:08 +0000
commitc95faa5e8d171160e0786c7e5b8064eb4fd524bb (patch)
tree59658a06ff1e520bc97563ca043bb615224cbefe /test/sql
parent7838cb175913cc19ad3701a9de16ab16cdf0809f (diff)
downloadsqlalchemy-c95faa5e8d171160e0786c7e5b8064eb4fd524bb.tar.gz
- mysql table create options work on a generic passthru now, i.e. Table(..., mysql_engine='InnoDB',
mysql_collate="latin1_german2_ci", mysql_auto_increment="5", mysql_<somearg>...), helps [ticket:418]
Diffstat (limited to 'test/sql')
-rw-r--r--test/sql/query.py5
1 files changed, 4 insertions, 1 deletions
diff --git a/test/sql/query.py b/test/sql/query.py
index ac62eb8e9..bffb37e6b 100644
--- a/test/sql/query.py
+++ b/test/sql/query.py
@@ -158,8 +158,11 @@ class QueryTest(PersistTest):
self.assert_(r==[(3, 'ed'), (4, 'wendy'), (5, 'laura')])
r = self.users.select(offset=5, order_by=[self.users.c.user_id]).execute().fetchall()
self.assert_(r==[(6, 'ralph'), (7, 'fido')])
-
+
+ @testbase.unsupported('mysql')
def test_scalar_select(self):
+ """test that scalar subqueries with labels get their type propigated to the result set."""
+ # mysql and/or mysqldb has a bug here, type isnt propigated for scalar subquery.
datetable = Table('datetable', metadata,
Column('id', Integer, primary_key=True),
Column('today', DateTime))