[Firebird-devel] Not handled correctly is such a design in Legacy API.

2014-05-04 Thread Simonov Denis
Not handled correctly is such a design in Legacy API. IBExpert execute block as begin suspend; end FB2.5 No result. It's good. FB3.0 An error was found in the application program input parameters for the SQL statement. Incorrect values ​​within SQLDA structure. SQL error code = -804. e

Re: [Firebird-devel] Not handled correctly is such a design in Legacy API.

2014-05-04 Thread Dimitry Sibiryakov
04.05.2014 11:10, Simonov Denis wrote: > execute block > as > begin > suspend; > end > > FB2.5 > > No result. It's good. IMHO, such construction must produce error "no output variables" at prepare time as it is does "select from t": SQL> select from rdb$database; Statement failed, SQLST

Re: [Firebird-devel] Not handled correctly is such a design in Legacy API.

2014-05-04 Thread Simonov Denis
Dimitry Sibiryakov писал(а) в своём письме Sun, 04 May 2014 13:26:51 +0400: > 04.05.2014 11:10, Simonov Denis wrote: >> execute block >> as >> begin >> suspend; >> end >> >> FB2.5 >> >> No result. It's good. > >IMHO, such construction must produce error "no output variables" at > pre

Re: [Firebird-devel] Not handled correctly is such a design in LegacyAPI.

2014-05-04 Thread Claudio Valderrama C.
> -Original Message- > From: Simonov Denis [mailto:sim-m...@list.ru] > Sent: Domingo, 04 de Mayo de 2014 5:11 > > > Not handled correctly is such a design in Legacy API. > > IBExpert > > execute block > as > begin > suspend; > end > > FB2.5 > > No result. It's good. I would say

Re: [Firebird-devel] Not handled correctly is such a design in Legacy API.

2014-05-04 Thread Dimitry Sibiryakov
04.05.2014 11:34, Simonov Denis wrote: > Maybe you're right. But I am surprised at the difference in treatment in > the Legacy and the new API. And also the fact that in Fb2.5 is handled > differently. Following patch should fix the issue: > Index: why.cpp > ===

Re: [Firebird-devel] Not handled correctly is such a design in Legacy API.

2014-05-04 Thread Simonov Denis
Dimitry Sibiryakov писал(а) в своём письме Sun, 04 May 2014 13:39:22 +0400: > 04.05.2014 11:34, Simonov Denis wrote: >> Maybe you're right. But I am surprised at the difference in treatment in >> the Legacy and the new API. And also the fact that in Fb2.5 is handled >> differently. > >Follo

Re: [Firebird-devel] Questions on External Sort logic

2014-05-04 Thread Thomas Steinmaurer
Sean, >>> 1. A query's operations (the reading of the data and sorting) execute >>> in a single thread/process, correct? >> >> Correct. >> >>> 2. Is Internal sorting performed by the ExecuteWriteTempSortBlock() >> step? >> >> Internal buffer is sorted as soon as filled up to its limit and

Re: [Firebird-devel] Questions on External Sort logic

2014-05-04 Thread Claudio Valderrama C.
> -Original Message- > From: Thomas Steinmaurer [mailto:t...@iblogmanager.com] > Sent: Domingo, 04 de Mayo de 2014 5:43 > > > > Personally, I find it frustrating to what Firebird disk IO > profile when performing large select/sorts, on systems which > have IO to burn (RAM Disk, SSD or PC

Re: [Firebird-devel] Questions on External Sort logic

2014-05-04 Thread Thomas Steinmaurer
Claudio, >> -Original Message- >> From: Thomas Steinmaurer [mailto:t...@iblogmanager.com] >> Sent: Domingo, 04 de Mayo de 2014 5:43 >>> >>> Personally, I find it frustrating to what Firebird disk IO >> profile when performing large select/sorts, on systems which >> have IO to burn (RAM Dis

Re: [Firebird-devel] Feature request & discussion (Reply to Planning the post v3 development)

2014-05-04 Thread Molnár Attila
Hello Sean! On 2014.05.01. 21:24, Leyne, Sean wrote: >> TRIGGER : NEW/OLD values accessible by column name, and column number >> (PSQL) >> - e.g.: NEW['id'], NEW[0] >> - gain : code reduction, dynamic code (don't have to alter the trigger >> ICO >> the table structure altered) > 1- What