28.11.2011 23:08, Adriano dos Santos Fernandes wrote:
> No. It happens with large varchar column. So it turns back to my
> question: can we describe a column with a length we know will fit and
> will have no side effects other than just being described different?
I believe we can and we should. W
On 11/29/11 04:42, Claudio Valderrama C. wrote:
>> -Original Message-
>> From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com]
>> Sent: Lunes, 28 de Noviembre de 2011 16:08
>> No. It happens with large varchar column. So it turns back to my
>> question: can we describe a column
On 11/28/11 23:51, Helen Borrie wrote:
> At 02:03 AM 29/11/2011, Thomas Steinmaurer wrote:
>> Hello,
>>
>> Dmitry presented at the conference some things (AFAIK e.g. changing NULL
>> to NOT NULL and vice versa) in Firebird 3, which replaces the need for
>> directly updating the system tables, as
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 firetes
> -Original Message-
> From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com]
> Sent: Lunes, 28 de Noviembre de 2011 16:08
> >
> No. It happens with large varchar column. So it turns back to my
> question: can we describe a column with a length we know will fit and
> will have n
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 /opt/fb3cs/lib/libfbclient.so
Adriano,
> On 28/11/2011 17:03, Leyne, Sean wrote:
> > Adriano,
> >
> >>> By "type" does the standard mean the basic data type as well as the
> >> length?
> >> I mean the "max length". It always returns blob for blobs and varchar
> >> for others types.
> > Then it seems that the reported case must
> 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 o
At 02:03 AM 29/11/2011, Thomas Steinmaurer wrote:
>Hello,
>
>Dmitry presented at the conference some things (AFAIK e.g. changing NULL
>to NOT NULL and vice versa) in Firebird 3, which replaces the need for
>directly updating the system tables, as this might be disallowed in FB 3
>anyway. He aske
On 28/11/2011 17:03, Leyne, Sean wrote:
> Adriano,
>
>>> By "type" does the standard mean the basic data type as well as the
>> length?
>> I mean the "max length". It always returns blob for blobs and varchar for
>> others types.
> Then it seems that the reported case must be about a blob column, s
Adriano,
> > By "type" does the standard mean the basic data type as well as the
> length?
> >
> I mean the "max length". It always returns blob for blobs and varchar for
> others types.
Then it seems that the reported case must be about a blob column, since a
substring on a char or varchar colu
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))
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 allow
On 22/11/2011 11:50, Lukas Masak (JIRA) wrote:
> computed index by substring function for long columns
> -
>
> Key: CORE-3672
> URL: http://tracker.firebirdsql.org/browse/CORE-3672
> Project: Fireb
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 engi
Stop utilities to export entrypoints
Key: CORE-3677
URL: http://tracker.firebirdsql.org/browse/CORE-3677
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.1, 2.1.4, 2.0.6, 3.0 Initial
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 w
Hello,
Dmitry presented at the conference some things (AFAIK e.g. changing NULL
to NOT NULL and vice versa) in Firebird 3, which replaces the need for
directly updating the system tables, as this might be disallowed in FB 3
anyway. He asked for additional use cases, which currently need direct
On 11/28/11 04:01, Pierre Y. wrote:
> Hi all,
>
> If I understood well the conference about Providers, Plugins and new OO API
> from Alex this week-end at the Firebird Conference, all we have to do to
> enter the new OO API is to find the new fb_get_master_interface method and
> play with the new
19 matches
Mail list logo
