On Thursday, 26 Jul 2018 7:58 PM -0400, Richard Hipp wrote:
> On 7/26/18, Tomasz Kot wrote:
>> Hello,
>>
>> Beneath sql shall throw an error on CREATE VIEW statement (as invalid
>> column is specified), but it passes (SQLite 3.23.1).
>
> The error is deferred until you try to use the view. The
There is very little pressure to keep the shell tool small. So the check for
views which refer to non-existent tables could be put into there, as part of
one of the dot-commands which do checking.
As for the code, it doesn't require anything more than SQL commands. There's
no need for access
On 2018/07/27 1:59 PM, Dominique Devienne wrote:
Sigh. We already have 4 different check pragmas (cell-size, fk, integrity,
quick).
One more for views seems perfectly in line with those. Did anyone raise the
same
old light-code-bloat argument for those too, in the past? I for one cringe
every
On Fri, Jul 27, 2018 at 11:33 AM R Smith wrote:
> On 2018/07/27 10:40 AM, Dominique Devienne wrote:
> > On Fri, Jul 27, 2018 at 1:58 AM Richard Hipp wrote:
> >> On 7/26/18, Tomasz Kot wrote:
> >>> Beneath sql shall throw an error on CREATE VIEW statement (as invalid
> >>> column is
On 2018/07/27 10:40 AM, Dominique Devienne wrote:
On Fri, Jul 27, 2018 at 1:58 AM Richard Hipp wrote:
On 7/26/18, Tomasz Kot wrote:
Hello,
Beneath sql shall throw an error on CREATE VIEW statement (as invalid
column is specified), but it passes (SQLite 3.23.1).
The error is deferred
On Fri, Jul 27, 2018 at 1:58 AM Richard Hipp wrote:
> On 7/26/18, Tomasz Kot wrote:
> > Hello,
> >
> > Beneath sql shall throw an error on CREATE VIEW statement (as invalid
> > column is specified), but it passes (SQLite 3.23.1).
>
> The error is deferred until you try to use the view. The
On 7/26/18, Tomasz Kot wrote:
> Hello,
>
> Beneath sql shall throw an error on CREATE VIEW statement (as invalid
> column is specified), but it passes (SQLite 3.23.1).
The error is deferred until you try to use the view. The reason for
deferring the error is that the problem might be corrected
Hello,
Beneath sql shall throw an error on CREATE VIEW statement (as invalid
column is specified), but it passes (SQLite 3.23.1).
CREATE TABLE "testTable" ( "name" text not null );
INSERT INTO testTable values ('Tom');
SELECT * FROM testTable;
CREATE VIEW testView AS SELECT nameWrong
8 matches
Mail list logo
