MySQL Forums
Forum List  »  InnoDB

query works in 5.6 but not working in 5.7
Posted by: Henrique Lavnis
Date: August 01, 2014 08:00PM

I have this query that work in 5.6 but now I have a new server with 5.7, I moved the Data Bases with SQL Yog I used "copy to different.." then some querys not working.

SELECT SALDO.* FROM (
SELECT saldo.OID_SALDO_BANCO_CAIXA, caixa.OID_CAIXA, NULL AS OID_BANCO, saldo.DAT_DATA_SALDO, caixa.DES_DESCRICAO,
saldo.DEC_SALDO, caixa.BOL_HABILITADO
FROM gold_tsaldo_banco_caixa saldo
RIGHT JOIN gold_tcadastro_caixa caixa
ON caixa.OID_CAIXA = saldo.OID_CAIXA
UNION
SELECT saldo.OID_SALDO_BANCO_CAIXA, NULL, banco.OID_BANCO, saldo.DAT_DATA_SALDO, banco.DES_NOME,
saldo.DEC_SALDO, banco.BOL_HABILITADO
FROM gold_tsaldo_banco_caixa saldo
RIGHT JOIN gold_tbanco banco
ON banco.OID_BANCO = saldo.OID_BANCO
ORDER BY OID_CAIXA, OID_BANCO, DAT_DATA_SALDO DESC
)SALDO
WHERE SALDO.BOL_HABILITADO = 1
GROUP BY SALDO.OID_CAIXA, SALDO.OID_BANCO;

Options: ReplyQuote


Subject
Views
Written By
Posted
query works in 5.6 but not working in 5.7
1986
August 01, 2014 08:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.