Subject SQL query aborts when SQL statement is too long or complex.
Author hosodaamiya
Hi all.

SQL query aborts when SQL statement is too long or complex.
Firebird seems to fail to handle the error of complecated SQL statement
when an error occurs at fbembedde.dll.
SQL query that includes IN operator with multiple columns and
OR conditons have been aborted in our development environment.
What is the cause of forced termination?

error:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-11-21T00:33:03.000000000Z" />
<EventRecordID>3463</EventRecordID>
<Channel>Application</Channel>
<Computer>WIN-SAH55JS7A8C</Computer>
<Security />
</System>
<EventData>
<Data>w3wp.exe</Data>
<Data>7.5.7601.17514</Data>
<Data>4ce7afa2</Data>
<Data>fbembed.DLL</Data>
<Data>2.5.1.26351</Data>
<Data>4e89609d</Data>
<Data>c00000fd</Data>
<Data>000000000015090a</Data>
</EventData>
</Event>

The embedded DB is accessed via .NetFramework Web service in IIS.

Environment information:
OS:win2008R2Server
IIS:7.5
fbembed.dll:2.5.1.26351
FirebirdSql.Data.FirebirdClient.dll:2.6.0
.NetFramework:3.5SP1