node.js - Sequelize findAll [Op.or] 是否按顺序返回？

Question

假设我有这个非常基本的搜索

const from = 'something';
const to = 'somethingElse';

const firstSearchCondition = { from, to: 'test' };
const secondSearchCondition = { from: 'test', to };

const models = await Model.findAll({
      where: {
        [Op.or]: [
          firstSearchCondition,
          secondSearchCondition
        ],
      },
    });

const [toTest, fromTest] = models;

if (toTest && fromTest) {
   // both models exist
}

当两种模型都存在时， toTest 是否 100% 来自 firstSearchCondition？或订单无法保证

Answer 1

除非您使用 order by 子句，否则无法保证订单。不管查询。