Re: [Firebird-devel] control pannel bug windows7

2011-08-28 Thread Mark Rotteveel
CORE-1109, CORE-1685, CORE-1061 -- Mark Rotteveel -- EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives

Re: [Firebird-devel] Firebird terribly slow on Ubuntu 10.04 - ext4

2011-08-31 Thread Mark Rotteveel
On Tue, 30 Aug 2011 23:27:01 +0200, Fulvio Senore mail...@fsoft.it wrote: When I open a catalog (a Firebird database) the program executes a number of queries to (partially) fill some tree controls that work like folders in a file system. The queries are always very simple, something like

Re: [Firebird-devel] Firebird terribly slow on Ubuntu 10.04 - ext4

2011-08-31 Thread Mark Rotteveel
On Wed, 31 Aug 2011 16:20:24 +0200, Fulvio Senore mail...@fsoft.it wrote: I didn't know anything about the N+1 query trap, but Google was my friend. Yes, that is my problem, but I don't know how to find a better solution. My program shows 3 user selectable views. For each view a tree control

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Mark Rotteveel
On Mon, 10 Oct 2011 08:17:19 +0200, Thomas Steinmaurer t...@iblogmanager.com wrote: Hello, is there any plan for supporting conditional trigger firing as in Oracle when specifying an optional WHEN clause in the trigger DDL syntax? Currently in Firebird, to omit trigger code execution, one

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Mark Rotteveel
On Mon, 10 Oct 2011 12:48:51 +0300, Vlad Khorsun hv...@users.sourceforge.net wrote: 10.10.2011 12:26, Vlad Khorsun wrote: If such clause is inside trigger code then it not affects security checks and *whole* trigger code is checked. SQL standard says something about security checks for

Re: [Firebird-devel] Trace data for unauthorized attach database event

2011-10-19 Thread Mark Rotteveel
On Wed, 19 Oct 2011 15:27:36 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: 19.10.2011 15:23, Mark Rotteveel wrote: Storing it could be a potential security breach. But a great advantage for DBA on support. But, as Alex already said, it is impossible. True, but if it were

Re: [Firebird-devel] Trace data for unauthorized attach database event

2011-10-19 Thread Mark Rotteveel
On Wed, 19 Oct 2011 19:41:33 +0200, Thomas Steinmaurer t...@iblogmanager.com wrote: 19.10.2011 15:31, Mark Rotteveel wrote: True, but if it were possible, this is something where the balance between convenience and security should tip to security. Audit log is kept on the server

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

2011-11-14 Thread Mark Rotteveel
On Sun, 13 Nov 2011 20:59:58 -0200, Adriano dos Santos Fernandes adrian...@gmail.com wrote: On 13-11-2011 19:48, Alexandre Benson Smith wrote: I understand that such improvement could be hard to implement because of the changes on the API and that the access libraries must be recoded for

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-29 Thread Mark Rotteveel
On Tue, 29 Nov 2011 10:04:58 +0100, Dimitry Sibiryakov s...@ibphoenix.com wrote: 29.11.2011 9:01, Dmitry Yemanov wrote: Frank has shown a somewhat similar one: it's a more or less common practice to empty/nullify the RDB$***_SOURCE columns. So perhaps, unless some good alternative can be

Re: [Firebird-devel] Created: (CORE-3672) computed index by substring function for long columns

2011-11-29 Thread Mark Rotteveel
On Tue, 29 Nov 2011 10:07:29 +0100, Dimitry Sibiryakov s...@ibphoenix.com wrote: Perhaps, better approach would be silently cut long index keys to implementation limit. This way we don't loose anything, just increase number of real comparsions with negative result during selects.

[Firebird-devel] CORE-3671 access violation in fbembed when connection isn't closed on exit

2011-12-04 Thread Mark Rotteveel
in embedded, or that I need a find a way to close connections before exit. Can a core developer look at this? Mark -- Mark Rotteveel -- All the data continuously generated in your IT infrastructure contains a definitive

Re: [Firebird-devel] CORE-3671 access violation in fbembed when connection isn't closed on exit

2011-12-08 Thread Mark Rotteveel
On 4-12-2011 14:43, Mark Rotteveel wrote: CORE-3671 describes a JVM access violation which occurs when a Java application using Firebird embedded exits when a connection hasn't been closed. The solution / workaround is of course to close() the connection from Java. I am however uncertain

Re: [Firebird-devel] Embedded 2.5.2 snapshot build

2011-12-24 Thread Mark Rotteveel
:( -- Mark Rotteveel -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer

Re: [Firebird-devel] SRP documentation for driver developers

2011-12-27 Thread Mark Rotteveel
On 26-12-2011 8:04, Alex Peshkoff wrote: On 12/24/11 13:01, Mark Rotteveel wrote: Is there any documentation available on SRP for driver developers. I looked over the commit Alex did yesterday and although I think I get the general gist of it, it would be helpful to have some additional

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-02 Thread Mark Rotteveel
with the absurd comparisons? One is normal maintenance and the other is (extreme) disaster recovery which are in no way comparable. Mark -- Mark Rotteveel -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-02 Thread Mark Rotteveel
On 2-1-2012 16:43, Dimitry Sibiryakov wrote: 02.01.2012 16:10, Mark Rotteveel wrote: Could you stop with the absurd comparisons? One is normal maintenance and the other is (extreme) disaster recovery which are in no way comparable. But downtime is downtime. Customers don't care about its

[Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2012-01-03 Thread Mark Rotteveel
set). Mark -- Mark Rotteveel -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM

Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

2012-01-03 Thread Mark Rotteveel
On 3-1-2012 22:25, Mark Rotteveel wrote: What is the exact meaning of this field? Is it only 0 for computed columns, or also in other cases (eg views)? Both the Interbase 6 as Helen's book mention it is not used, but apparently it is used (or at least: being set). Ok, I already answered part

Re: [Firebird-devel] Remote protocol backward compatibility

2012-01-03 Thread Mark Rotteveel
Firebird versions would still be supported, as well as InterBase 6.0 and above. This is about Firebird 3.0, of course. Such a cleanup would allow to simplify the code and make some future enhancements a bit easier. No objections from me: remove the old cruft :) -- Mark Rotteveel

Re: [Firebird-devel] Remote protocol backward compatibility

2012-01-04 Thread Mark Rotteveel
of the earlier Firebird versions. -- Mark Rotteveel -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops

Re: [Firebird-devel] Wrong rdb$field_sub_type for numeric computed column

2012-01-18 Thread Mark Rotteveel
On Wed, 18 Jan 2012 08:58:09 +0100, Jiri Cincura disk...@cincura.net wrote: Hi *, I have a table: recreate table test ( base numeric(15,4), test1 computed by (base+base), test2 computed by (cast(base+base as numeric(15,4))), foo bigint, bar numeric(15,4) ); If I run the

Re: [Firebird-devel] Wrong rdb$field_sub_type for numeric computed column

2012-01-19 Thread Mark Rotteveel
On Wed, 18 Jan 2012 23:08:36 +0100, Ivan Prenosil ivan.preno...@seznam.cz wrote: I have a table: recreate table test ( base numeric(15,4), test1 computed by (base+base), test2 computed by (cast(base+base as numeric(15,4))), foo bigint, bar numeric(15,4) ); If I run the query:

Re: [Firebird-devel] JSON as a core type.

2012-01-20 Thread Mark Rotteveel
On Fri, 20 Jan 2012 17:42:55 +0200, marius adrian popa map...@gmail.com wrote: I saw it today on reddit , that postgre added json as core type http://people.planetpostgresql.org/andrew/index.php?/archives/244-Under-the-wire.html I don't really see the added benefit of having this as part of a

Re: [Firebird-devel] Wrong rdb$field_sub_type for numeric computed column

2012-02-02 Thread Mark Rotteveel
On Thu, 2 Feb 2012 16:05:02 +0100, Jiri Cincura disk...@cincura.net wrote: 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

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-04 Thread Mark Rotteveel
/java/sql/ResultSet.html#insertRow() ). -- Mark Rotteveel -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio

[Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-11 Thread Mark Rotteveel
) with a readme.txt with instructions to execute it. This example contains the current Jaybird 2.2 jar and dll, but this could easily be replaced with the Jaybird 2.1.6 jar and dll (or .so). -- Mark Rotteveel -- Virtualization Cloud

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-11 Thread Mark Rotteveel
On 11-2-2012 15:54, Mark Rotteveel wrote: I am looking for the cause of CORE-3701 / JDBC-233, but I can't identify the problem. The problem is this: When using Jaybird native (using fbclient 2.5.1) the parametrized insert of a single character into a CHAR(1) column fails with error

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-11 Thread Mark Rotteveel
On 11-2-2012 16:03, Mark Rotteveel wrote: And just after I sent my mail I thought of a potential cause which I am now investigating. It looks like the XSQLVAR sqllen field 4, while the data array was only 1 entry long. Reducing the sqllen to the actual length of the array *or* padding

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-12 Thread Mark Rotteveel
On 11-2-2012 17:49, Mark Rotteveel wrote: On 11-2-2012 16:03, Mark Rotteveel wrote: And just after I sent my mail I thought of a potential cause which I am now investigating. It looks like the XSQLVAR sqllen field 4, while the data array was only 1 entry long. Reducing the sqllen to the actual

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-12 Thread Mark Rotteveel
The related issue CORE-3701 can be closed (I don't have the rights to do that). Mark -- Mark Rotteveel -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-15 Thread Mark Rotteveel
( currentXsqlvar.sqldata, byteArray.Read(), byteArray.Size()); Which is (sort of) an overflow for single character, one byte, UTF-8 and messes up the padding and causing a string truncation error. -- Mark Rotteveel -- Virtualization Cloud

Re: [Firebird-devel] With Ado.Net, closing sqlconnection still retains the connection

2012-02-15 Thread Mark Rotteveel
to ask this question on the Firebird-net-provider mailinglist (see http://www.firebirdsql.org/en/mailing-lists/ ) It is probably a good idea to include the code that you use to create your connections (you might be using connection pooling). Mark -- Mark Rotteveel

Re: [Firebird-devel] isc_info_firebird_version without database handle

2012-02-19 Thread Mark Rotteveel
On 18-2-2012 20:33, Jiri Cincura wrote: Hi *, can I somehow ask for isc_info_firebird_version without database handle? I'd like to know it before processing op_attach. Out of curiosity: why do you want to know the version before attach? -- Mark Rotteveel

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-19 Thread Mark Rotteveel
On 18-2-2012 22:38, Dmitry Yemanov wrote: 15.02.2012 20:01, Mark Rotteveel wrote: Does SQL_VARYING require the sqllen to be updated as well, or can that be left as it was originally set by isc_dsql_describe_bind? I'd say it should correspond to the real data. You're not required to use

[Firebird-devel] CORE-3671

2012-02-19 Thread Mark Rotteveel
I finally got around to checking Vlad's fix for CORE-3671: it works, the access violation no longer occurs. If nothing else needs to happen it can be marked as resolved. Mark -- Mark Rotteveel -- Virtualization Cloud

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-25 Thread Mark Rotteveel
On 13-2-2012 16:33, Dmitry Yemanov wrote: * Is 0x20 (space) the right pad char for connection characterset NONE? Yes. When sending a CHAR CHARACTER SET OCTETS field, I assume that it should be padded with 0x00, right? Mark -- Mark Rotteveel

Re: [Firebird-devel] isc_info_firebird_version without database handle

2012-02-25 Thread Mark Rotteveel
On 19-2-2012 10:54, Jiri Cincura wrote: On Sun, Feb 19, 2012 at 9:34 AM, Mark Rotteveelm...@lawinegevaar.nl wrote: Out of curiosity: why do you want to know the version before attach? For some EF internals. Ok, but to what end do you need that information before the attach? -- Mark

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Mark Rotteveel
On Tue, 06 Mar 2012 13:03:04 +0400, Alex Peshkoff peshk...@mail.ru wrote: I do not speak about removing BLR API, but for how long are we going to support old versions of BLR? Is it about supporting dialect 1? Does it mean that in dialect 1 we keep old limits like number of streams? Isn't it

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Mark Rotteveel
On Tue, 6 Mar 2012 07:14:44 -0300, Claudio Valderrama C. cva...@usa.net 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.

[Firebird-devel] Releasing and updating website

2012-03-10 Thread Mark Rotteveel
direction? Mark -- Mark Rotteveel -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service

Re: [Firebird-devel] Memory usage in Firebird

2012-03-18 Thread Mark Rotteveel
://msdn.microsoft.com/en-us/library/windows/desktop/cc441804%28v=vs.85%29.aspx ) If Firebird is not accessing certain memory pages, Windows is free to reduce the working set and store those memory pages in the pagefile. Mark -- Mark Rotteveel

Re: [Firebird-devel] Events on embedded

2012-04-09 Thread Mark Rotteveel
On 9-4-2012 12:43, Dmitry Yemanov wrote: 09.04.2012 14:19, Mark Rotteveel wrote: Are events available on embedded, and if so are there any special things you need to take care of to get them working? Of course they're available and working out of the box, without any trickery. Ok, then I

Re: [Firebird-devel] Events on embedded

2012-04-09 Thread Mark Rotteveel
On 9-4-2012 13:42, Dmitry Yemanov wrote: 09.04.2012 15:24, Mark Rotteveel wrote: Ok, then I need to get digging why some of the event related embedded tests are failing. I had ignored them previously because of this stackoverflow post: http://stackoverflow.com/questions/4438451/how-to-use

[Firebird-devel] Backport CORE-2697

2012-04-18 Thread Mark Rotteveel
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? Mark -- Mark Rotteveel

[Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Mark Rotteveel
authentication? -- Mark Rotteveel -- Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Mark Rotteveel
On 18-4-2012 20:20, Dmitry Yemanov wrote: 18.04.2012 21:55, Mark Rotteveel wrote: I just installed Firebird 3 from the Windows x64 zip kit, but I am unable to authenticate using FlameRobin, or using Jaybird. What fbclient version is loaded by FlameRobin? In the conf file I have uncommented

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Mark Rotteveel
overlooked that setting, I thought both lines started with AuthClient and had wondered why it was shown twice :| Mark -- Mark Rotteveel -- Better than sec? Nothing is better than sec when it comes to monitoring Big Data

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Mark Rotteveel
On 18-4-2012 20:39, Mark Rotteveel wrote: On 18-4-2012 20:30, Vlad Khorsun wrote: In the conf file I have uncommented: AuthClient = Srp, Win_Sspi, Legacy_Auth This is client setting. Am I missing an additional step to get things working with legacy authentication? Add

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Mark Rotteveel
On 18-4-2012 20:41, Mark Rotteveel wrote: On 18-4-2012 20:39, Mark Rotteveel wrote: On 18-4-2012 20:30, Vlad Khorsun wrote: In the conf file I have uncommented: AuthClient = Srp, Win_Sspi, Legacy_Auth This is client setting. Am I missing an additional step to get things working

Re: [Firebird-devel] Backport CORE-2697

2012-04-18 Thread Mark Rotteveel
On 18-4-2012 19:22, Adriano dos Santos Fernandes wrote: 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

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-19 Thread Mark Rotteveel
On Thu, 19 Apr 2012 11:36:15 +0400, Dmitry Yemanov firebi...@yandex.ru wrote: 19.04.2012 11:22, Mark Rotteveel wrote: Thanks. I also created a ticket to see if it is easy to change Jaybird to use the hashed authentication for Jaybird 2.2, but I don't want to do major changes in the wire

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-19 Thread Mark Rotteveel
On Thu, 19 Apr 2012 10:23:16 +0200, Kjell Rilbe kjell.ri...@datadia.se wrote: Den 2012-04-19 10:17 skrev Dmitry Yemanov såhär: 19.04.2012 12:02, Mark Rotteveel wrote: Ok, that sounds relatively easy. What is the hashing algorithm, and where in the Firebird sources can I find its

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-19 Thread Mark Rotteveel
On 19-4-2012 10:17, Dmitry Yemanov wrote: 19.04.2012 12:02, Mark Rotteveel wrote: Ok, that sounds relatively easy. What is the hashing algorithm, and where in the Firebird sources can I find its implementation? Something derived from DES, AFAIK. See ENC_crypt(), located in /src/jrd/ (pre

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-20 Thread Mark Rotteveel
On Fri, 20 Apr 2012 10:40:29 +0400, Alex Peshkoff peshk...@mail.ru wrote: On 04/19/12 22:48, Mark Rotteveel wrote: On 19-4-2012 10:17, Dmitry Yemanov wrote: 19.04.2012 12:02, Mark Rotteveel wrote: Ok, that sounds relatively easy. What is the hashing algorithm, and where in the Firebird

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-25 Thread Mark Rotteveel
is not yet in the Windows snapshot build (just looking at the ChangeLog). Mark -- Mark Rotteveel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-28 Thread Mark Rotteveel
-3.0.0.29945-0_x64 on Windows 7: plain text authentication works again. Mark -- Mark Rotteveel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed

Re: [Firebird-devel] extern/SfIO/include/stdio.h license problem

2012-05-24 Thread Mark Rotteveel
before you download it. If you want to know for sure, contact either g...@research.att.com (feedback link on the download page) or at...@att.com (licensing contact listed on the main page). Mark -- Mark Rotteveel

Re: [Firebird-devel] extern/SfIO/include/stdio.h license problem

2012-05-24 Thread Mark Rotteveel
On Thu, 24 May 2012 08:39:55 +0200, Mark Rotteveel m...@lawinegevaar.nl wrote: They also state that the entire package is covered by the license: http://www2.research.att.com/sw/download/ Under 'License' in the menu on the leftside. Mark

Re: [Firebird-devel] extern/SfIO/include/stdio.h license problem

2012-05-24 Thread Mark Rotteveel
On Thu, 24 May 2012 10:36:51 +0200, Michal Kubecek m...@mk-sys.cz wrote: On Thu, May 24, 2012 at 08:39:55AM +0200, Mark Rotteveel wrote: Before downloading you have to accept the EPL license. Now that package does contain a stdio.h (in src/lib/sfio/stdio_s) with the 'scary' license

Re: [Firebird-devel] Jira

2012-06-27 Thread Mark Rotteveel
On Wed, 27 Jun 2012 10:47:14 -0400, Leyne, Sean s...@broadviewsoftware.com wrote: -Original Message- From: Leyne, Sean [mailto:s...@broadviewsoftware.com] Sent: Viernes, 22 de Junio de 2012 17:18 They have a column named TIMESTAMP which is a reserved word in Firebird, and

Re: [Firebird-devel] Jira

2012-06-27 Thread Mark Rotteveel
On Wed, 27 Jun 2012 17:19:34 +0200, Mark Rotteveel m...@lawinegevaar.nl wrote: It would be interesting to see what other JDBC drivers report for the the DatabaseMetaData.getSQLKeywords() method. Jaybird explicitly does not include TIMESTAMP as that should already be a SQL-92 (and/or SQL:2003

Re: [Firebird-devel] Jira

2012-06-28 Thread Mark Rotteveel
to choose reserved word as a field's name, they wouldn't have had chance to reject it this way. People are inertial, you have to kick hard to make them moving. I have to say that this kind of attitude is toxic and certainly not the way to get people to help you. Mark -- Mark Rotteveel

Re: [Firebird-devel] Proposal Default Dialect 3

2012-07-06 Thread Mark Rotteveel
On Fri, 6 Jul 2012 09:22:13 +0300, marius adrian popa map...@gmail.com wrote: I propose that default dialect to be Dialect 3 and dropping support for dialect 1 in far and future Firebird 3.5.x/4.x for example (mark is as deprecated and it will not do anything when set) in python driver and

Re: [Firebird-devel] PROPOSAL FB 3.0: Ditch the NONE as default charset

2012-07-06 Thread Mark Rotteveel
On Fri, 06 Jul 2012 09:45:06 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: How about isc_create_database()? Should it follow the same rules? It probably should. But if we'd go this route, one more idea comes to mind. What about prohibiting NONE as a default database charset at all,

Re: [Firebird-devel] PROPOSAL FB 3.0: Ditch the NONE as default charset

2012-07-06 Thread Mark Rotteveel
On Fri, 06 Jul 2012 10:20:13 +0200, Dimitry Sibiryakov s...@ibphoenix.com wrote: I have a script which creates my tables in my own just created database or any existing user-choosen database. Because I can't predict default character set of such user database, all fields in this script

Re: [Firebird-devel] Evaluation of derived tables and CTE's

2012-07-13 Thread Mark Rotteveel
assume that will only work if both columns have an index. Mark -- Mark Rotteveel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how

[Firebird-devel] Conversion of CVS to Subversion

2012-07-14 Thread Mark Rotteveel
Subversion server, both of which are not really an option. Mark -- Mark Rotteveel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-14 Thread Mark Rotteveel
On 14-7-2012 17:19, Mark Rotteveel wrote: Now that Jaybird 2.2 is released we want to migrate the CVS client-java module to Subversion. Is there any documentation on how this was done for firebird? I have looked into some tools, but they either require a local CVS repository, or those tools

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-14 Thread Mark Rotteveel
On 14-7-2012 17:31, Dimitry Sibiryakov wrote: 14.07.2012 17:28, Mark Rotteveel wrote: I have looked into some tools, but they either require a local CVS repository, or those tools which support remote CVS require a local Subversion server, both of which are not really an option. IFAIR

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-15 Thread Mark Rotteveel
On 15-7-2012 13:30, Lester Caine wrote: Mark Rotteveel wrote: I don't want to make this a source control beauty contest:). DO you actually NEED to migrate from CVS? Dimitry did ask, and to be honest, in the absence of a better option on the DVCS front, staying with CVS is just as valid

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-15 Thread Mark Rotteveel
matter... Subversion uses ZLib compression in its protocol just like CVS does. The advantage in Subversion is that client - server also sends diffs where CVS sends the full file from client to server. Mark -- Mark Rotteveel

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-16 Thread Mark Rotteveel
On Mon, 16 Jul 2012 01:01:31 +0200, Roman Rokytskyy ro...@rokytskyy.de wrote: - should be integrated with Eclipse at least on the same level as CVS. The latest versions of Eclipse supports git and the Eclipse project itself has moved all their code to git, so I assume (without checking) that it

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-17 Thread Mark Rotteveel
On 16-7-2012 11:11, Pavel Cisar wrote: Hi, I did the conversion of main Firebird modules to SVN. Dne 14.7.2012 17:19, Mark Rotteveel napsal(a): Now that Jaybird 2.2 is released we want to migrate the CVS client-java module to Subversion. Is there any documentation on how this was done

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-21 Thread Mark Rotteveel
to those revisions. Now I am wondering whether I should assign a username to those revisions, and if so if I should assign my own SF username or another username (which username?). What do you think? Mark -- Mark Rotteveel

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-24 Thread Mark Rotteveel
As there are not replies as of yet, can I assume there is no problem to do this migration on Sunday 2012-08-05 (August fifth) between 12:00 and 16:00 UTC (14:00 and 18:00 Central European Summer Time)? Mark On 22-7-2012 15:25, Mark Rotteveel wrote: I finished the instructions and tested them

Re: [Firebird-devel] REMINDER: Jaybird migration to Subversion starts in 5 minutes

2012-08-05 Thread Mark Rotteveel
The migration of Jaybird to subversion will start in approximately 5 minutes. The Firebird subversion repository cannot be used during the migration. Once migration is completed another mail will be sent. Mark Rotteveel On 5-8-2012 13:01, Mark Rotteveel wrote: As announced two weeks ago, I

[Firebird-devel] Jaybird migration to Subversion completed

2012-08-05 Thread Mark Rotteveel
13:54, Mark Rotteveel wrote: The migration of Jaybird to subversion will start in approximately 5 minutes. The Firebird subversion repository cannot be used during the migration. Once migration is completed another mail will be sent. Mark Rotteveel -- Mark Rotteveel

Re: [Firebird-devel] Jaybird migration to Subversion completed

2012-08-05 Thread Mark Rotteveel
disastrously wrong :-) Thanks Paul V. and Paul R. ;) Mark -- Mark Rotteveel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers

Re: [Firebird-devel] Can someone add info how to backtrace core-3740

2012-08-08 Thread Mark Rotteveel
On Wed, 8 Aug 2012 14:16:47 +0200, Paul Beach pbe...@ibphoenix.com wrote: The question was when it will be increased the stack and if he can have a patch/build to try it

[Firebird-devel] Tracker down?

2012-08-20 Thread Mark Rotteveel
I can't seem to connect to tracker.firebirdsql.org, does anybody else have that problem? Mark -- Mark Rotteveel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security

Re: [Firebird-devel] Tracker down?

2012-08-20 Thread Mark Rotteveel
ms 115 ms95 ms 66.163.77.37 9 162 ms 133 ms 132 ms rc1ec-tge0-15-1-0.il.shawcable.net [66.163.76.23 8] 10 *** Time-out bij opdracht. Mark -- Mark Rotteveel -- Live Security

Re: [Firebird-devel] Tracker down?

2012-08-21 Thread Mark Rotteveel
On Mon, 20 Aug 2012 14:55:23 -0400, Leyne, Sean s...@broadviewsoftware.com wrote: On 20-8-2012 20:03, Leyne, Sean wrote: Mark, I can't seem to connect to tracker.firebirdsql.org, does anybody else have that problem? I have been able to connect without issues from a client location in

Re: [Firebird-devel] Handling NULL in XSQLVAR

2012-08-25 Thread Mark Rotteveel
On 25-8-2012 12:25, Dimitry Sibiryakov wrote: 25.08.2012 12:20, Mark Rotteveel wrote: I don't think that is entirely true Thinking is unreliable. Read this: // Make sure user has specified a data location (unless NULL) if (!xvar-sqldata !*null_ind (xvar-sqltype ~1) != SQL_NULL

Re: [Firebird-devel] Handling NULL in XSQLVAR

2012-08-29 Thread Mark Rotteveel
On 25-8-2012 11:49, Mark Rotteveel wrote: I have a question about handling NULL in XSQLVAR: Is it required to have sqldata set to null, or is setting sqlind to -1 sufficient? The reason I am asking is http://tracker.firebirdsql.org/browse/JDBC-271. When doing SELECT cast(? as varchar(1

Re: [Firebird-devel] Handling NULL in XSQLVAR

2012-08-29 Thread Mark Rotteveel
On 29-8-2012 21:41, Mark Rotteveel wrote: On 29-8-2012 21:31, Dimitry Sibiryakov wrote: 29.08.2012 21:01, Mark Rotteveel wrote: I have created CORE-3913 as I think it would be a good idea to have the value of sqlind be leading instead of the nullable bit when sending parameters from client

Re: [Firebird-devel] Handling NULL in XSQLVAR

2012-08-29 Thread Mark Rotteveel
On 29-8-2012 21:44, Dimitry Sibiryakov wrote: 29.08.2012 21:41, Mark Rotteveel wrote: Why would that break existing applications and lead to Access Violations? Read my comment in ticket. sqlind may be not initialized for non-nullable parameters. Yes, this is what you get from working

Re: [Firebird-devel] Handling NULL in XSQLVAR

2012-09-01 Thread Mark Rotteveel
On 30-8-2012 10:11, Alex Peshkoff wrote: On 08/29/12 23:53, Mark Rotteveel wrote: BTW: Out of curiosity: why is sqlind a pointer? Are there any other use cases for it being a pointer, because honestly I don't really see the point of having a pointer to a short in a structure like xsqlvar

Re: [Firebird-devel] Calculated field - is this expected behavior?

2012-09-15 Thread Mark Rotteveel
you mean it comes before or after the calculated field in the CREATE TABLE statement? Mark -- Mark Rotteveel -- How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how

Re: [Firebird-devel] Calculated field - is this expected behavior?

2012-09-15 Thread Mark Rotteveel
in the expression must exist before the column can be defined., but it is unclear if this applies to the definition order in the CREATE TABLE statement, or if it is just a statement of fact. Mark -- Mark Rotteveel

Re: [Firebird-devel] ERROR:operating system directive CreateFile failed

2012-10-04 Thread Mark Rotteveel
-specific message that explains what went wrong (eg creating temporary files), instead of why it failed (the low-level error message)? Mark -- Mark Rotteveel -- Don't let slow site performance ruin your business. Deploy

Re: [Firebird-devel] ERROR:operating system directive CreateFile failed

2012-10-06 Thread Mark Rotteveel
, of the above attempts to access a non-existent or restricted file, nothing(!) is logged in firebird.log. Mark -- Mark Rotteveel -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app

[Firebird-devel] Servicemanager output isc_spb_rpr_list_limbo_trans

2012-10-10 Thread Mark Rotteveel
Does anyone have a good description of the output of the servicemanager repair option isc_spb_rpr_list_limbo_trans. Or if no such description exists, could someone point me to the code that generates that output? I need this to fix http://tracker.firebirdsql.org/browse/JDBC-266 Mark -- Mark

[Firebird-devel] Sourceforge services down

2012-10-23 Thread Mark Rotteveel
Various services of SourceForge (including CVS and Subversion) are down: https://sourceforge.net/blog/various-sourceforge-services-down/ -- Mark Rotteveel -- Everyone hates slow websites. So do we. Make your web apps

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Mark Rotteveel
On Wed, 31 Oct 2012 08:41:39 +0100, Paul Beach pbe...@ibphoenix.com wrote: I have no idea what to do (well, actually I have a very easy and good one, you know, it's to wipe dialect 1/2). I'd hate to split a single field in two to support something which should be removed +10 years ago.

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Mark Rotteveel
On Wed, 31 Oct 2012 13:02:50 +0400, Dmitry Yemanov firebi...@yandex.ru wrote: 31.10.2012 12:50, Thomas Steinmaurer wrote: That said, I'm against the idea in general ;-) Sorry, I had intended to write: That said, I'm NOT against the idea in general as it should obviously be wiped out

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Mark Rotteveel
On Wed, 31 Oct 2012 14:39:13 +0400, Dmitry Yemanov firebi...@yandex.ru wrote: 31.10.2012 14:17, Alex Peshkoff wrote: what about having 2 32-bit fields in ODS12? In ODS13 we will remove that hack I don't think we can remove system fields at all, at least without breaking an unknown number

Re: [Firebird-devel] Ubuntu builds

2012-11-12 Thread Mark Rotteveel
On Mon, 12 Nov 2012 11:03:46 -0300, Jorge Andrés Brugger lis...@dasu.com.ar wrote: I know Mariuz maintains a repo for Ubuntu, but AFAIK it´s not official ... Why? Should be nice to have Ubunt/Debian releases from firebirdsql.org ... What does 'official' mean to you, and how would it be

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-13 Thread Mark Rotteveel
On Tue, 13 Nov 2012 14:18:22 +, Poul Dige p...@tabulex.dk wrote: I could put a screen dump here of the Windows 2008R2/63 task manager with AMD Opteron 6274, 2x16 core running FB2.5.1 SC/32 bit (due to some 32 bit UDF). I don't know if you are interested at a gaze. We see exactly the same

Re: [Firebird-devel] Servicemanager output isc_spb_rpr_list_limbo_trans

2012-11-16 Thread Mark Rotteveel
On 11-10-2012 09:39, Alex Peshkoff wrote: On 10/10/12 22:53, Mark Rotteveel wrote: Does anyone have a good description of the output of the servicemanager repair option isc_spb_rpr_list_limbo_trans. Or if no such description exists, could someone point me to the code that generates

Re: [Firebird-devel] Servicemanager output isc_spb_rpr_list_limbo_trans

2012-11-16 Thread Mark Rotteveel
the transaction id on a newly created database or to even enforce a specific transaction id without resorting to iteratively creating a large number of transactions? The original code had some oddities in how it decoded integers (which actually contributed to the problem). Mark -- Mark Rotteveel

  1   2   3   4   5   6   7   8   9   10   >