Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-11-18 Thread Vlad Khorsun
> On 18/11/2011 05:38, Vlad Khorsun wrote: >>> On 16-11-2011 22:39, Frank Ingermann wrote: ...but it leads to an endless loop/recursion (using latest Fb3 beta) :-( >>> Before decide what to do, I'd like to hear Vlad about the error >>> isc_dsql_cte_wrong_clause, which, for example, h

Re: [Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

2011-11-18 Thread Damyan Ivanov
-=| Alex Peshkoff, 17.11.2011 13:28:00 +0400 |=- > On 11/17/11 11:37, Dmitry Yemanov wrote: > > 17.11.2011 11:26, Alex Peshkoff wrote: > > > >> And one more interesting line: > >> open("./fb_init", O_RDWR|O_CREAT|O_LARGEFILE, 0600) = 7 > >> Why is _SHARED_ file opened in CWD? It should go to /tmp/

Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-11-18 Thread Vlad Khorsun
>>> Before decide what to do, I'd like to hear Vlad about the error >>> isc_dsql_cte_wrong_clause, which, for example, happens if a recursive >>> query has a GROUP BY. >>> >>> Why is it not allowed? >> Because standard prohibits any kind of aggregates in recursive CTE >> members. >> > Could y

Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-11-18 Thread Adriano dos Santos Fernandes
On 18/11/2011 05:38, Vlad Khorsun wrote: >> On 16-11-2011 22:39, Frank Ingermann wrote: >>> ...but it leads to an endless loop/recursion (using latest Fb3 beta) >>> :-( >>> >> Before decide what to do, I'd like to hear Vlad about the error >> isc_dsql_cte_wrong_clause, which, for example, happens i

[Firebird-devel] [FB-Tracker] Created: (CORE-3669) It's possible to insert bigger data to table field than it's defined size.

2011-11-18 Thread JIRA
It's possible to insert bigger data to table field than it's defined size. -- Key: CORE-3669 URL: http://tracker.firebirdsql.org/browse/CORE-3669 Project: Firebird Core

[Firebird-devel] [FB-Tracker] Created: (CORE-3668) Allow at backup time possibility to order data in tables

2011-11-18 Thread Karol Bieniaszewski (JIRA)
Allow at backup time possibility to order data in tables - Key: CORE-3668 URL: http://tracker.firebirdsql.org/browse/CORE-3668 Project: Firebird Core Issue Type: New Feature

[Firebird-devel] [FB-Tracker] Created: (CORE-3667) Restore process consume memory as DefaultDbCachePages what is not acceptable

2011-11-18 Thread Karol Bieniaszewski (JIRA)
Restore process consume memory as DefaultDbCachePages what is not acceptable Key: CORE-3667 URL: http://tracker.firebirdsql.org/browse/CORE-3667 Project: Firebird Core