10.08.2014 13:48, Dimitry Sibiryakov wrote:
It is an open project, no?..
It is. But open unmanaged.
When C API missed a new feature that I could use, I created a patch,
submitted it to
the project and
it may be either accepted or rejected. Because you may disappear
tomorrow but the
10.08.2014 13:55, Reinier Olislagers wrote:
However, apparently FB devs don't think it's important to keep it in
sync with the C++ interface - even if third parties could submit patches
for that.
So in effect, new FB (features) will not be compatible with any language
that does not have C++
10.08.2014 14:09, Dimitry Sibiryakov wrote:
Whole project is inherited, remember?.. You have to maintain code written by
Jim, Mike,
Arno, Nikolay and others, so why not mine?..
Everything depends on the patch. There's a difference between *can* be
accepted and *will* be accepted. If you
10.08.2014 14:10, Jim Starkey wrote:
It is a fool's errand to try to build a OO interface that is call compatible
across a wide range of OO languages. If anyone is in doubt, look at
Objective-C and weep.
If this is found being impossible (I'm not deeply involved, so I don't
have a
10.08.2014 19:45, Dimitry Sibiryakov wrote:
When will you start to separate application API and plugin API?..
UDRs must use a regular application API for callbacks into the engine,
this is a design requirement.
Dmitry
11.08.2014 13:45, Mark Rotteveel wrote:
To illustrate: you seem (?) to be speaking from the perspective of a
target audience who use the interface in application development, and where
you don't want to deal with all the nitty gritty low-level details, here
IBPP is probably a good fit (but as
11.08.2014 18:18, Jim Starkey wrote:
Since plugins pretty much need to be compiled with the same compiler as the
engine
Very questionable requirement. I can easily expect plugins written in
Delphi.
Dmitry
--
11.08.2014 22:08, Adriano dos Santos Fernandes wrote:
But an (client) application wants to generate exception when accessing
the API, and we do not know in advance what's the good classes for each
project.
And we'll never know. This is not our business, IMO.
Some may use like Firebird, an
12.08.2014 18:03, Mark Rotteveel wrote:
Doesn't this miss a add specific standard (or vendor-specific) SQL state
somewhere?
It's hidden inside item (3) ;-)
Dmitry
--
Firebird-Devel mailing list, web interface at
22.08.2014 18:54, Mark Rotteveel wrote:
Are there any objections if I try to come up with a patch to add OFFSET
and FETCH to the select syntax (CORE-4526)?
Feel free.
Dmitry
--
Slashdot TV.
Video for Nerds.
26.08.2014 00:29, Nikolay Samofatov wrote:
When you converted transaction number from SLONG to TraNumber (ULONG) you
didn't take into account
that LCK_query_data returns SLONG and uses signed integers internally.
While there might be different solutions to this particular problem, I'm
26.08.2014 21:52, Jim Starkey wrote:
As the original author of SLONG, ULONG, et al, might I suggest that you ditch
them all in favor of the standard and size explicit int64_t, int32_t, etc.?
When it was discussed the last time, some compilers (was it some ancient
MSVC version?) didn't
31.08.2014 22:11, Dimitry Sibiryakov wrote:
To secure it from examining by users, no?..
This is the last reason for such a move.
Dmitry
--
Slashdot TV.
Video for Nerds. Stuff that matters.
31.08.2014 15:51, Carlos H. Cantu wrote:
We have a hack that many people uses for a long time, to make it
more difficult to stole procedures/triggers source (more difficult,
not impossible, since BLR can be decoded to source). They know it is
not 100% safe, but so far it is the only way to
01.09.2014 11:24, Alex Peshkoff wrote:
That's nice - but what should happen with that special syntax when BLR
follows DYN?
Easy option - deprecate the command.
A more clever one - not DROP (nullify) the source but set some flag to
HIDE it instead. That flag would mean returning NULL instead
01.09.2014 19:58, Jim Starkey wrote:
Anybody see any problems with it?
I like neither DPB solution because it's DPB. It's not a connection
string option, it's an API option. Surely not a problem for ISQL users
that will support it out of the box. But most of existing user
applications need
01.09.2014 23:28, Dimitry Sibiryakov wrote:
But it requires a quite complex condition, no? Not just if relation is
system one,
throw exception, but if relation is system one, but not this and that,
throw exception.
Complex condition is: relation is X and no other field but rdb$source is
01.09.2014 23:35, Dmitry Yemanov wrote:
Complex condition is: relation is X and no other field but rdb$source is
modified
and the new value is NULL, of course.
Dmitry
--
Slashdot TV.
Video for Nerds. Stuff
02.09.2014 00:22, James Starkey wrote:
What possible user applications are going to be doing procedure and
trigger definitions that require the source be omitted?
Whatever user application that works with the database and executes
metadata upgrade scripts itself, without invoking ISQL.
And
02.09.2014 00:59, Dimitry Sibiryakov wrote:
Complex condition is: relation is X and no other field but rdb$source is
modified. We already have function in VIO doing such a check for other
purposes.
You are not going to simplify code, are you?..
Neither of the solutions being discussed
02.09.2014 19:05, Dimitry Sibiryakov wrote:
if (some condition
some other condition)
hardly recognized line that doing something;
This example violates the project coding style.
Dmitry
02.09.2014 18:35, Dimitry Sibiryakov wrote:
When was decided that one-line blocks must not be enclosed with parentheses?
It didn't change for the past few years:
http://www.firebirdsql.org/en/coding-style/
http://geosoft.no/development/cppstyle.html
82. Single statement if-else, for or while
02.09.2014 21:27, Dimitry Sibiryakov wrote:
if (temp.rpb_flags rpb_delta)
temp.rpb_prior = data;
doesn't look much better.
Let me disagree.
Dmitry
--
Slashdot TV.
Video for Nerds. Stuff that
02.09.2014 23:10, Gabor Boros wrote:
Available snapshots date is august 27. Is it a known issue?
Yes, Windows builds are broken.
Dmitry
--
Slashdot TV.
Video for Nerds. Stuff that matters.
04.09.2014 19:25, Tom Coleman wrote:
Speaking of the v3.0 release, who updates 3.0 Beta 1 release dates?
Me.
August 31 has come and gone:
I know.
Are there really just 5 unresolved issues delaying the beta release?
Yes, around that number.
Dmitry
Nickolay,
I implemented intermediate versions GC algorithm and tried to run some stress
tests on Firebird 3 to
check if I have broken something.
The problem is that tests that I created were spending most of their time in
memory manager. This is
not healthy.
Out of curiosity, what is the
24.09.2014 19:33, Tom Coleman wrote:
We're almost in October and the FB3 beta release date still shows as
August 31.
SMB 3, memory management, etc., etc - all very interesting discussions
but how are they leading to the highly-anticipated and much needed beta
release?
Beta release is
24.09.2014 19:39, Dmitry Yemanov wrote:
Beta release is expected the next week.
Correction: Beta *code* is expected to be ready (i.e. tagged) the next
week. The release itself will appear slightly later, after composing the
docs and passing QA.
Dmitry
26.09.2014 19:13, Leyne, Sean wrote:
Localhost is not necessary for Classic and SuperClassic engine (I not sure of
SuperServer, we don't use this mode), since local mode connections are
supported
XNET is not an option for Jaybird or .NET users.
since the long-term path for Firebird is the
26.09.2014 20:11, Leyne, Sean wrote:
If v3 has the SMP improvements which are planned, why would we continue to
support 3 engine versions?
Classic and SuperClassic would have functionality which covers all use cases.
v3 has the SMP improvements in *SuperServer*.
Dmitry
02.10.2014 22:21, Roman Simakov wrote:
Sorry for some kind of offtopic. What does it mean the last number in
version? Is it synthetic build number?
Yes, it's auto-generated.
How can I understand what revision number was used to build it?
Search by the build number in fb-checkins. Note that
02.10.2014 20:18, Frank Schlottmann-Gödde wrote:
I'm getting
gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
gbak: ERROR:object has non-SQL security class defined
gbak:Exiting before completion due to errors
when trying to restore a backup created by
version
03.10.2014 10:31, Martijn Tonies wrote:
I noticed that with Classic 2.5, you can get “object in use” when trying
to modify a
stored procedure that’s been previously executed, see also:
http://tracker.firebirdsql.org/browse/CORE-4016
When using “wait” on the transaction to save the procedure,
03.10.2014 19:47, Adriano dos Santos Fernandes wrote:
https://github.com/asfernandes/fbstuff/blob/master/src/test/v3api/StaticMessageTest.cpp
Note the line
string(output-description.str,output-description.length) for the
SALES relation, which don't have a comment.
Current (without a test
03.10.2014 21:03, Martijn Tonies (Upscene Productions) wrote:
You purposefully want to break existing applications because the Firebird
client returns the data of the previous record.
You don't get what's really happening. Firebird API (read: fbclient)
represents every field with two parts:
03.10.2014 21:20, Martijn Tonies (Upscene Productions) wrote:
I get exactly what's happening.
And it's clear to me -something- has changed in this regard, cause if it
weren't, everything would be just fine.
Then tell us how a properly written application (the one not ignoring
the NULL
03.10.2014 21:37, Martijn Tonies (Upscene Productions) wrote:
I never said a properly written application could be affected, I said
something
has clearly changed as existing applications suddenly return the wrong
result.
And I said that such existing applications are obviously buggy, but you
13.10.2014 19:23, Adriano dos Santos Fernandes wrote:
Please look at test staticMessage2 at
https://github.com/asfernandes/fbstuff/blob/master/src/test/v3api/StaticMessageTest.cpp
The second openCursor tries to pass NULL to a not-NULL parameter.
With embedded, the test works.
With remote,
15.10.2014 18:50, Alex Peshkoff wrote:
Distro kernel glibc Firebird3 ok
Debian 6 2.6.32 2.11.2 no
Debian 7 3.2.41 2.13yes
RHEL-5 2.6.18 2.5 no
RHEL-6 2.6.32 2.12no
RHEL-7 3.102.17yes
SLE11
15.10.2014 19:20, Alex Peshkoff wrote:
In that case we will have to keep suing a hack with a shared posix mutex
to avoid an old bug in a kernel fixed in 2.6.33 or 24 (do not remember
exactly). Showed itself on CS when accessing same db remotely (i.e. as
firebird user from OS POV) and embedded
16.10.2014 14:55, Geoff Worboys wrote:
I've cut the problem down to the thing that's giving me
trouble: I want to return a non-null value when when the
input expression resolves to null. In the code below I'm
just trying to return a 0 (for the sake of the example).
This executes but still
Fabiano,
I’m testing the new Firebird 3.0 build 31369 and trying to restore a big
database and at some point, creating an index gbak.exe crashes and
database restore is interrupted.
In the firebird.log I got 2 entries:
FABIANOWed Oct 22 15:46:42 2014
27.10.2014 12:30, Robbert-Jan wrote:
While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha
2), I get this error:
action cancelled by trigger (3) to preserve data integrity
object has non-SQL security class defined
Can you provide us with this backup?
Dmitry
27.10.2014 13:34, Robbert-Jan wrote:
Sure, I'm happy to.
As long as I can put it somewhere privately (i.e. not on the internet) and
you're willing to destroy it after analyzing/fixing.
I will destroy it for sure.
Where can I put it?
Do you have FTP server in your company?
The size of the
27.10.2014 15:20, Robbert-Jan wrote:
But do I have to create a issue in the tracker for this? I guess not, if it
only applies to converting from alpha2 to beta1.
I can now confirm this being an incompatibility in the backup format
introduced between Alpha 2 and Beta 1. This affects packages
28.10.2014 00:09, Thomas Steinmaurer wrote:
does the following reflect the real status quo on what needs to be done
for Beta 2?
http://tracker.firebirdsql.org/browse/CORE/fixforversion/10586
More or less. Some items from that list can be postponed and some minor
tasks may be not in the list.
27.10.2014 19:58, Paul Reeves wrote:
What is - currently - the reason to keep supporting the cpl applet? Does it
do anything more than just starting/stopping the service?
It has always allowed switching the guardian on and off, as well as switching
between running as an app or a service.
My
Ann,
I think it would be wise to add a [NO] VALIDATION modifier to constraint
definitions, including NOT NULL and referential integrity definitions.
In the presence of a VALIDATION modifier, Firebird would begin enforcing
the constraint on commit (as now) and then start a pass to insure that
28.10.2014 00:14, Thomas Steinmaurer wrote:
Now while constraints are under discussion, if we could put deferred
constraints into the nice to have pot ... ;-)
Not for v4, sorry.
Dmitry
--
Firebird-Devel mailing
28.10.2014 10:34, Martijn Tonies wrote:
It would be nice to be able to easily control the instances from a small
application.
What's wrong with the Windows Service Manager? ;-)
Dmitry
--
Firebird-Devel mailing
28.10.2014 12:35, Dimitry Sibiryakov wrote:
Oracle?.. Their invalid DB objects aren't about consistency even in the
smallest.
Invalid metadata invalid data. We're speaking about the latter here.
Dmitry
--
28.10.2014 13:28, Adriano dos Santos Fernandes wrote:
If user knows what he's doing, then the database is not validating, it's
just wasting his time.
I think there should be a NO VALIDATION option.
Generally, I don't mind. My point was that *by default* VALIDATION
should be implied and such
28.10.2014 18:28, Alex Peshkoff wrote:
I understand that using mon$ tables could be better but afraid for FB3
time for such changes is gone.
Feel free to modify SEC$USERS, if needed. I'm likely to commit changes
for MON$ tables before Beta 2 as well.
Dmitry
28.10.2014 18:55, Alex Peshkoff wrote:
What if I also add that info not to SEC$USERS but to MON$DATABASE?
No problem, but what is that info? Name of the security db or what?
I'm asking because we had plans to introduce all config settings (actual
to this database) via a new MON$ table. So
28.10.2014 19:06, Martijn Tonies wrote:
MON$SEC_DATABASE_USED
values: DEFAULT / SECONDARY
Maybe DEFAULT, SELF, OTHER?
I may imagine cases when EUA and other-non-default dbs should be
distinguished.
Dmitry
--
28.10.2014 19:19, Martijn Tonies wrote:
What would self mean? Are the security tables inside the database
you're connecting to?
Self = EUA. Not just having security tables but actually known to be
authenticated using them while connecting.
And other non default would be a few databases
28.10.2014 19:37, Dimitry Sibiryakov wrote:
Why it is security.fdb, not security3.fdb then?..
Actually, it's security.db, not security.fdb ;-)
security.db = $(dir_secDb)/security3.fdb
Dmitry
--
Firebird-Devel
31.10.2014 20:19, Leyne, Sean wrote:
The only issue is that the restart will not happen immediately, but after 1
minute (interval granularity is minutes, not seconds)
Isn't zero interval allowed?
Dmitry
--
Fabiano,
I’m testing the new Firebird 3 Snapshot (31387) and I got a SP creation
error that does not occur in FB 2.5.1.
/Column unknown./
/ITENS.BDCODNAT./
This is an intended limitation to comply with the SQL specification (and
other databases as well).
from vef_emp_tmovseritens itens ,
03.11.2014 23:14, Mark Rotteveel wrote:
For implementing this I need to add two keywords: ROW and OFFSET (note:
defined as reserved in SQL standard), but looking at the definition in
keywords.cpp, I wonder what I need to use for version (1 or 2, or maybe
a different value.
Version 2.
04.11.2014 18:18, Dimitry Sibiryakov wrote:
Could someone explain meaning of each of the values?
enum req_s {
req_evaluate,
req_return,
req_receive,
req_send,
req_proceed,
req_sync,
req_unwind
};
req_evaluate - execute the node inside the main
09.11.2014 12:21, Mark Rotteveel wrote:
I noticed that when dropping a user that does not exist (using DROP
USER), the isc_gsec_err_rec_not_found error is not triggered on execute,
but only on commit, which is rather unexpected and makes it harder to
take appropriate actions.
Why is this,
11.11.2014 21:02, Mark Rotteveel wrote:
Anyone?
I'm looking at the patch, please be patient ;-)
Dmitry
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email,
23.11.2014 19:12, Alexpux wrote:
I’m use Firebird about 7 years and now I’m interesting in build Firebird
with mingw-w64 toolchains.
Out of curiosity, why you need to build it yourself instead of using the
official binaries? This is quite uncommon for Windows users.
Most free databases
23.11.2014 20:23, Dimitry Sibiryakov wrote:
No dependency on C++ runtime
Is it really important for MSVC10 and higher?
Dmitry
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate!
Mark,
I'm looking at the patch, please be patient ;-)
Any news on this?
I don't have any major problems with the patch. Just a few questions:
1) Why have you decided to extend select_expr via duplication rather
than using something like this:
%type selectExprNode select_expr
select_expr
:
30.11.2014 15:37, Mark Rotteveel wrote:
Well, that was quick ;) Should I go and implement it anyway, or do we
leave this until it is reported against an actual 3.0 release?
So far it's about pure artificial testing, not something really used in
production. So I'd wait a bit more ;-)
Dmitry
://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Beta1-ReleaseNotes.pdf
--
Dmitry Yemanov
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your
07.12.2014 23:17, liviusliv...@poczta.onet.pl wrote:
I can connect to FB3 from flamerobin and from Delphi applications.
Using which fbclient version?
But i can not from .Net from VS 2013 by .Net provider
It could be either misconfigured server (ServerAuth) or the same
protocol issue as
08.12.2014 10:26, liviuslivius wrote:
what chappened with version number of firebird 3?
I have current snapshot (2014-12-08)
3.0.0.25042
and from (2014-10-30)
3.0.0.30703
as you can see older version have bigger version number.
The script failed this night. Will be investigated.
Dmitry
09.12.2014 22:01, Mark Rotteveel wrote:
Dmitry, can you resolve the ticket for me?
Done.
Dmitry
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your
11.12.2014 15:32, Alex Peshkoff wrote:
I've almost finished with SQL command fixing database to make it usable
with ICU version not matching one with which database was created. This
helps in a cases like one described in
http://tracker.firebirdsql.org/browse/CORE-4571 . With mentioned
11.12.2014 16:39, Alex Peshkoff wrote:
I like
ALTER DATABASE RESET ICU
or even
ALTER DATABASE RESET INTERNATIONAL
IMHO it's no big use explicitly setting VERSION here
What string do you mean here - no idea.
[VERSION] string meant to explicitly specify ICU version to use (from
multiple
11.12.2014 17:42, Alex Peshkoff wrote:
Have you ever seen in gstat -h? :)
BTW, is it really about database creation?
IIRC, ICU version is stored in collation specific attributes. If one
creates one ICU collation, then upgrade ICU and create another collation
- wouldn't he/she be in the same
11.12.2014 18:32, Adriano dos Santos Fernandes wrote:
Copy back and forth and rebuilding indexes every time?
A database created with incompatible (at least different) ICU version
simply cannot be accessed on the other host. This was my experience with
FB3 before Beta. I had to ask for a
18.12.2014 10:47, Alexey Pavlov wrote:
-*(ISC_ULONG *)arg_vector[-1].a_address = (ISC_ULONG)p;
-
+*(uintptr_t *)arg_vector[-1].a_address = (uintptr_t)p;
So far our practice is to favor FB-specific typedefs instead of system
ones. U_IPTR should be used here instead of uintptr_t.
Dmitry
19.12.2014 11:34, Alexpux wrote:
Looking into Cobol module I see there are lot of this such things. Also maybe
need there replace deprecated procedures like «isc_interprete».
IIRC, Cobol support exists for 32-bits only, so all these issues are
just annoying warnings that never appear in
19.12.2014 10:05, Alexpux wrote:
Next patch works for me.
Applied.
Dmitry
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
22.12.2014 11:26, Alexey Pavlov wrote:
ping?
Applied, but I cannot validate compilation at the moment.
Dmitry
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge
07.02.2015 13:27, Alex Peshkoff wrote:
I.e. if we decide to go this way we should do this with all catch blocks
which is a change not differing much in volume of changes from changing
tdbb_status_vector to something capable to store unlimited length vectors.
True. But I don't suggest to do
07.02.2015 13:27, Alex Peshkoff wrote:
I do not see too big trouble with full checks of string args. But what
about keeping legacy dup check present in ERR_post()? Taking into an
account that string once made permanent will remain the same per thread
suppose it will be enough for most cases.
04.02.2015 13:36, Dmitry Yemanov wrote:
FB3 snapshots on Windows are not builded. The archives at
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/ only examples
without binaries.
Fixed now.
Dmitry
04.02.2015 12:37, Simonov Denis wrote:
FB3 snapshots on Windows are not builded. The archives at
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/ only examples
without binaries.
Windows builds are broken. I've removed the invalid snapshot builds from
the download area.
Dmitry
All,
Historically, exception handling looked this way at the JRD level:
try
{
tdbb-tdbb_status_vector = user_status;
}
catch (const Exception ex)
{
return error(user_status);
}
Errors were raised via ERR_post() which *appends* to tdbb_status_vector
and then throws. Errors were reposted
01.02.2015 02:08, liviusliv...@poczta.onet.pl пишет:
max 255 contexts allowed
like in select:
select
(select field from XXX where ...),
(select field from XXX where ...),
(select field from XXX where ...),
(select field from XXX where ...),
(select field from XXX where
01.02.2015 18:58, liviusliv...@poczta.onet.pl пишет:
Is some plan for extend this?
Not in v3.
Dmitry
--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in
15.02.2015 11:03, liviusliv...@poczta.onet.pl wrote:
Today the same - only examples in Firebird-3.0.0.31644-0_x64.7z
Fixed now, thanks.
Dmitry
--
Dive into the World of Parallel Programming. The Go Parallel
17.03.2015 23:08, liviusliv...@poczta.onet.pl wrote:
iValue integer not null,
sValue Smallint not null,
iValue2 integer not null,
iValue3 integer not null
($CC, $BB, $AA, $11, 0, 0, $DD, $33, 0, 0, 0, 0, $DD, $CC, $BB, $22, 0, 0,
0, 0, $DD, $CC, $BB, $22, 0, 0, 0, 0, 0,
16.03.2015 10:58, liviuslivius wrote:
snapshot of Firebird3 not conatain employee.fdb and also full script for it
IIRC, it was temporarily disabled one day due to Windows build issues
and supposedly forgotten to be enabled back. I will check.
Dmitry
09.03.2015 14:13, liviuslivius wrote:
what is Access By ID in explained plan? Why ID?
- Filter
- Table ZLEC_FAKT as ZF Access By ID
ID = internal record identifier (number). Better publicly known as
DBKEY, although DBKEY is actually a wider term, as it includes
09.03.2015 17:06, liviuslivius wrote:
what is the difference between
Index ROZLICZENIE_FK1 Range Scan (lower bound: 1/1, upper bound: 1/1)
When you see lower/upper bound: N/M, this is a less/greater/between
scan. Each boundary condition may use N of M segments.
Index RODZAJ_DZIAL_FK Range
10.03.2015 15:56, Omacht András wrote:
why do you need several working directory?
Using git is very cheap to switch between branches, it is not necessary to
make local copies.
I don't see much sense to create a branch every time I have an idea to
play with. Maybe a half of them end nowhere,
10.03.2015 15:30, Michal Kubecek wrote:
However, there is seldom need for multiple working directories.
Right now I have five working directories for the same B2_5_Release
branch, each with different uncommitted changes. I don't see how it can
be avoided.
Dmitry
11.03.2015 23:32, Rudolf Grauberger wrote:
there is already a rough plan when the 2.5.4 version to be published?
This month.
Dmitry
--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
05.03.2015 23:53, Claudio Valderrama C. wrote:
People, maybe you're going to say that this would be ugly, but at
www.firebirdsql.org
after the PROJECT NEWS I would like to see information about latest commits,
maybe this whole page inside a frame:
12.03.2015 16:13, liviuslivius wrote:
i only have question with this:
CREATE TABLE XXX
(
A INTEGER,
B INTEGER,
C INTEGER,
D INTEGER,
E INTEGER
);
CREATE INDEX IXA_XXX__ALL ON XXX(A, B, C, D, E);
SELECT
*
FROM
XXX X
WHERE
X.A=5
AND X.B=6
AND X.C6
14.03.2015 02:03, liviusliv...@poczta.onet.pl wrote:
I read that to get unlimited text of explained plan i should look into
TMP$STATEMENTS
but i got limited text in MON$EXPLAINED_PLAN in MON$STATEMENTS for some big
query
it end after 14 808 bytes as
Select Expression
-
nothing more
14.03.2015 15:38, Robbert-Jan wrote:
I’m trying to retrieve the explain plan of the last prepared query,
using the mon$explained_plan field, introduced in FB3 beta.
I used:
SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id =
CURRENT_TRANSACTION
Wrong. You should use
12.03.2015 17:37, liviuslivius wrote:
SELECT
*
FROM
XXX X
WHERE
X.A = 12 AND X.B = 1
ORDER BY
X.A, X.B, X.C, X.D, X.E
PLAN (X ORDER IXA_XXX__ALL)
Select Expression
- Filter
- Table XXX as X Access By ID
- Index IXA_XXX__ALL Range
12.03.2015 15:13, liviuslivius wrote:
is possible to extend this to show
Range Scan (lower bound: 1/1, upper bound: 1/1) + (partial match: 1/2)
like
Range Scan (partial match: 1/2, lower bound: 1/1, upper bound: 1/1)
e.g.
compound index
CREATE INDEX INDEX_NAME AAA ON XXX(A, B);
401 - 500 of 1223 matches
Mail list logo
