如果没有文档记录,您可能不能依赖当前的行为-我不确定为这种情况定义预期行为是否有意义.
话虽如此,这个问题很耐人寻味,所以我做了一些研究.显然,对象是按键的反字母顺序排序的(但每个对象中的键首先按字母顺序排序).
select {'x': 1} finding_the_sort_for_objects
union all select {'a': DATE '2014-01-01'}
union all select {'x': DATE '2014-01-01'}
union all select {'x': DATE '2014-01-01'}
union all select {'x': DATE '2014-01-01'}
union all select {'x': DATE '2014-01-02'}
union all select {'x': DATE '2014-01-03'}
union all select {'x': DATE '2014-01-01', 'y': DATE '2014-01-01'}
union all select {'y': DATE '2014-01-01', 'x': DATE '2014-01-01'}
union all select {'y': DATE '2014-01-01', 'x': DATE '2014-01-01', '❄️': DATE '2014-01-01'}
union all select {'y': DATE '2014-01-01', 'x': DATE '2014-01-01', '❄️': DATE '2014-01-01', 'a': DATE '2014-01-01'}
union all select {'y': DATE '2014-01-01'}
union all select {'aa': DATE '2014-01-01'}
union all select {'A': DATE '2014-01-01'}
union all select {'0': DATE '2014-01-01'}
union all select {'❄️': DATE '2014-01-01'}
order by 1
(但请不要依赖于未记录的行为-如果您认为为对象定义排序顺序会有意义,请发送功能请求)