I quickly also checked Postgres and it works there.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web
Hi,
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-]' is fine. Testing the first regex on various parsers it worked. Why it
doesn't work on Firebird?
--
Mgr. Jiří Činčura
and
EntityFramework.Firebird (or from firebirdsql.org).
More info:
http://blog.cincura.net/233477-ado-net-provider-4-5-1-0-for-firebird-is-ready/
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Want excitement?
Manually upgrade your
http://blogs.technet.com/b/josebda/archive/2011/02/24/sql-over-smb2-one-of-the-top-10-hidden-gems-in-sql-server-2008-r2.aspx
Maybe we can investigate how are they doing it and how reliable it is and what
are the gotchas.
--
Mgr. Jiří Činčura
Independent IT Specialist
I do not see SMB 2 as an appropriate for use for database functions.
I was confused by SMB2/2.1 as well. I thought it might be good to investigate
what they are doing (preventing problems, how the share is opened, ...).
--
Mgr. Jiří Činčura
Independent IT Specialist
Jiri Could you do some tests on a smb 3 share with Firebird ?
I don't have a device with SMB3 support or Windows 2012 machine. I can install
it to VM, but that's not going to show valuable data, I think.
--
Mgr. Jiří Činčura
Independent IT Specialist
Hi,
Is there a way to add/remove NOT NULL to a column using single DDL command in
Firebird (2.5 for the start)? I'm tuning support for Entity Framework
Migrations in .NET provider and this is one case.
--
Mgr. Jiří Činčura
Independent IT Specialist
= cc.rdb$constraint_name
where rc.rdb$constraint_type = 'NOT NULL'
and rc.rdb$relation_name = 'AAA_TEST'
and cc.rdb$trigger_name = 'FOO'
)
but that does not work, obviously. Maybe there's some syntax hack I haven't
tested, yet.
--
Mgr. Jiří Činčura
Independent IT Specialist
That’s my escape plan. Currently still hoping for “direct” solution. :)
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo
More info:
http://blog.cincura.net/233487-ado-net-provider-4-5-2-0-for-firebird-is-ready/ .
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
others
optimizations).
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
More info at:
http://blog.cincura.net/233492-ado-net-provider-4-6-0-0-for-firebird-is-ready/ .
Enjoy.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Dive into the World of Parallel Programming! The Go Parallel
More info
http://blog.cincura.net/233504-ado-net-provider-4-6-2-0-for-firebird-is-ready/ .
--
Mgr. Jiří Činčura
Independent IT Specialist
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own
Hi *,
If I create insert or delete and delete or insert trigger these are stored
differently in a system table. Is there really a difference?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor 25 network
More info
http://blog.cincura.net/233510-ado-net-provider-4-6-3-0-for-firebird-is-ready/ .
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor 25 network devices or servers for free with OpManager!
OpManager
Just a way to store the order you passed.
I know it doesn't matter now, but is there a reason to store the order?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor 25 network devices or servers for free
Extract the metadata in the same way it was created, I guess.
Funny. Because there's at least two dozens cases where the generic form is
extracted. :)
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor 25
More info
http://blog.cincura.net/233511-ado-net-provider-4-6-4-0-for-firebird-is-ready/ .
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor 25 network devices or servers for free with OpManager!
OpManager
Hi,
Is there a way to extract only metadata of database (same as isql -x/-a) using
Services API?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https
Hi *,
Firebird allows me to change domain's datatype even if column with this domain
is used in an index. Is it OK or should the index be dropped and created again?
--
Mgr. Jiří Činčura
Independent IT Specialist
Look at execution statistics. If commit took more time than expected
(few ms), performs a lot of fetches\marks, etc - it could be sign that
index(es) was rebuild.
Thanks. I'm testing now on empty database, just to see what's possible. I'll
generate some data.
--
Mgr. Jiří Činčura
If new datatype is the same from index POV, there is no need to rebuild
index.
Not sure what you mean by same? Let's say I change it from smallint to int.
Else, IIRC, engine rebuild all indices dependent on domain-based fields.
You can check it yourself, btw :)
How?
--
Mgr. Jiří
some place before this
code.
JC
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi *,
When accessing log file via service_mgr and the log file is not there (as it's
normal after fresh installation) Firebird returns operating system directive
fopen failed. Shouldn't it just create an new file and return empty string?
--
Mgr. Jiří Činčura
Independent IT Specialist
I may agree that the Services API could rather return an empty string, but
disagree that it should create the file. It would be kinda layering
violation.
Should I put it into tracker?
--
Mgr. Jiří Činčura
Independent IT Specialist
As for me I prefer existing behavior - if file is missing it should better
be reported.
Then I believe the installer and zip packages should contain already this file.
Empty. Then when the file is really not there, we can claim it's missing.
--
Mgr. Jiří Činčura
Independent IT Specialist
- basically I found that after 10+
seconds it's OK, but that's too long. I'm checking how the pooling works in
.NET provider tests and this number is crucial to know there's nothing dangling.
JC
--
Mgr. Jiří Činčura
Independent IT Specialist
considers the connection alive
and there are no ways to count it as dead.
It is correct disconnect. But looks like there's some delay. Look like slower
the machine the more often I see it.
--
Mgr. Jiří Činčura
Independent IT Specialist
about offline
cracking. But in that case stealing the actual database might be as good as
passwords. :)
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https
.
Agree.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Any of these comments are not compiling?
I think he's not worried about the comments themselves. But about what these
are talking about. I'm pretty sure you understood it. ;)
--
Mgr. Jiří Činčura
Independent IT Specialist
Hi *,
May I kindly ask why the firebird.conf/databases.conf uses XML-like format
(although it's not XML) but plugins.conf uses different one using curly braces
etc.?
--
Mgr. Jiří Činčura
Independent IT Specialist
I saw `` with some per database settings in
today's presentation on Firebird seminar in Prague. Not sure whether it
was Dmitry or Alexey. Kind of surprised me. :o
--
Mgr. Jiří Činčura
Independent IT Specialist
On Fri, Nov 13, 2015, at 17:06, Alex Peshkoff wrote:
> On 11/13/2015 06:58 PM, J
On Fri, Nov 13, 2015, at 17:51, Alex Peshkoff wrote:
> It's from trace config for FB 2.5. It's really XML-like. In FB3 all
> config files follow { } style.
Interesting. I was really sure it was databases.conf. Never mind. Thanks
for clarifying that up.
--
Mgr. Jiří Činčura
Indep
bly right. :)
What a shame the trace config structure was not changed in FB 3. :(
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo
of. :)
Anyway I'm on track of something probably. Looks like the slice size
computation is wrong. And hence I'm confusing server.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web
Hi *,
I'm looking at DNET-313 and the code get from server subscript out of bounds.
Can somebody tell me what that means? I have never used (and will never use ;))
arrays, so this is new to me.
--
Mgr. Jiří Činčura
Independent IT Specialist
COLLATE UNICODE_CI
The resulting "show domain" produces different results. Which is at
least confusing. Of course tools like IBExpert are confused by this as
well. Especially for raw DDL exports (which for co
s quite dirty. But I need to be able to change collation on
a field and - lucky me - the field is used in another (computed) field.
Is there a way to force system tables to "sync"? Or other way to change
collation?
--
Mgr. Jiří Čin
Hi,
is there some ETA for 2.5.5? I'm hitting CORE-4759 in last few days.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo
On Fri, Sep 11, 2015, at 11:06, Dmitry Yemanov wrote:
> Within a month. v3 RC1 is of a top priority, v2.5.5 will follow right
> after.
Thanks. I just hope to keep all DBs above the water now. It was fucked
up for half a year, I'm lucky to not hit it sooner.
--
Mgr. Jiří Činčura
Indep
t's not critical.
> situation inside FB may not be 100% ideal but it's not a bug. Now if you
> want to log it as a bug, it's your pleasure.
Absolutely. I put it into tracker (CORE-4934), just to have it saved.
Maybe somebody, when bored, will tackle it.
--
Mgr. Jiří Činčura
Independent IT S
bug to 2.5?
>
> Or do you want us to search the tracker to 1) mark your bug as duplicate
> 2) mark it as fixed in v3 ?
Do whatever you feel is right. Sorry for bothering.
--
Mgr. Jiří Činčura
Independent IT Specialist
-
ill
remove the instsvc.exe itself, which has nothing to do with Firebird.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from a
rectly letting MSI do the
job? Just asking...
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps a
. If is
*sounds* complicated so be it.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
On Fri, Sep 11, 2015, at 16:49, Adriano dos Santos Fernandes wrote:
> Some bug fixed (intentionally or not) in v3.
Should I put it to tracker?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mail
f hell and he answered it's the result of
> the
> complex logic to alter tables and fields.
Is it expected and intentional? Because I believe the operation should
result in same values. It's like 1+1 = 0+2, at least I understand it
that way.
--
Mgr. Jiří Činčura
Independent I
More info
http://blog.cincura.net/233530-ado-net-provider-4-8-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
On Mon, Sep 14, 2015, at 10:28, Vlad Khorsun wrote:
> PS Some client access components/drivers have its own defaults.
That was Dmitry Kuzmenko's wild ride 3-4 years back. ;)
--
Mgr. Jiří Činčura
Independent IT Special
More info
http://blog.cincura.net/233531-ado-net-provider-4-8-1-0-for-firebird-is-ready/.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
g indexes manually after. So that should be covered.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Nobody?
--
Mgr. Jiří Činčura
Independent IT Specialist
On Wed, Sep 16, 2015, at 12:28, Jiří Činčura wrote:
> Hi *,
>
> there's currently no way of altering collation of field in 2.5.4, right?
> I checked all the possible documentation on firebirdsql.org and haven't
> found
On Sun, Dec 6, 2015, at 19:00, Leyne, Sean wrote:
> This seems worthy of a Tracker case, no?
I agree.
BTW given it's a set of tests for .NET provider it's extremely easy to
replicate. Something I can help you with to pinpoint the issue?
--
Mgr. Jiří Činčura
Independent IT Special
and executed. No
configuration whatsoever. Any idea what it might be?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences
Hi *,
is there a way to create a trigger with UDF usage while the library
itself is currently missing?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https
Hi *,
is there a way to create a trigger with UDF usage while the library
itself is currently missing?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https
More info
http://blog.cincura.net/233539-ado-net-provider-4-9-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
.
Not sure if it's correct (or where I found that information ;)).
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with
On Wed, Nov 25, 2015, at 07:39, Jiří Činčura wrote:
> Not sure if it's correct (or where I found that information ;)).
Ha, looks like I was already there:
http://markmail.org/message/skkpcjl3wnnjzqfl.
--
Mgr. Jiří Činčura
Independent IT Special
IC/DECIMAL based on `scale`, but
the `subtype` has confusing value.
All fields in the query's expression are DECIMAL(18,4).
Thanks JC.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Go from Idea to Many App Sto
> passed to the
> engine as isc_dpb_host_name.
Does it make sense to send both then?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and t
> Sorry, the bug was another with SELECT FROM PROCEDURE.
Ahh, now it makes sense. It even works as expected on 3.0.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monit
Hi *,
just out of curiosity what the relation between for example
isc_dpb_host_name and CNCT_host?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth
> And behaves different 3.0, so obvious answer, it was a bug. ;)
On Firebird 3.0 I'm getting:
Statement failed, SQLSTATE = 42000
validation error for variable TEST, value "*** null ***"
-At procedure 'TEST' line: 6, col: 3
Basically the same. So maybe it is still a bug.
--
Mgr.
"*** null ***".
At procedure 'TEST' line: 6, col: 3.
I don't understand why... Why there's validation? The SUSPEND is never
called, so...
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can
Done; CORE-5278.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols
Hi *,
looking into memory dump for parameters in external engine in OO API is
{ 0xFF 0xFF } for true and anything else (basically 0) for false.
Correct?
Thanks.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend
OK, so it's expected. I was just confused by isc_info_isc_version having
just one.
I'll adjust it in the provider.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us
/extensions, that I can call based on type from input/output
metadata.
Maybe I can convert the data to XSQLDA/XSQLVAR shape? For these I
already have routines to read/write it.
--
Mgr. Jiří Činčura
Independent IT Specialist
example ability to
> access objects with names >31 symbol long.
OK, so I'm not going to go that path. Thanks for letting me know. It
might have been time wasted later.
--
Mgr. Jiří Činčura
Independent IT Specialist
---
>Oh, c'mon. Inability to read full object name from XSQLDA field
>doesn't mean to loose
> ability to access values.
True. In this case that wouldn't matter for me.
--
Mgr. Jiří Činčura
Independent IT S
0]: 50
[31]: 46
[32]: 53
[33]: 1
[34]: 0
...
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edg
Thanks for confirmation.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
nually flush the
output data to the server, the server closes the connection with me. So
I think the data might not be in format that server expects.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer ca
Can this be somewhat requested also by isc_info_firebird_version or
similar?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns
bird_version in
.NET provider needs to be adjusted. :)
Thanks.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tec
uld be the length of the message and following are the chars for
"WI-V3.0.0.32483 Firebird 3.0"
and so on.
Am I parsing it wrong?
2.5.5 behaves the same way.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
/getNullOffset etc. or set using
memcpy, it seems to me I'm doing it too much raw work. I'm hoping maybe
something like "setXxx(outMsg, , )" or similar exists.
JC
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Wh
> There is FB_MESSAGE macro - look at sample 06.fb_message.cpp.
Wow. Amesome. Thanks.
And I have no idea what that does. Given my lack of knowledge of C++
magic, I'm completely confused. :) What happened to simple C code that
was the same last hundred years?
--
Mgr. Jiří Činčura
Independ
A lot of trying (and errors) and still nowhere near, I think. How one
uses the FB_MESSAGE with the void* inMsg (or void* outMsg) in i.e. here
https://github.com/FirebirdSQL/firebird/blob/master/src/include/firebird/FirebirdInterface.idl#L827
?
--
Mgr. Jiří Činčura
Independent IT Specialist
>It follows SQL naming in part of storage in system tables, but working
>with config
> files has different rules.
Well, in pascal case in config it didn't work. But I don't think it
matters.
--
Mgr. Jiří Činčura
Independent IT S
I suppose it follows SQL naming scheme. I might try to quote it later
when I'm back.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco
flag exists.
> Try to make sure std client does work with this server using compressed
> connection.
With the `WireCompression = true` I can connect using isql. So I suppose
it should work. I don't see any flag in MON$ATTACHMENTS to see whether
it really used compression.
--
Mgr. Jiří Č
Ahh, looks like I found the problem. The DeflateStream in .NET is
producing really raw deflate, while Firebird want's the zlib header.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
What NetFlow Analyzer can do
OK, I'm successfully writing data to server for op_attach - checked on
network level.
Just "for fun" I tried to write uncompressed data, as it would without
compression. In that case the server closes connection with me during
writing of DPB for op_attach.
--
Mgr. Jiří Činčura
I
Hi,
When I have a, say, procedure like:
create procedure foo
...
engine bar;
Is the "bar" always the filename (without extension)? Can it be somewhat
"renamed" in plugins.conf? And how is the defaultName in
registerPluginFactory method fits into that?
Thanks.
--
Mgr. Jiří
Ha! It needs to be in upper case in plugins.conf. Solved.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech
More info:
http://blog.cincura.net/233544-ado-net-provider-4-10-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM
ion(status, statusVector);
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present th
> Can it already attach to the caller's current transaction?
Not exactly, yet.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco,
yield return Tuple.Create(i, s, @long, @short, @char);
yield return Tuple.Create(i + 1, s + nameof(Demo), @long + 1,
(short?)(@short + 1), @char);
}
--
Mgr. Jiří Činčura
Independent IT Specialist
--
>IIRC, nbackup can be called via services. Does it include -F?
That's what I'd like to have. But it looks like it doesn't.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibil
> No.
So the only option left is modify the file manually? Which of course
only works if the file is accessible for .NET provider.
Is it worth adding it to tracker or is it something CORE is not going to
do?
--
Mgr. Jiří Činčura
Independent IT Special
API it's easier to program it.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Mo
Hi *,
is there a way to execute same stuff as `nbackup -F` i.e. via (running)
server? Something that I could call from .NET provider to offer this to
customers.
--
Mgr. Jiří Činčura
Independent IT Specialist
Hi *,
is there a way to make fbclient.dll renamed to fbembed.dll work? Because
doing that results in 335545004 and 335545007.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility
>No. And i see no reason to do it (except of old ugly hacks).
> Explain, please
Legacy code. Hardcoded filename to load for FB Embedded.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insigh
e math when taking any decision.
Just out of curiosity. Are these systems going to be upgraded to
Firebird 4?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Site24x7 APM Insight: Get Deep Visibility into Applicati
Firebird 4, then you can still use those systems as
> clients, without encumbering the project.
Or if you really want to run on that platform, you can pay for it.
Simple as that.
Burning our resources on this is just not worth it, IMHO.
--
Mgr. Jiří
1 - 100 of 647 matches
Mail list logo