MySQL查询挂起

Question

此查询在.016秒内返回363行：

SELECT
d.ticker,
d.price,
d.dQuoteImbalanceSharesSnap,
d.mocBuyImbalanceSharesSnap,
d.mocSellImbalanceSharesSnap,
d.snapShares,
d.snapValue,
d.snapDirection

FROM
EODStrategies.t_strat_SinglesFlipSPX1550_Detail d 
WHERE 
d.runDate = '2020-11-24' 
AND d.event = 'Terminated';

当我用简单的arethmetic:添加行时，这个查询挂起

SELECT
d.ticker,
d.price,
d.dQuoteImbalanceSharesSnap,
d.mocBuyImbalanceSharesSnap,
d.mocSellImbalanceSharesSnap,
d.snapShares,
d.dQuoteImbalanceSharesSnap + (mocBuyImbalanceSharesSnap - mocSellImbalanceSharesSnap),
d.snapValue,
d.snapDirection

FROM
EODStrategies.t_strat_SinglesFlipSPX1550_Detail d 
WHERE 
d.runDate = '2020-11-24' 
AND d.event = 'Terminated';

为什么第二个查询挂起？

Answer 1

可能是列名长度最大的问题？

如果您更改线路：d.dQuoteInbalanceSharesSnap+(mocBuyImbalanceSharesSnap-mocSellImbalanceSharedsSnapp(，

收件人：d.dQuoteInbalanceSharesSnap+(mocBuyImbalanceSharesSnap-mocSellImbalanceSharedsSnapp(AS数学，