Subject | View limitations |
---|---|
Author | PenWin |
Post date | 2007-08-14T09:36:41Z |
Hi again!
Are there any "official" limitations to what statement a VIEW can or can't
contain? I ask because in my Firebird 1.5 application I found a SELECT
statement which works perfectly as a standalone statement but can't be used
to create a VIEW:
SELECT *
FROM sometable
LEFT JOIN someprocedure(sometable.key) ON 1=1
I wonder if it is a known limitation of the engine or if it is a bug. Not
that it changes anything, as I can't upgrade to a newer version even if it
was a bug and got fixed, but I am curious.
Pepak
Are there any "official" limitations to what statement a VIEW can or can't
contain? I ask because in my Firebird 1.5 application I found a SELECT
statement which works perfectly as a standalone statement but can't be used
to create a VIEW:
SELECT *
FROM sometable
LEFT JOIN someprocedure(sometable.key) ON 1=1
I wonder if it is a known limitation of the engine or if it is a bug. Not
that it changes anything, as I can't upgrade to a newer version even if it
was a bug and got fixed, but I am curious.
Pepak