Re: [Firebird-devel] Boolean in wireprotocol / API

2013-08-10 Thread Mark Rotteveel
Anyone? On 8-8-2013 19:10, Mark Rotteveel wrote: I was looking at implementing boolean in Jaybird trunk (+ backport to 2.2.x), but I'd like some confirmation on how it is encoded in the XSQLVAR and in the wireprotocol. A quick skim of the sources seem to indicate that the XSQLVAR sqldata is

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-10 Thread Mark Rotteveel
On 9-8-2013 01:18, Adriano dos Santos Fernandes wrote: On 08-08-2013 13:30, Mark Rotteveel wrote: Looking in the source of intl_builtin.cpp I noticed that there is support for UTF16, UTF32 and UNICODE_UCS2, for UNICODE_UCS2 there is also a constant (=8) defined in charsets.h These

Re: [Firebird-devel] row_number window function with over()

2013-08-10 Thread liviuslivius
Hi, you do not understand me correctly i talking about query with over() not over(order by) i know that i can specify many row_number clause in one query Firebird allow this construction over(without order by) and then it should numerate records in resultset sequential Example MSSQL disallow

Re: [Firebird-devel] row_number window function with over()

2013-08-10 Thread Mark Rotteveel
On 10-8-2013 09:08, liviuslivius wrote: Hi, you do not understand me correctly i talking about query with over() not over(order by) i know that i can specify many row_number clause in one query Firebird allow this construction over(without order by) and then it should numerate records in

Re: [Firebird-devel] Changes with handling DB_KEY?

2013-08-10 Thread Mark Rotteveel
On 4-8-2013 14:39, Mark Rotteveel wrote: Has anything changed in Firebird 3.0 with the stability of RDB$DB_KEY or how RDB$DB_KEY works? Jaybird uses RDB$DB_KEY to refresh (and update) rows in updatable ResultSets, one of the tests now fails because it cannot find the row it wants to refresh

Re: [Firebird-devel] Boolean in wireprotocol / API

2013-08-10 Thread Mark Rotteveel
On 10-8-2013 08:36, Mark Rotteveel wrote: Anyone? On 8-8-2013 19:10, Mark Rotteveel wrote: I was looking at implementing boolean in Jaybird trunk (+ backport to 2.2.x), but I'd like some confirmation on how it is encoded in the XSQLVAR and in the wireprotocol. A quick skim of the sources

Re: [Firebird-devel] row_number window function with over()

2013-08-10 Thread liviuslivius
W dniu 2013-08-10 09:39:43 użytkownik Mark Rotteveel m...@lawinegevaar.nl napisał: On 10-8-2013 09:08, liviuslivius wrote: Hi, you do not understand me correctly i talking about query with over() not over(order by) i know that i can specify many row_number clause in one query

Re: [Firebird-devel] row_number window function with over()

2013-08-10 Thread Dmitry Yemanov
10.08.2013 21:20, liviuslivius пишет: and i test this also against Oracle 11g and try SELECT T.ID, row_Number() over() FROM TEST i get error the same as in MSSQL Error: ORA-30485: missing ORDER BY expression in the window specification PGSQL 9.1: postgres=# select id from test; id