Just for information:
Oracle returns NULL's in both cases: for SUM() and for
AVG().
I checked it for ver. 8.1.7 and 9.2.0
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> On Thu, 2005-09-08 at 10:24 -0700, Will Leshner
> wrote:
> > Say I have a column called 'b' in a table called
> 'test' a
Oracle 9i:
A B SUM(C)
1 2 2
[NULL] 2 4
1 [NULL] 8
[NULL] [NULL] 16
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> I'm rewriting the aggregate function processing in
> SQLite
> (so that it runs faster and uses less memory) and I
> want to
> make sure I
I noticed this strange behavior on Sqlite since I
started using it. This kind of SQL is not correct and
normally any DB should return an error. For example,
Oracle would return this error: "ORA-00937: not a
single-group group function".
Sqlite does return some kind of result for incorrect
SQL queri
I'm very familiar with transactions in Oracle &
Sybase. The provide with mechanism to figure out state
if SQL execution and COMMIT or ROLLBACK.
I did not find any way to do that in SQLITE, but it
has specific syntax like this bellow:
BEGIN TRANSACTION ON CONFLICT ROLLBACK;
END TRANSACTION;
w
ess
of actual SQL result. I have absolutely no knowledge
of my SQL execution status.
Vladimir
--- Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> On 5/12/05, Vladimir Zelinski <[EMAIL PROTECTED]>
> wrote:
> > I understand that. Question is HOW I can check if
> > statement fai
exec "ROLLBACK"
>
> Ideally you'd quit executing statements as soon as
> one fails.
> BTW: the 'END' statement is not needed.
>
> Gé
>
> Vladimir Zelinski wrote:
> > Of course, I read documentation and saw that
> > transaction
Of course, I read documentation and saw that
transaction is a supported feature. But I can't get to
work it. In order to make sure that we talk about the
same thing I understand transaction as atomic
operation. One or more data modification language
statements can be placed within transaction. Onl
7 matches
Mail list logo