firebird-automations

Commented by: @AlexPeshkoff Can not reproduce: $ \./isql \-z employee \-user sysdba ISQL Version: LI\-V3\.0\.5\.33154\-dev Firebird 3\.0 Server version: LI\-V3\.0\.5\.33154\-dev Firebird 3\.0 Database: employee, User: SYSDBA SQL\> CREATE EXCEPTION EX\_1...

Commented by: Jan Kohlmeyer (colaflasche) Okay, with isql I also can't reproduce it\. I've only by using IB\-Expert or IBDAC DataAccess\-Components with my Delphi\.

Commented by: @AlexPeshkoff That confirms that this is due to restriction of ISC API\. Status vector length is limited by 20 elements \(each error message and each argument to it...

Commented by: Vadim Mescheryakov (vadimmescheryakov) I attached two files for reproduction

Modified by: Vadim Mescheryakov (vadimmescheryakov) Attachment: create\-database\-script\.sql \[ 13580 \] Attachment: Large Query\.sql \[ 13581 \]

Commented by: @dyemanov Looks like a duplicate for [CORE6223](https://github.com/FirebirdSQL/firebird/issues?q=CORE6223+in%3Atitle) and [CORE395](https://github.com/FirebirdSQL/firebird/issues?q=CORE395+in%3Atitle)\. Binary operations \(\+ \- \* / AND OR\) are parsed and evaluated recursively and stack size is a limited...

Commented by: Vadim Mescheryakov (vadimmescheryakov) FB 2\.5 copes well with this SQL

Commented by: @dyemanov AFAIU, it does not execute your query at all \-\- due to "block size exceeds implementation restriction" error\.

Commented by: Vadim Mescheryakov (vadimmescheryakov) Yes\. I meant "copes" in sense \- Fb 2\.5 doesn't crash, only returns error

Commented by: Alice F. Bird (firebirds) Date: 2006\-01\-17 14:55 Sender: dimitr Logged In: YES user\_id=61270 I doubt anyone would be interested even in not so near future\. Those needing proper...