[Firebird-devel] [FB-Tracker] Created: (CORE-4489) Statement already has a cursor assigned

Affects Versions: 3.0 Alpha 2 Environment: Win XP 32-bit Reporter: Jason Wharton Priority: Blocker When I run the IB Objects regression testing app I am getting several tests that fail due to this error in the title when a statement handle tries to open a cursor after

[Firebird-devel] [FB-Tracker] Created: (CORE-3987) CHECK CONSTRAINT with sub-select fails to raise exception when it should

Issue Type: Bug Components: Engine Affects Versions: 2.5.2 Environment: Win 7 64 bit Reporter: Jason Wharton I create two tables and a check constraint in one table that looks for values existing in another table. If the other table is empty it allows the check

[Firebird-devel] [FB-Tracker] Created: (CORE-3985) Cannot create or alter stored procedure with NUMERIC(15, 5) in Dialect 1 database via ExecuteImmediate, but can via DSQL

. Reporter: Jason Wharton I have a case where I can execute a statement via a normal DSQL just fine, but it fails when I take the same statement and execute it via the API's execute immediate facility. Here is the statement: CREATE OR ALTER PROCEDURE BAD_NUMERIC ( BAD_IN NUMERIC

[Firebird-devel] [FB-Tracker] Created: (CORE-3765) VARCHAR ARRAY of UTF8 Charset fails

Environment: Win 7 64 bit and 32 bit Reporter: Jason Wharton Priority: Critical When I connect via UTF8 Charset I get an error: (From the IBO SQL trace monitor) /*--- GET SLICE ARRAY ID (129, 501) ARRAY DTYPE 37 ARRAY SCALE 0 ARRAY LENGTH 15 ARRAY DIMENSIONS

[Firebird-devel] [FB-Tracker] Created: (CORE-3730) isc_dsql_exec_immed2() loses input parameter value with RETURNING clause

Issue Type: Bug Environment: Any Reporter: Jason Wharton Attachments: ExecuteImmed2_InsertWithReturningClause.zip A value passed in to insert a record is lost when the RETURNING clause is used via the EXECUTE IMMEDIATE api call isc_dsql_exec_immed2(). -- This message

[Firebird-devel] [FB-Tracker] Created: (CORE-3723) FOR UPDATE OF list does not work with columns qualified with a relation alias.

Issue Type: Bug Components: Engine Affects Versions: 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0 Environment: Any environment Reporter: Jason Wharton The following query fails: SELECT R.RDB$DESCRIPTION , R.RDB

[Firebird-devel] [FB-Tracker] Created: (CORE-3716) ARRAY of VARCHAR not utilizing the length indicator byte pair

Components: Engine Environment: Any environment. Reporter: Jason Wharton When working with an array of VARCHAR the two-byte length indicator seems to be working in some other way than a regular VARCHAR buffer works via the XSQLVAR structure. The first two bytes of the data

[Firebird-devel] [FB-Tracker] Created: (CORE-3709) RETURNING clause does not work on an UPDATE statement with WHERE CURRENT OF ...

Issue Type: Bug Components: Engine Affects Versions: 2.5.1, 2.1.4, 2.5.0, 2.0.6, 2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0 Environment: Win7 64 bit Reporter: Jason Wharton Priority: Critical Here is the trace log of my session. The cursor named

[Firebird-devel] [FB-Tracker] Created: (CORE-3702) Excessive use of memory when doing multiple connection attach/detach calls.

Issue Type: Bug Components: API / Client Library Affects Versions: 2.5.1 Environment: Win7 64bit (using 32bit client) Reporter: Jason Wharton Priority: Critical Here is a Delphi sample app that will reproduce this problem. Start a fresh new

[Firebird-devel] [FB-Tracker] Created: (CORE-3695) EXECUTE BLOCK and STORED PROCEDURE LANGUAGE and singleton execution

: Improvement Components: Engine Affects Versions: 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0, 2.0.7, 3.0 Alpha 1, 2.1.5, 2.5.2, 3.0 Beta 1, 2.5.3, 2.1.6, 3.0.0 Environment: This is not an environment sensitive issue. Reporter: Jason

[Firebird-devel] [FB-Tracker] Created: (CORE-3680) EXECUTE BLOCK statement and ISC_DSQL_EXECUTE2() problem.

Components: API / Client Library, Engine Affects Versions: 2.5.1 Environment: Using IB Objects in a Win32 environment. Reporter: Jason Wharton It seems that Firebird 2.5 has an issue where repeated executions of an EXECUTE BLOCK statement are not possible via ISC_DSQL_EXECUTE2

Re: [Firebird-devel] UTF8 Encoding and Decoding

Adriano, PS. Good questions Geoff! > > While on this sort of subject are you able to offer any > > information about what happens to API text such as SQL > > statements and the like) sent to the server? (And details > > like relation names etc returned to the client.) > > > They're interpreted i

Re: [Firebird-devel] isc_dsql_exec_immed2 and memory corruption

As an additional note, I believe it could have something to do with the fact that the input parameters are nil and the output parameters are assigned. I'm going to try and see if passing in a dummy input parameter will help to provide a workaround. I say this because elsewhere I use this without

[Firebird-devel] [FB-Tracker] Created: (CORE-3459) String literal format parsing enhancement.

Reporter: Jason Wharton Priority: Minor I am working with data that has control characters in it that makes it so that I cannot use the script component in my components effectively. I wrote some routines in Delphi that produce strings I can work with in Pascal but unfortuantely

[Firebird-devel] [FB-Tracker] Created: (CORE-3452) Query STARTING WITH :Param returns inconsistent result depending upon ORDER BY clause

: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.1.4, 2.5.0, 1.5.6, 2.1.3, 2.1.2 Environment: Using IB Objects on a Win XP machine, thus 32 bit. Reporter: Jason Wharton I have a query that is shown in the SQL trace below that has an