---In firebird-support@yahoogroups.com, ts@... wrote :
Is this SuperServer only or also SuperClassic?
SuperServer only.
Thank you!
Thomas
Hi
I don't know what the error message is, you didn't include it! but it is
likely your join is wrong and returning one of every detail record for
every header (i.e. 78000 * 3000 records !)
Check your query and make sure the detail records are linked to the
master correctly (i.e. JOIN detail
I think the image posting is not allowed here to display.
Below is the error message I see:
Note I have 2.75 GB free disk space.
*** IBPP::SQLException ***Context: Statement::FetchMessage: isc_dsql_fetch
failed
SQL Message : -901Unsuccessful execution caused by system error that does
notpreclude
There is enough free disk space (2.75 GB) available.
On Monday, 8 June 2015 10:08 AM, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] firebird-support@yahoogroups.com wrote:
Hi All,
I am running one SQL in that Master table has 78 thousand plus records and
detail table
Hi All,
I am running one SQL in that Master table has 78 thousand plus records and
detail table has 4 Laks and 3 thousand plus records. I have used Inner Join on
the primary key of Master table with the column in the Detail Table.
When I execute with small size database, but with this database
---In firebird-support@yahoogroups.com, joja.lists@... wrote :
Sorry, I didn’t check my mail till now. Thank you for creating the ticket.
And of course for fixing the bug.
Please, verify it using recent snapshot build
Regards,
Vlad
---In firebird-support@yahoogroups.com, ts@... wrote :
Is this SuperServer only or also SuperClassic?
SuperServer only.
Regards,
Vlad