O envio de formulários no site de suporte está temporariamente indisponível para manutenção programada. Se precisar assistência imediata, entre em contato com o suporte técnico. Lamentamos o inconveniente.
Query Builder converts ANSI SQL to Oracle SQL incorrectly, when sending original sql that has an
Descrição
Query Builder converts ANSI SQL to Oracle SQL incorrectly, when sending original sql that has an outer join.
Steps to replicate: 1. opened the sql statement in Editor (see 1) 2. right-click -> Send to Query Builder 3. SQL statement in Query Builder has already removed the "left outer" from the query even before I convert from ANSI to Oracle SQL (see 2)
1. opened the sql statement in Query Builder (see 1) 2. SQL statement in Query Builder has already removed the "left outer" from the query even before I convert from ANSI to Oracle SQL (see 2)
So the actual issue is caused by simply opening the SQL statement in Query Builder.
1 Query before opening in Query Builder select a.request_history_id from f_request_history a left outer join f_request_info_history b on a.source_request_id = b.source_request_id and a.account_id = b.account_id inner join d_account_109 da on a.account_id=da.account_id inner join v_rmicw_collector_action vca on a.action_id = vca.action_id where a.created_time > (select case when max(c.created_time) is null then 2999 else max(c.created_time) end from f_request_requestinfo c);
2 Query after opening in Query Builder SELECT a.REQUEST_HISTORY_ID FROM F_REQUEST_HISTORY a JOIN F_REQUEST_INFO_HISTORY b ON (a.SOURCE_REQUEST_ID = b.SOURCE_REQUEST_ID) AND (a.ACCOUNT_ID = b.ACCOUNT_ID) JOIN D_ACCOUNT_109 da ON (a.ACCOUNT_ID = da.ACCOUNT_ID) JOIN V_RMICW_COLLECTOR_ACTION vca ON (a.ACTION_ID = vca.ACTION_ID) WHERE (a.CREATED_TIME > (SELECT CASE WHEN MAX (c.created_time) THEN 2999 ELSE c.created_time
Resolução
WORKAROUND: None
STATUS: Waiting for fix in a future release of Toad for Oracle.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Conteúdo recomendado
Produto(s):
Toad for Oracle
Tópico(s):
Technical Solutions
Histórico do artigo:
Criado em: 5/18/2011 Última atualização em: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bem-vindo ao Suporte
Você pode encontrar ajuda de suporte on-line para *produto* da Quest em um local de suporte afiliado. Clique em Continue (Continuar) para ser direcionado ao conteúdo de suporte correto e à assistência a *produto*.
Search All Articles
Encerramento do suporte aos navegadores IE 8, 9 e 10
O Portal da Quest Software não é mais compatível com IE8, 9 e 10. Recomendamos a atualização do navegador para a versão mais recente do Internet Explorer ou do Chrome.