Subject | Memory overflow executing a SQL statement |
---|---|
Author | kokok_kokok |
Post date | 2005-07-21T16:45:22Z |
My computer crashes when I excute the follwing statement:
"select 0,null, Sum(amount) from customers p group by 1,2"
I use Firebird 1.52 and IBOConsole. The database has few hundreds of
records.
I know that it is a stupid SQL statement, but it is the result of a
wizard, that of course, it can improved.
In any case, I guess that Firebird never should not crash the computer.
If I stop the Firebird Engine before the crash, I get the following
dataset result:
COLUMN0, COLUMN1, SUM
0, <null>, <null>
0, <null>, <null>
0, <null>, <null>
....
Hundreds of similar rows.
Is it a bug of Firebird?
Thank you
"select 0,null, Sum(amount) from customers p group by 1,2"
I use Firebird 1.52 and IBOConsole. The database has few hundreds of
records.
I know that it is a stupid SQL statement, but it is the result of a
wizard, that of course, it can improved.
In any case, I guess that Firebird never should not crash the computer.
If I stop the Firebird Engine before the crash, I get the following
dataset result:
COLUMN0, COLUMN1, SUM
0, <null>, <null>
0, <null>, <null>
0, <null>, <null>
....
Hundreds of similar rows.
Is it a bug of Firebird?
Thank you