Re: [Firebird-test] Problem with non joined queries

[Dmitry Y. <di...@us...>]

"Venelin Dimitrov" wrote on Thu, 28 Aug 2003 09:41:18 +0000 (UTC):

>     I can't fetch any records with this query:

> SELECT
>   M.moduleid, M.name, M.path, M.readonly, M.tstamp, M.userid,
>   R.revisionid, R.version, R.revision, U.login, P.projectid, pjM.hidden
> FROM pjmodule pjM, projects P, modules M, revision R
> LEFT OUTER JOIN users U ON M.userid = U.userid
> WHERE
>   pjM.moduleid = 26
>   AND pjM.projectid = 1
>   AND P.projectid = pjM.projectid
>   AND M.moduleid = pjM.moduleid
>   AND R.moduleid = M.moduleid
> ORDER BY
>   R.version,
>   R.revision,
>   P.projectid

I'd prefer such queries to be rejected by the DSQL layer. Never mix SQL89
and SQL92 syntaxes (implicit and explicit joins) in one statement.

P.S. Please post support questions to fb-support. This forum is for the
engine test-suite engineers.


Dmitry