Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-28 Thread Alex Peshkoff
On 11/28/11 17:03, Thomas Steinmaurer wrote: - Support for the inserting SYSDBA role trick, although I'm not sure if this is still important due to the new authentication plugin mechanism This will become not needed not due to authentication plugins, but due to mapping server logins (names we

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-28 Thread Adriano dos Santos Fernandes
On 28/11/2011 11:03, Thomas Steinmaurer wrote: - Changing the owner of database objects, which hold the owner information and everything additional needed for the conversion (e.g. SQL privileges etc ...) This doesn't appear to be a daily task that requires special support from the engine,

Re: [Firebird-devel] Created: (CORE-3672) computed index by substring function for long columns

2011-11-28 Thread Leyne, Sean
Adriano, select char_length( SUBSTRING(col1 from 1 for 20)) from tbl_test returns 20 so I was expecting index to work. workaround CREATE INDEX IDX1 ON tbl_test COMPUTED BY (CAST(SUBSTRING(col1 from 1 for 20) as varchar(20))) This issue depends if we're allowed to change

Re: [Firebird-devel] Created: (CORE-3672) computed index by substring function for long columns

2011-11-28 Thread Adriano dos Santos Fernandes
On 28/11/2011 16:22, Leyne, Sean wrote: Adriano, select char_length( SUBSTRING(col1 from 1 for 20)) from tbl_test returns 20 so I was expecting index to work. workaround CREATE INDEX IDX1 ON tbl_test COMPUTED BY (CAST(SUBSTRING(col1 from 1 for 20) as varchar(20))) This issue

Re: [Firebird-devel] The new Firebird OO API

2011-11-28 Thread Pierre Y.
g++ -Wall -I../../src/include -lfbclient -o libUdrCppExample.so -fPIC UdrCppExample.cpp ../../gen/Debug/firebird/plugins/libudr_engine.so -shared Thank you Alex for the answer. It compiled ! I don't know how to test if it works, but it compiled ;-) Next I want to compile a VERY simple piece of

Re: [Firebird-devel] The new Firebird OO API

2011-11-28 Thread Pierre Y.
Alex, I think I found the problem : -lfbclient can't find libfbclient.so I added /opt/fb3cs/lib to ldconfig.conf.d but it don't changes anything. Finally I changed the compile command to : $ LC_ALL=C g++ -Wall -I../firebird/src/include -o firetest -fPIC firetest.cpp

Re: [Firebird-devel] The new Firebird OO API

2011-11-28 Thread Alex Peshkoff
On 11/29/11 02:53, Pierre Y. wrote: Alex, I think I found the problem : -lfbclient can't find libfbclient.so I added /opt/fb3cs/lib to ldconfig.conf.d but it don't changes anything. Finally I changed the compile command to : $ LC_ALL=C g++ -Wall -I../firebird/src/include -o firetest -fPIC