[tryton-commits] [python-sql] [default] Add test to cover group by alias with mul...

[Cédric Krier]

details:   https://code.tryton.org/python-sql/commit/920ea1006b4f
branch:    default
user:      Cédric Krier <c...@b2ck.com>
date:      Wed Dec 24 12:00:34 2025 +0100
description:
        Add test to cover group by alias with multiple alias columns
diffstat:

 sql/tests/test_select.py |  8 ++++++++
 1 files changed, 8 insertions(+), 0 deletions(-)

diffs (18 lines):

diff -r d822cae093a1 -r 920ea1006b4f sql/tests/test_select.py
--- a/sql/tests/test_select.py  Tue Nov 25 10:23:15 2025 +0100
+++ b/sql/tests/test_select.py  Wed Dec 24 12:00:34 2025 +0100
@@ -205,6 +205,14 @@
             'SELECT %s FROM "t" AS "a" GROUP BY %s')
         self.assertEqual(tuple(query.params), ('foo', 'foo'))
 
+        output1 = column.as_('c1')
+        output2 = column.as_('c2')
+        query = self.table.select(output1, output2, group_by=output2)
+        self.assertEqual(str(query),
+            'SELECT "a"."c" AS "c1", "a"."c" AS "c2" FROM "t" AS "a" '
+            'GROUP BY 2')
+        self.assertEqual(tuple(query.params), ())
+
     def test_select_group_by_grouping_sets(self):
         query = self.table.select(
             Literal('*'),