Submitted by: odahan (odahan)

SFID: 521947#⁠
Submitted By: odahan

Firebird 1 rc2 :

Step 1:
Following query doesn't work (between can't be used
against datatype...) :

SELECT COUNT(*) FROM ODDSKCAT1 O WHERE (SELECT COUNT
(*) FROM ODDSKCAT2 O2 WHERE O2.DISKID=O.DISKID)
BETWEEN 21 AND 100

Step 2 :
query is corrected as follow (adding a cast) :

SELECT COUNT(*) FROM ODDSKCAT1 O WHERE CAST( (SELECT
COUNT(*) FROM ODDSKCAT2 O2 WHERE O2.DISKID=O.DISKID)
AS INTEGER) BETWEEN 21 AND 100

... Step 3 : Run and ... Crash server (AV message then
the server is killed by Windows). The crash is
immediate (no wait, so I thing the problem is in
parsing the query).

Database context : about 130 Mb gdb file, 3 tables,
the biggest is oddskcat2.
DISKID field is an Integer, primary key of table
ODDSKCAT1, a unique index on this field exists in
ODDSKCAT2.
OS: Windows 95 osr2

2 Questions :
1/ why the first syntax is not understood ?
2/ why a so hard crash with the "cast" ?