Re: [Firebird-devel] Altering collation of field

2015-09-23 Thread Jiří Činčura
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

[Firebird-devel] Replacing `instsvc`

2015-09-17 Thread Jiří Činčura
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

Re: [Firebird-devel] Replacing `instsvc`

2015-09-17 Thread Jiří Činčura
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

Re: [Firebird-devel] Replacing `instsvc`

2015-09-17 Thread Jiří Činčura
. 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.

[Firebird-devel] Altering collation of field

2015-09-16 Thread Jiří Činčura
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

Re: [Firebird-devel] Different collation ID for alteredcomputedcolumn

2015-09-15 Thread Jiří Činčura
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 -

Re: [Firebird-devel] Different collation ID for altered computedcolumn

2015-09-14 Thread Jiří Činčura
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

Re: [Firebird-devel] Different collation ID for alteredcomputedcolumn

2015-09-14 Thread Jiří Činčura
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

[Firebird-devel] ADO.NET provider 4.8.0.0

2015-09-14 Thread Jiří Činčura
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

Re: [Firebird-devel] [NO] RECORD_VERSION

2015-09-14 Thread Jiří Činčura
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

Re: [Firebird-devel] Different collation ID for altered computed column

2015-09-13 Thread Jiří Činčura
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

[Firebird-devel] 2.5.5 release

2015-09-11 Thread Jiří Činčura
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

Re: [Firebird-devel] 2.5.5 release

2015-09-11 Thread Jiří Činčura
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

Re: [Firebird-devel] Different collation ID for altered computed column

2015-09-11 Thread Jiří Činčura
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

Re: [Firebird-devel] Error using array

2015-08-26 Thread Jiří Činčura
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

[Firebird-devel] Error using array

2015-08-26 Thread Jiří Činčura
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

[Firebird-devel] Number of connections to DB

2015-08-21 Thread Jiří Činčura
- 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

Re: [Firebird-devel] Number of connections to DB

2015-08-21 Thread Jiří Činčura
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

[Firebird-devel] Accessing log file via service_mgr

2015-08-19 Thread Jiří Činčura
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

Re: [Firebird-devel] Accessing log file via service_mgr

2015-08-19 Thread Jiří Činčura
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

Re: [Firebird-devel] Accessing log file via service_mgr

2015-08-19 Thread Jiří Činčura
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

[Firebird-devel] SQLSTATE difference between server and embedded

2015-08-18 Thread Jiří Činčura
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

Re: [Firebird-devel] Insecure hashing and encryption in Firebird 3

2015-07-27 Thread Jiří Činčura
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

Re: [Firebird-devel] Insecure hashing and encryption in Firebird 3

2015-07-26 Thread Jiří Činčura
. Agree. -- Mgr. Jiří Činčura Independent IT Specialist -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] code quality and strange comments

2015-07-15 Thread Jiří Činčura
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

[Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Jiří Činčura
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

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Jiří Činčura
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

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread 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ří

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Jiří Činčura
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

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Jiří Činčura
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

[Firebird-devel] ADO.NET provider 4.6.4.0

2015-06-26 Thread Jiří Činčura
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

[Firebird-devel] Differences between triggers

2015-06-25 Thread Jiří Činčura
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

[Firebird-devel] ADO.NET provider 4.6.3.0

2015-06-25 Thread Jiří Činčura
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

[Firebird-devel] Extracting metadata using Services API

2015-06-15 Thread Jiří Činčura
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

[Firebird-devel] ADO.NET provider 4.6.2.0

2015-04-15 Thread Jiří Činčura
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

[Firebird-devel] ADO.NET provider 4.6.0

2014-12-30 Thread Jiří Činčura
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

Re: [Firebird-devel] Visual Studio Community 2013

2014-11-18 Thread Jiří Činčura
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

[Firebird-devel] ADO.NET provider 4.5.2.0

2014-11-10 Thread Jiří Činčura
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

[Firebird-devel] Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Jiří Činčura
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

Re: [Firebird-devel] Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Jiří Činčura
= 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

Re: [Firebird-devel] Odp: Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Jiří Činčura
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

[Firebird-devel] MS SQL over SMB2

2014-09-24 Thread Jiří Činčura
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

Re: [Firebird-devel] MS SQL over SMB2

2014-09-24 Thread Jiří Činčura
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

Re: [Firebird-devel] MS SQL over SMB2

2014-09-24 Thread Jiří Činčura
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

[Firebird-devel] ADO.NET provider 4.5.1.0 for Firebird is ready

2014-09-09 Thread 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

Re: [Firebird-devel] Regex returning error

2014-09-02 Thread Jiří Činčura
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

[Firebird-devel] Regex returning error

2014-09-02 Thread Jiří Činčura
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

<    2   3   4   5   6   7