From bb02957181911989ec0e92dd555de41c9287f07a Mon Sep 17 00:00:00 2001 From: Jason Kirtland Date: Fri, 25 May 2007 22:34:02 +0000 Subject: [PATCH] - Don't use '+' for sql expr concatenation by default --- test/orm/mapper.py | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/test/orm/mapper.py b/test/orm/mapper.py index 921b5f9b06..afb5bac1ff 100644 --- a/test/orm/mapper.py +++ b/test/orm/mapper.py @@ -1659,7 +1659,14 @@ class InstancesTest(MapperSuperTest): def testmappersplustwocolumns(self): mapper(User, users) - s = select([users, func.count(addresses.c.address_id).label('count'), ("Name:" + users.c.user_name).label('concat')], from_obj=[users.outerjoin(addresses)], group_by=[c for c in users.c], order_by=[users.c.user_id]) + + # Fixme ticket #475! + if db.engine.name == 'sqlite': + col2 = ("Name:" + users.c.user_name).label('concat') + else: + col2 = func.concat("Name:", users.c.user_name).label('concat') + + s = select([users, func.count(addresses.c.address_id).label('count'), col2], from_obj=[users.outerjoin(addresses)], group_by=[c for c in users.c], order_by=[users.c.user_id]) sess = create_session() (user7, user8, user9) = sess.query(User).select() q = sess.query(User) -- 2.47.2