This line:
|
stmt = select(table.c.id).limit(1).scalar_subquery() |
is missing an order_by.
The test assumes select ordering. I'm maintaining the Google BigQuery dialect and this test failed as written because the result was [(4,)] without the order_by.
BTW, this test detected that we were doing union wrong. We were assuming that union() wanted UNION ALL not UNION DISTINCT. It would be good to have a dedicated test for that.
This line:
sqlalchemy/lib/sqlalchemy/testing/suite/test_select.py
Line 228 in e064ca8
is missing an
order_by.The test assumes select ordering. I'm maintaining the Google BigQuery dialect and this test failed as written because the result was
[(4,)]without theorder_by.BTW, this test detected that we were doing union wrong. We were assuming that
union()wantedUNION ALLnotUNION DISTINCT. It would be good to have a dedicated test for that.