Optimize 1=0 and 0=1
Key: CORE-6394
URL: http://tracker.firebirdsql.org/browse/CORE-6394
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 3.0.6
Reporter: Jiri
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3
Environment: Win, x64
Reporter: Jiri Cincura
Steps:
1. Create empty database on 2.5.
2. Create this UDF:
DECLARE EXTERNAL FUNCTION BIGTIMESPAN_TO_STRING
BIGINT
RETURNS CSTRING(20) FREE_IT
Type: Bug
Components: Engine
Affects Versions: 3.0.2
Reporter: Jiri Cincura
I have a query that on one particular database throws:
2017-08-24T16:29:11.5140 (2704:01620040) ERROR AT
JStatement::openCursor
I:\DOWNLOADS\BI2.FDB (ATT_16, SYSDBA:NONE, NONE
s Versions: 3.0.2
Reporter: Jiri Cincura
Priority: Trivial
Running command with "set stats on" produces (among others):
Elapsed time= xxx sec
Other pieces have space after the name. So it should be:
Elapsed time = xxx sec
--
This message is automatical
Components: ISQL
Affects Versions: 3.0.2
Reporter: Jiri Cincura
Priority: Minor
Storing Double.NegativeInfinity
(https://msdn.microsoft.com/en-us/library/system.double.negativeinfinity(v=vs.110).aspx)
stores it correctly (correct value is read back
Components: Engine
Affects Versions: 3.0.2
Environment: FB3.0.2 x64
Reporter: Jiri Cincura
Steps to reproduce:
1. Create empty database.
2. "create view test(f) as select cast((select null from rdb$database) as
decimal(10,2)) from rdb$database;"
3. &
Environment: Win2012 R2, Win 10 CU, Win 10 AU
FB 3.0.2 32b
Reporter: Jiri Cincura
I have a weird behavior on FB 3.0.2 32b, confirmed on 3 machines
(Win2012 R2, Win 10 CU, Win 10 AU). When I execute `isql -x
database.fdb` the first run is fast. When I execute it then again the
run is slow, like
: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.2
Environment: Win10 CU x64, FB x64
Reporter: Jiri Cincura
Altering the function to same function changes the RDB$FIELD_SUB_TYPE to
garbage value.
Here's repro:
$ .\isql.exe
Use
Issue Type: Bug
Components: API / Client Library, Engine
Affects Versions: 3.0.0
Reporter: Jiri Cincura
Looking into CrumpletReader I see:
case isc_action_svc_backup:
case isc_action_svc_restore:
switch (tag
: API / Client Library, Engine
Reporter: Jiri Cincura
Priority: Minor
Similarly to setting it with `isc_action_svc_properties` it would be nice to
have an option to query for it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly
: API / Client Library, NBACKUP
Reporter: Jiri Cincura
It would be nice to have support for `nbackup -F` functionality via Services
API too.
Mailing list reference:
http://firebird.1100200.n4.nabble.com/nbackup-F-without-nbackup-binary-td4642018.html
--
This message is automatically
Reporter: Jiri Cincura
Priority: Minor
* Prepare:
CREATE TABLE T_TRANSLATION_META (
F_TRM_ID BIGINT NOT NULL,
F_TRM_CODE VARCHAR(512) CHARACTER SET UTF8 NOT NULL COLLATE
UNICODE_CI
);
CREATE TABLE T_COUNTRY (
F_CNR_ID BIGINT
: Bug
Components: Engine, GBAK
Affects Versions: 2.5.4
Environment: Windows x64, Firebird x64
Reporter: Jiri Cincura
Priority: Critical
Steps to reproduce:
*** 1:
CREATE OR ALTER VIEW CYCLE_A(
COL)
AS
select RDB$RELATION_ID from rdb$database
;
*** 2
Affects Versions: 2.5.4
Environment: Firebird-2.5.4.26856-0_x64, Windows
Reporter: Jiri Cincura
This script produces badly stored value for SP field.
RECREATE TABLE CREATEME (
NEW_FIELD INTEGER NOT NULL,
CF_ON_TABLECOMPUTED BY ((select first 1 u.Created
: Engine
Affects Versions: 2.5.3
Environment: Windows 7, Windows 8, x32, x64, SS, CS
Reporter: Jiri Cincura
If I do similar to '[a-z\_-]' escape '\' I got a error about invalid pattern.
The - is causing problems. Surprisingly doing '[a-z-\_]' is fine and also
'[a-z
On Wednesday, June 11, 2014, Jim Starkey j...@jimstarkey.net wrote:
The event count mechanism makes the system reliable -- if an event is
posted between the time notification is delivered and a subsequent
registration call, the subsequent call will return immediately with an
updated buffer.
ADO.NET provider 4.2.0.0 for Firebird is ready and you can find more
at
http://blog.cincura.net/233462-ado-net-provider-4-2-0-0-for-firebird-is-ready/
.
--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com
isc_service_query is rather cunning function - it has 3 clumplet-like
parameters. First is data passed to the service, next is set of requests
to it and last is buffer for answers to that requests. In the first call
you never pass data to service - it may be passed only if previous call
Hi *,
trying to implement the restore via streaming via isc_info_svc_stdin,
and I was so desperate for some real documentation that I went
directly to wire. What confuses me is the packet from fbsvcmgr vs
normal op_service_info packets I'm usually sending.
fbsvcmgr:
00 00 00 54 - op_service_info
Hi,
I'm trying to implement restore via Services API when the FBK is on
client (the new one from 2.5.2). The docs says:
If service needs some data in stdin, it returns
isc_info_svc_stdin in query results, followed by ***4-bytes value*** -
number of bytes
server is ready to accept from client.
The
On Tue, May 27, 2014 at 12:09 PM, Alex Peshkoff peshk...@mail.ru wrote:
Yes.
We are moving (unfortunately slower than wanted) to make all numbers
4-byte in services. And therefore new place is made to use 4-byte format
at once. That's not a very big trouble for you. The returned value is
Any guess why I'm getting No request from user for stdin data?
Should the data be sent to server in op_service_info message, right?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
Trying to go to bare metal.
1. I do op_service_start.
2. Then op_service_info with isc_info_svc_stdin in items. That gives
me 4b number (8k in my case).
3. Then I call op_service_info with isc_info_svc_stdin in SPB and {
isc_info_svc_line, data length, data, isc_info_end } in items. And the
ADO.NET provider for Firebird 4.1.5.0 is ready:
http://blog.cincura.net/233450-ado-net-provider-for-firebird-4-1-5-0-is-ready/
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
Hi *,
DDEX provider for Firebird has just been released. More info
http://blog.cincura.net/233441-ddex-provider-3-0-1-for-firebird-released/
.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
On Sun, Sep 15, 2013 at 5:05 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote:
Set up bidirectional replication between old server with old FB version and
new version
with 3.0. This way you can move load from old server to new one step-by-step
and if any
problem appear, return users back to
On Thu, Nov 28, 2013 at 2:31 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote:
Only if database was designed this way. Properly designed databases should
not produce
conflicts.
Please. That's nonsense. I'm simply updating same records from more
apps. Very often at the same time (or better to
On Thu, Nov 28, 2013 at 2:57 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote:
Do inserts instead of updates. This way you get rid of conflicts and as a
bonus will
get a good history of changes.
Yeah. I have another 10 man-years to rewrite all this stuff.
Ok, set two IP addreses for
New version of ADO.NET provider for Firebird (4.0.0.0) is ready.
Details at
http://blog.cincura.net/233429-ado-net-provider-for-firebird-4-0-0-0-is-ready/
.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
More info at
http://blog.cincura.net/233420-ado-net-provider-for-firebird-3-2-0-0-is-ready/
.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
October Webinars: Code
Hi *,
I have currently one big machine (32CPUs, 128GB RAM, SSDs) for at
least 6 months for my testing. And we'd like to start testing Firebird
3.0 - to see whether we will see some improvement in resource usage
and mainly throughput and also help with stability testing (if
somebody here is
Hi *,
how's nbackup properly spelled? Nbackup or nbackup or NBackup or
nBackup or ...?
JC
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Learn the latest--Visual
Looks like the metadata is cached not for transaction, but for the lifetime
of connection and it is not invalidated.
On Wednesday, April 17, 2013, Jiri Cincura wrote:
On Wed, Apr 17, 2013 at 1:24 PM, Dimitry Sibiryakov
s...@ibphoenix.comjavascript:;
wrote:
Yes, it is expected during
Hi,
I'm now working on DNET-359. On SS everything is fine, but on CS/SC
the error happens.
To be precise the order of events is:
Select 1
Select 1 success
Alter
Alter success
Select 2
Select 2 error: Datatype dtype_unknown is not supported for sorting operation
Insert
Insert error: Column has
On Wed, Apr 17, 2013 at 1:24 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote:
Yes, it is expected during working with uncommitted metadata changes. You can
automatically commit DDL.
The alter statement is committed.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ |
Question maybe unrelated, maybe not. But why we are even using SVN
from SF? We have enough HW (and let's face it, SVN doesn't need huge
box) and we can run it ourselves. I do it, it's close to nothing
administration. Then we can have whatever we want and maybe more.
--
Jiri {x2} Cincura
Hi *,
the fbtrace.conf for FB 2.5.2 states:
# String values should be enclosed into (any kind of) quotes if contains
# spaces embedded, for example:
# log_filename 'C:\Documents and Settings\Firebird\My Documents\trace.log'
# include_filter Database Stats
What if the string contains
On Fri, Nov 23, 2012 at 3:33 PM, Vlad Khorsun
hv...@users.sourceforge.net wrote:
Backslash should work for all kind of regexp's (include_filter,
exclude_filter,
database name pattern).
Should the backslash already in RegEx be handled in a specific way?
I.e. this is simple:
.+' .* -- '.+\' .*'
Hi *,
I'm glad to release today version 3.0.1 of .NET provider for Firebird.
You can read more at
http://blog.cincura.net/233084-ado-net-provider-for-firebird-3-0-1-released/
.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
Hi *,
The Sparky from Firebird Conference in Italy in 2008 is ready for
re-auction. More info in description: http://r.ebay.com/l7uMc5 .
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
Hi *,
I'm pleased to announce release of ADO.NET provider 3.0.0 for Firebird
and DDEX provider 3.0.0 for Firebird. More info:
http://blog.cincura.net/233028-ado-net-provider-3-0-0-for-firebird-and-ddex-provider-3-0-0-for-firebird-released/
.
--
Jiri {x2} Cincura (x2develop.com founder)
First of all, I don't know why Marius is posting it here, on behalf on
me. Weird. Also because he don't know the details, he doesn't know
it's a deadlock on database level, produced by *my* code. I was just
saying on Twitter. Nothing more, nothing else.
--
Jiri {x2} Cincura (x2develop.com
Hi,
The 2.7.7 version of ADO.NET provider for Firebird is ready for
download. This version contains some bug fixes as well as new
functionality. More info:
http://blog.cincura.net/232876-ado-net-provider-for-firebird-2-7-7-released/
.
--
Jiri {x2} Cincura (x2develop.com founder)
Hi *,
any ideas about DNET-398 [1]? I sent the same data to create database
for 2.5 and 2.1, but no exception in response for 2.1(.3 and .4
confirmed). Anything I should look at?
[1] http://tracker.firebirdsql.org/browse/DNET-398
--
Jiri {x2} Cincura (x2develop.com founder)
The 2.7.5 version of ADO.NET provider for Firebird is ready for download.
http://blog.cincura.net/232764-ado-net-provider-for-firebird-2-7-5-released/
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
On Wed, Mar 28, 2012 at 3:32 PM, Dmitry Yemanov firebi...@yandex.ru wrote:
Your blog refers to the Firebird website for download, but the website
does not contain the links for 2.7.5.
Yes. Waiting for Olga to update the site.
--
Jiri {x2} Cincura (x2develop.com founder)
On Sat, Feb 18, 2012 at 10:36 PM, Dmitry Yemanov firebi...@yandex.ru wrote:
You can use the service manager and ask it for isc_info_svc_server_version.
That would require another connection, isn't it?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ |
On Sun, Feb 19, 2012 at 9:34 AM, Mark Rotteveel m...@lawinegevaar.nl wrote:
Out of curiosity: why do you want to know the version before attach?
For some EF internals.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
On Sun, Feb 19, 2012 at 10:57 AM, Alex Peshkoff peshk...@mail.ru wrote:
On 02/19/12 13:53, Jiri Cincura wrote:
On Sat, Feb 18, 2012 at 10:36 PM, Dmitry Yemanov firebi...@yandex.ru wrote:
You can use the service manager and ask it for isc_info_svc_server_version.
That would require another
Hi *,
can I somehow ask for isc_info_firebird_version without database
handle? I'd like to know it before processing op_attach.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
On Wed, Jan 18, 2012 at 11:08 PM, Ivan Prenosil ivan.preno...@seznam.cz wrote:
NumericField(9, 2) + 1 - result is .. ehm ... Num/Dec(18, 2) (API will
return zero as subtype)
That's the point. What is/should be the real result in this case?
I'm happy with conclusion that if field_scale is 0
On Mon, Sep 19, 2011 at 10:39 AM, Alex Peshkoff peshk...@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 your questions :(
Looks like they are
Hi *,
is there some high level description of how the %subj% works and is
defined [1]? I'd like to think about it from .NET/CLR POV.
[1] Something like this is called when the plugin is loading (hence
some initialization can be done here); this is how the data are
pumped into the method (so it
Hi *,
I'm proud to announce new version of ADO.NET provider for Firebird -
2.6.5. It's half maintenance release, half new features.
You can find all bug fixes in tracker
On Fri, Jun 3, 2011 at 14:34, Jiri Cincura disk...@cincura.net wrote:
http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.6.0/
The correct address should be, of course,
http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.6.5/.
Thanks Alex for pointing out
55 matches
Mail list logo