On 31-03-2011 10:44, alexpeshk...@users.sourceforge.net wrote:
Revision: 52620
http://firebird.svn.sourceforge.net/firebird/?rev=52620view=rev
Author: alexpeshkoff
Date: 2011-03-31 13:44:22 + (Thu, 31 Mar 2011)
Log Message:
---
Remove reference counting where
On 01-04-2011 07:14, Alex Peshkoff wrote:
On 03/31/11 19:13, Adriano dos Santos Fernandes wrote:
On 31-03-2011 07:49, Alex Peshkoff wrote:
People would like to detach a parent and not care about statements
created but unfreed for this attachment.
If they do not call addRef for statements
On 03-04-2011 14:59, Thomas Steinmaurer wrote:
Hello,
any ideas why inserting 1 million records with a GUID primary key using
the built-in GEN_UUID() function takes WAY longer than with an integer
primary key. My finding:
I ran a VERY simple test case on Firebird 2.5 SuperClassic on a
On 04-04-2011 13:37, Kovalenko Dmitry wrote:
Hi
SQL Script
set transaction;
create table TEST_36187 (ID INTEGER);
create trigger BI_TEST_36187 for TEST_36187 before insert as declare
variable x integer; begin select count(*) from TEST_36187 into :x; end;
CREATE OR ALTER trigger
On 08-04-2011 11:25, Vlad Khorsun wrote:
08.04.2011 15:42, Vlad Khorsun wrote:
Thanks. But, if this is true : In 64 bit mode, there is only one
calling convention for each
operating system then we have no problem with interfaces despite of
compiler\language
on x64 systems.
Yep, if
On 08-04-2011 01:45, Dmitry Yemanov wrote:
08.04.2011 5:57, Adriano dos Santos Fernandes wrote:
I do have some raw ideas to make batching on the message and request
API, changing fetch to not return 100/101 but count of messages, and
make possible to use input messages where is truly many
All,
Our functions dealing with XSQLDA/XSQLVAR has a dialect parameter.
When dialect is 0, the structures are interpreted as SQLDA/SQLVAR. These
structs are a legacy version with less items.
They declarations are not present in ibase.h at least since 2.0.
I want to remove them. Objections?
On 11-04-2011 04:19, Alex Peshkoff wrote:
On 04/09/11 19:44, Adriano dos Santos Fernandes wrote:
On 09-04-2011 08:58, Vlad Khorsun wrote:
On 08-04-2011 13:43, alexpeshk...@users.sourceforge.net wrote:
Revision: 52693
http://firebird.svn.sourceforge.net/firebird/?rev=52693view=rev
On 11-04-2011 12:09, Dmitry Yemanov wrote:
11.04.2011 18:04, Alex Peshkoff wrote:
Telling true, inability to extend XSQLDA in backward compatible
way was always obvious for everyone here.
Only partially true. It's designed to be backward compatible and I don't
see why it cannot work. The
On 12-04-2011 06:02, marius adrian popa wrote:
ps:we really need a really good c++ for flamerobin and other c++
toolkits :qt/wx
How can i test the new api ? there is some doc or samples somewhere ?
I'll soon publish some tests at https://github.com/asfernandes/fbstuff.
Adriano
Hi!
It's allowed to use XSQLVAR (or blr messages) between different types
like number-varchar (or vice-versa) but it's not allowed to use
different types when one of them is a blob.
DSQL moves data using MOVD_move, which do it like a client move. This
was ok before, cause DSQL was not part of
On 27/04/2011 19:28, Support List wrote:
I am doing a new major release of IB Objects soon and I want to get
confirmation of some things before I finalize it.
I have some scenarios that I would like to know what to do about.
There are a total of 9 possible combinations of 3 aspects.
Aspect
On 28/04/2011 10:22, Leonardo M. Ramé wrote:
Hi, I installed FB 2.5 on FreeBSD 8.2 AMD64, and found that fb_smp_server
doesn't start because of the libraries libicu* requiered are version 38 and
the server has installed version 46.
This is what I get when starting fb_smp_server:
On 29/04/2011 04:11, Geoff Worboys wrote:
As far as I can tell it is still required to use
isc_dsql_execute_immediate to perform a CREATE DATABASE (if
I've missed any relevant API change in the release notes please
forgive me, I did look).
Could also be done with isc_create_database.
So
On 29/04/2011 09:00, Geoff Worboys wrote:
Adriano dos Santos Fernandes wrote:
Could also be done with isc_create_database.
The IB6 API documentation notes this as:
The isc_create_database( ) method is not currently supported
from user applications. It is for internal use only. Use
On 16/05/2011 14:12, Vlad Khorsun wrote:
On 16/05/2011 13:33, Vlad Khorsun wrote:
So, if code calls attach\release - this is bug, as for me, and i see
no reasons
to write code in this way intentionally. I consider at as very bad practice
as it
could lead to the inexpected side effects (such
On 17/05/2011 08:27, Vlad Khorsun wrote:
What about the following - we always pass status vector to release().
I'm sorry but i against it. addRef\release is and well known pair and its
usage also well known. I see no good reason to change it. More, if we
need to change it, then we use it
On 17/05/2011 04:05, Alex Peshkoff wrote:
In FB2.5 yValve did not need any more MT-safeness except provided by
atomic counters and some helper locks like hanlers' map RwLock.
Initially I've planned to keep same approach for FB3. But I did not
review latest Adriano's changes from this POV.
I
On 17-05-2011 19:58, Vlad Khorsun wrote:
PS: There is a paper
(http://www.aristeia.com/Papers/DDJ_Jul_Aug_2004_revised.pdf) from Scott
Meyers and Andrei Alexandrescu showing even or volatile usage in base
classes are wrong. Unfortunately it's down.
With MSVC we are safe as we use
On 24/05/2011 07:46, Alex Peshkoff wrote:
On 05/23/11 16:27, Adriano dos Santos Fernandes wrote:
On 23/05/2011 09:21, Alex Peshkoff wrote:
Yes of cause.
I agree with all this words - but mentioned cache will anyway remain
always empty in fbclient of FB3.
And I do not say it must
On 17/06/2011 13:30, Dimitry Sibiryakov wrote:
17.06.2011 18:19, Adriano dos Santos Fernandes wrote:
FB_MESSAGE(Message,
(FB_SMALLINT, smallInt0)
(FB_INTEGER, integer0)
(FB_BIGINT, bigInt0)
(FB_SCALED_BIGINT(3), bigInt3
On 17/06/2011 13:30, Dimitry Sibiryakov wrote:
With GPRE you don't even need to care about types, it will get it
automatically from
DB, so - what's the point to change one preprocessor for another?
Let me also say something which may be not clear.
These messages struct/blr could be
On 27/07/2011 08:40, Alex Peshkoff wrote:
On 07/27/11 15:11, Tony Whyman wrote:
6. Just in time compilation of the embedded procedure on first use
(after create/alter) into a shared library/DLL which is then effectively
a dynamically generated UDF library. A JIT approach is important because
On 27/07/2011 10:00, Jim wrote:
Of course, an alternative, as Alex Peshkoff mentioned:
If we vote for speed, the best choice will be use of precompiled
libraries - like with UDFs.
And like UDFs we leave it to sysadmin - not DBA.
... we could just trust sysadmins to only upload proper code -
On 27/07/2011 10:08, Dimitry Sibiryakov wrote:
27.07.2011 15:05, Alex Peshkoff wrote:
BTW, how is it solved in Java?
There is no pointers in Java, AFAIK.
Sure. The language don't allow such malicious things.
And the Java plugin security works like a Java applet running in your
browser.
On 27/07/2011 10:57, Roman Rokytskyy wrote:
And the Java plugin security works like a Java applet running in your
browser.
It's by default configured to allows nothing that can danger the
machine.
But say you need to access the network, you put a record in the java
security database saying
On 27/07/2011 10:43, Sergey Mereutsa wrote:
Hello Adriano,
AdSF Sure. The language don't allow such malicious things.
Yes, but JVM is written by humans, and errare humanum est ;-)
As long there is no current serious public know vulnerability in a
years-old technology, I'd say it's secure.
On 27/07/2011 11:16, Roman Rokytskyy wrote:
Oh, so you have implemented a proper security manager for the Java
ESPs? You are great man! :)
It was difficult and initially was failing only in Linux. But after
changes it worked ok as far as I can test.
Will it accept also a default security
On 28-08-2011 11:51, Dimitry Sibiryakov wrote:
28.08.2011 15:52, Alex Peshkoff wrote:
Certainly, we can make API look like we_do_ join a new attachment to an
existing distributed transaction. To do so we just start new transaction
in API call internally (need to know TPB...) and join it with
All,
After I bought a new machine, I reinstalled Ubuntu in new HDD with ext4
filesystem.
While the new machine has much better CPU than the old one, I noticed
the build being very slow where Firebird was creating databases.
I found that mounting the ext4 partition with barrier=0 parameter
On 29/08/2011 06:27, Paul Reeves wrote:
On Monday 29 August 2011 at 11:05 marius adrian popa wrote:
you are not the only one that observed db/vm performance issues with ext4
maybe you need to mount it with data=writeback
On 29/08/2011 06:05, marius adrian popa wrote:
On Mon, Aug 29, 2011 at 1:14 AM, Adriano dos Santos Fernandes
adrian...@gmail.com wrote:
All,
After I bought a new machine, I reinstalled Ubuntu in new HDD with ext4
filesystem.
While the new machine has much better CPU than the old one, I
On 29/08/2011 10:13, Paul Reeves wrote:
On Monday 29 August 2011 at 14:25 Michael Weissenbacher wrote:
But if barriers are needed just to make journal commits safe on the disk
with write cache turned on this seems to be not directly related with
firebird databases - write cache ON will anyway
On 29/08/2011 10:24, Paul Reeves wrote:
On Monday 29 August 2011 at 13:35 Alexander Peshkov wrote:
Tested CREATE DATABASE on my old box. To avoid disk fragmentation
effects database was always created on new shining partition.
I've found different results doing a large db restore. ext4 came
On 30-08-2011 18:27, Fulvio Senore wrote:
Now I have installed Ubuntu 10.04 LTS 64 bit in my laptop, formatting
the disk partitions with the ext4 file system.
When I use the same program to open my catalog, it takes about 23
seconds. That is in incredibly long time and I really cannot
On 19/09/2011 06:48, Jiri Cincura wrote:
On Mon, Sep 19, 2011 at 10:39 AM, Alex Peshkoffpeshk...@mail.ru wrote:
; this is how the data are
pumped into the method (so it can be further pumped by plugin into
method); this is how you can return value/resultset; etc.
Here I do not understand
On 10/10/2011 06:48, Vlad Khorsun wrote:
Seems conditional triggers have sence only for external (non-PSQL)
triggers.
Moreover, only when the call is cost (like Java, but not for C++).
Adriano
--
All the data
On 10/10/2011 07:43, Dimitry Sibiryakov wrote:
10.10.2011 12:36, Adriano dos Santos Fernandes wrote:
Wrong reason, as Oracle doesn't support external triggers.
Oracle SQL Reference for version 10 has other opinion:
-- quote ---
CREATE TRIGGER
On 25/10/2011 07:56, Paul Reeves wrote:
On Tuesday 25 October 2011 at 11:12 marius adrian popa wrote:
In other words: if you use Ext3 and you note performance regressions
with this release, try disabling barriers (barriers=0 mount option).
I can understand doing this for routine desktop work.
On 14-11-2011 05:31, Vlad Khorsun wrote:
My doubt is that we will write more pages than necessary. Imagine small
cache (CS)
and set of actively modifying pages. Currently we will write them one-by-one
when new
buffer is required. You offer to write, say, 2 pages at time and replace
On 14-11-2011 04:54, Alex Peshkoff wrote:
So, it's just a fact of allow it with the new API. And then there must
be a way to libraries uses bits of the new API mixed with old one.
May be I do not understand what you mean here... Why mix?
Because then previously written application would
On 14-11-2011 20:09, Vlad Khorsun wrote:
Hello,
I have the following character set (ISO88591) information in the trace
output:
2011-10-27T20:58:16.5210 (920:00D4DA30) COMMIT_TRANSACTION
fbtm_unittest.fdb (ATT_2, FBTM:NONE, ISO88591, TCPv4:127.0.0.1)
On 17/11/2011 09:19, Alex Peshkoff wrote:
On 11/17/11 14:14, Adriano dos Santos Fernandes wrote:
On 17/11/2011 07:52, Dmitry Yemanov wrote:
The only way to guarantee ordered writes is to flush individual pages
and this is what FW=ON does.
Or to flush group of independent pages at once, like
On 21/11/2011 16:45, Frank Ingermann wrote:
Hi,
Am 19.11.2011 01:04, schrieb Vlad Khorsun:
Because standard prohibits any kind of aggregates in recursive CTE
members.
So this would mean option b) is correct:
b) [ ] window functions are not supposed to work in the child select
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,
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
On 29-11-2011 18:28, Claudio Valderrama C. wrote:
-Original Message-
From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com]
Sent: Martes, 29 de Noviembre de 2011 6:41
I believe it's better to have a system package with functions
able to do
that, instead of continue
On 29-11-2011 05:56, Dmitry Yemanov wrote:
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
On 30/11/2011 14:52, Björn Reimer wrote:
The discussion about removing sources or not makes little sense for
me. It is possible with fb 2.5 and prior and should be possible in
future versions as this feature is used. If you don't like it don't
use it.
I wonder if these people who is
On 30/11/2011 16:05, Carlos H. Cantu wrote:
AdSF With BLR + debug_info it's very possible (and easy) to reconstruct
AdSF sources. And better, you don't even need to read the sources in the
AdSF original format style, but in the style you you want it!
Probably not,
So as I suppose.
but
On 16-11-2011 22:39, Frank Ingermann wrote:
Hi all,
i'm trying to combine the new Window functions in Fb3 with
recursive CTEs to get a _defined_ ordering of the recursive
child records in the result set.
The recursive problem is fixed, in fact it was a problem of window
functions with
On 02/12/2011 05:26, Pierre Y. wrote:
Hi,
I advanced a bit more with this new API but I just absolutely don't
see how to deal with FbMessage. What is it ? How do I have to use it
to access (or send ?) data ?
On 04-12-2011 13:17, Jesus Garcia wrote:
The engine does what is possible and tries to catch the 'alien exception'.
You must do your part and write a correct UDF, testing them before in
non-production environment.
Adriano
I know it, and is not me, is firebird. I try To test everything,
On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote:
On 16-11-2011 22:39, Frank Ingermann wrote:
Hi all,
i'm trying to combine the new Window functions in Fb3 with
recursive CTEs to get a _defined_ ordering of the recursive
child records in the result set.
The recursive problem
On 07/12/2011 07:31, Alex Peshkoff wrote:
On 12/05/11 04:23, Geoff Worboys wrote:
So the power example would become:
declare external function dPower
double precision by descriptor, double precision by descriptor,
double precision by descriptor, integer by descriptor
returns parameter 3
On 09/12/2011 16:34, Vlad Khorsun wrote:
CORE-3073 [1] requires special BLR verb meaning get the default value
of a field. There is request to expose the same functionality in SQL
too, but doesn't matter here.
These cascade triggers are system triggers but are backed-up and
restored. If we
On 09/12/2011 16:50, Vlad Khorsun wrote:
On 09/12/2011 16:34, Vlad Khorsun wrote:
CORE-3073 [1] requires special BLR verb meaning get the default value
of a field. There is request to expose the same functionality in SQL
too, but doesn't matter here.
These cascade triggers are system
On 12/12/2011 11:34, Alex Peshkoff wrote:
On 12/12/11 15:43, Pierre Y. wrote:
Hi All,
Thanks to Vlad, we achieved the translation of the FB3 OO API in UIB
Components for Delphi.
You can checkout the code from SourceForge repository :
https://uib.svn.sourceforge.net/svnroot/uib/trunk
All,
CORE-3238 is the problem related to UUIDs version and reserved bytes
which we're not respecting.
Note that in Windows, we generate UUIDs with a WinAPI function so it
generates correct numbers, but in POSIX we just generate random data.
1) So from a POV, we may say our GEN_UUID is correct
On 15/12/2011 15:04, Leyne, Sean wrote:
Adriano,
CORE-3238 is the problem related to UUIDs version and reserved bytes which
we're not respecting.
Note that in Windows, we generate UUIDs with a WinAPI function so it
generates correct numbers, but in POSIX we just generate random data.
1)
On 15/12/2011 16:46, Leyne, Sean wrote:
Note that in Windows, we generate UUIDs with a WinAPI function so it
generates correct numbers, but in POSIX we just generate random data.
For Windows users this binary representation is also wrong now, cause
reserved bits is not documented in it.
You
On 15-12-2011 18:11, Vlad Khorsun wrote:
As I said before, ext4 performance with FW=ON is much slower than ext3,
but I now found something new.
I've verified that with FB 2.5, TCS times was ok (0s - 3s), and only
with FB 3 they are very bad (first test takes 16s, then 12s, 8s, 7s, 7s,
etc)
On 16/12/2011 05:24, Vlad Khorsun wrote:
So now we're spending time while the database is not even completely
created.
While we can restore previous behavior (put FW ON flag at header page
when database is created but create db file with this flag switched off) i
prefer
to ask - are we
On 16/12/2011 06:08, Mark Rotteveel wrote:
On Thu, 15 Dec 2011 15:14:20 -0200, Adriano dos Santos Fernandes
adrian...@gmail.com wrote:
There is no UUID binary representation in the RFC. There it's just a
formated string.
Yes there is a binary representation defined in
http://www.ietf.org
On 20/12/2011 06:57, Alex Peshkoff wrote:
connect: client's public key, login and database name = server
accept: server's public key and salt = client
attach: client's proof = server
response: success if client's proof == server's proof
What I would like to know is that if there is a way
On 20/12/2011 08:19, Alex Peshkoff wrote:
On 12/20/11 13:54, Adriano dos Santos Fernandes wrote:
On 20/12/2011 06:57, Alex Peshkoff wrote:
connect: client's public key, login and database name = server
accept: server's public key and salt = client
attach: client's proof = server
On 20/12/2011 11:20, Alex Peshkoff wrote:
I wonder is it possible to change windows installer to initialize
security database. Next, for ZIP install people will have to run gsec
first time manually. Are this changes OK for us?
I don't think it is, specially for zip.
I think bind the server
On 20/12/2011 11:41, Alex Peshkoff wrote:
On 12/20/11 17:26, Adriano dos Santos Fernandes wrote:
On 20/12/2011 11:20, Alex Peshkoff wrote:
I wonder is it possible to change windows installer to initialize
security database. Next, for ZIP install people will have to run gsec
first time
On 01-01-2012 15:11, Jesús García wrote:
I think the question is if it is neccesary and good for Firebird, and if the
pros of having transactions id of 64bits are better that the cons of not
having it. From my POV using 32 bits id is an important restriction in the
engine, and i would
Firebird needs what is called definers right in Oracle (as opposed to
our invokers rights).
External routines should work like internals one. What matters is the
routine declaration, definers/invokers rights.
Adriano
On 03/01/2012 10:30, Dimitry Sibiryakov wrote:
03.01.2012 13:25, Adriano dos Santos Fernandes wrote:
Firebird needs what is called definers right in Oracle (as opposed to
our invokers rights).
But not for UDR. External libraries can be substituted/hacked. Giving
them all
definer's
Just throwing another thing: Isn't some form of journaling expected to
appear in Firebird, as I've heard in the past?
If yes, the journal could be used to consolidade old transaction in one
and implement the thing about adjusting the transaction number and
making it overlap as I said
On 23-01-2012 06:57, Claudio Valderrama C. wrote:
Adriano, I get a warning about non-standard extension: nameless struct or
union.
struct Guid
{
enum Style
{
STYLE_NBACKUP, // Format introduced with nbackup
STYLE_BROKEN, // Format introduced in
On 20-01-2012 08:02, Claudio Valderrama C. wrote:
-Original Message-
From: Frank Schlottmann-Gödde [mailto:fr...@schlottmann-goedde.de]
Sent: Jueves, 19 de Enero de 2012 12:35
Thank you, I had the impression that all qli-switches where one letter
switches, but I'm happy with -nod.
On 23-01-2012 20:25, Adriano dos Santos Fernandes wrote:
On 23-01-2012 19:55, Claudio Valderrama C. wrote:
But now TCS (and all others programs calling QLI like it) don't work:
- qli: ignoring unknown switch -n
v2.5 or v3?
I tried only v3.
Actually, a test had this different outputs
On 28-01-2012 00:50, Claudio Valderrama C. wrote:
-Original Message-
From: Mark Rotteveel (JIRA) [mailto:trac...@firebirdsql.org]
Sent: Viernes, 27 de Enero de 2012 13:45
RDB$UNIQUE_FLAG is 1 for a unique index, but NULL for
non-unique (I would expect 0)
RDB$INDEX_INACTIVE is NULL
On 01-02-2012 09:35, Norman Dunbar wrote:
PS. One day I'll finish decoding the internals and finish the manual!
Thanks for reading so far.
You're manual is very great. I'm able to read (kind of) table data based
only on it (didn't even looked at FB sources).
Adriano
On 01-02-2012 12:46, Dmitry Yemanov wrote:
31.01.2012 2:12, Adriano dos Santos Fernandes wrote:
There is two obscure SQL commands called READ BLOB and WRITE BLOB.
The idea behind these commands is to make blob read/write using the
cursor (fetch/insert) API. Why they exist is not something I
On 02-02-2012 08:34, Alex Peshkoff wrote:
Looks like that when introducing cursors people wanted to follow some
standard that existed that time. But from today POV this commands look
useless and should better be removed - specially if they cause problems
with engine stability. But probably
On 13-02-2012 13:33, Dmitry Yemanov wrote:
* For all datatypes other than SQL_VARYING, it is first storing
byteArray size and then overwriting that with the byteArray, so actually
storing that size first is unnecessary, right?
I'm not sure I understand you here.
* Is 0x20 (space) the
On 23/02/2012 10:50, Nick Upson wrote:
Hi,
before putting this idea into the trackers I wanted to make sure its
not totally crazy.
When gbak finishes the actual data part of the restore it then creates
all the indexes, could it do that in parallel based on the number of
processors
It was me who added these sed usages to makefiles, to let build work
after header files removal.
Some time later, I discovered gcc -MP:
-
This option instructs CPP to add a phony target for each dependency
other than the main file, causing each to depend on nothing. These dummy
On 01/03/2012 12:29, Dimitry Sibiryakov wrote:
Because password encryption method is going to be changed in 3.0, isn't
it too late to
suggest to convert password into UTF-8 before encryption?
Imagine two user environments on Linux, one has locale win1251 and
another utf-8.
On 01/03/2012 13:26, Dimitry Sibiryakov wrote:
01.03.2012 17:17, Adriano dos Santos Fernandes wrote:
I understand a problem, but please talk about the solution you're
proposing. What is the moment(s) a password should be converted, and
from what to UTF8?
Sorry, but I don't have a solution
On 06/03/2012 07:14, Claudio Valderrama C. wrote:
-Original Message-
From: Kjell Rilbe [mailto:kjell.ri...@datadia.se]
Sent: Martes, 06 de Marzo de 2012 6:55
Isn't it about time to drop support for dialect 1?
Yes. But I'm sure there will be objections. I'd say the world moves
forward
On 06/03/2012 06:55, Kjell Rilbe wrote:
Meaning: if you really want to stay at dialect 1, then fine with me, but
then live with the implications, e.g. staying with an old version of FB.
Completely agreed.
Adriano
On 06/03/2012 16:01, Leyne, Sean wrote:
This is why BroadView hasn't made the move from Dialect 1. The numeric rules
imposed by Dialect 3 would have required a huge amount of re-coding and
testing to ensure that our calculations/reports generated the expected
results.
BTW, unless I have
On 06/03/2012 16:37, Dimitry Sibiryakov wrote:
06.03.2012 20:31, Adriano dos Santos Fernandes wrote:
So, add a new datatype NUMBER(x, y) who does BCD arithmetics like it's
done in Oracle.
What this data type will change? What will be result of 1/3 for this data
type? If 0,
it won't
On 10-03-2012 11:05, Dmitry Yemanov wrote:
Elegant, but for this task, I just can test the original condition in the
second place and avoid a flag that doesn't have presence in any other place
of the code. I mean,
if (in_msg_type != MAX_USHORT)
{
request-execute(...);
}
What am I
On 07-04-2012 12:02, Dimitry Sibiryakov wrote:
Hello, All.
How in external DDL trigger get context variables, such as OBJECT_NAME and
SQL_TEXT?
From the const IRoutineMetadata* metadata parameter of makeTrigger...
But note, triggers wasn't adapted for the new scheme of messages
On 07-04-2012 12:29, Dimitry Sibiryakov wrote:
07.04.2012 17:23, Adriano dos Santos Fernandes wrote:
From the const IRoutineMetadata* metadata parameter of makeTrigger...
Could you be a little more specific?.. I don't see in IRoutineMetadata
anything like
getContextVariable
On 07-04-2012 16:14, Dimitry Sibiryakov wrote:
07.04.2012 21:12, Dmitry Yemanov wrote:
Perhaps it would be a better idea to write a SQL trigger calling the
external procedure and passing the required context through.
It is loosing whole point of external triggers. The same way an ordinary
On 07-04-2012 18:03, Dimitry Sibiryakov wrote:
07.04.2012 22:44, Adriano dos Santos Fernandes wrote:
You can have a single external trigger able to read all table columns.
And, BTW, no: I can't read BLOBs and arrays with current interface.
Why not?
You must be able to receive the blob
On 07-04-2012 18:50, Adriano dos Santos Fernandes wrote:
On 07-04-2012 18:39, Dimitry Sibiryakov wrote:
07.04.2012 23:35, Adriano dos Santos Fernandes wrote:
Yep, I see BLOB function in IAttachment, but where are array
functions?
There too... getSlice, setSlice...
What is function
On 07-04-2012 18:54, Dimitry Sibiryakov wrote:
07.04.2012 23:50, Adriano dos Santos Fernandes wrote:
This function is a client-function that does its works running other
functions.
This function is not part of the provider API, and currently don't work
with new API objects.
So, how can
The BTYACC %type(s) has been a PITA to maintain. You have to switch
between file places which makes things very sad to maintain.
I propose this syntax change using small sed script (attached with some
examples)
Then each type will be directly set on the rule.
So instead of:
%type int32Val
On 12/04/2012 08:36, Dmitry Yemanov wrote:
12.04.2012 14:50, Alex Peshkoff wrote:
I do not like use of sed script for that.
Me neither. And IIRC, it's not required for Windows builds now, unless
you build the installer.
It's also used in make_all.bat to generate ibase.h.
If we anyway
On 12/04/2012 14:46, Dmitry Yemanov wrote:
12.04.2012 18:44, Adriano dos Santos Fernandes wrote:
It's also used in make_all.bat to generate ibase.h.
OK, this makes it less of a problem.
Let's say it turns out to be a bad idea... We will loose nothing. We'd
then regenerate it and commit
On 18/04/2012 14:12, Mark Rotteveel wrote:
I was just looking at an old ticket for Jaybird (JDBC-94) which is
actually caused by a bug / deficiency in Firebird (see CORE-2697). This
was fixed for Firebird 3.0 in 2009.
I was wondering if this fix can also be backported to Firebird 2.5?
Looks
It's a duplicate problem of CORE-3611.
I commented in that ticket: I'm fixing this only in 3.0 cause I'm not
very sure of unintended regressions.
Anyone could review the fix?
Patch for 2.5 is attached.
Adriano
diff --git a/src/dsql/pass1.cpp b/src/dsql/pass1.cpp
index fa6d6eb..c948c1d
1 - 100 of 1691 matches
Mail list logo