firebird-net-provider

[Firebird-net-provider] Problem with rdb$ tables - possible bug in rc1

[Tomasz B. <t.b...@cb...>]

Hi,

I found a bug in Provider 1.5 RC1 version.
I seems to affect only queries to system tables.
The following code:
<code>
using System;
using System.Data;
//Provider 1.1 build: 1.0.1241.28320 - ok
//Provider 1.5 RC1 build: 1.5.1437.22333 - bug
using FirebirdSql.Data.Firebird;
namespace BugInProvider
{
  class Class1
    {
	static void Main(string[] args)
	{
	string ConnectionString = "connectionstring"

     //query taken from DbSchemaFactory 
     string strSql = "SELECT rdb$relation_name AS TABLE_NAME, rdb$view_blr
AS TABLE_TYPE, rdb$system_flag AS SYSTEM_TABLE, rdb$owner_name AS
OWNER_NAME, rdb$description AS DESCRIPTION FROM rdb$relations ORDER BY
rdb$system_flag, rdb$owner_name, rdb$relation_name";

	FbConnection cn = new FbConnection(ConnectionString);
	cn.Open();
	FbCommand cmd = new FbCommand(strSql,cn,cn.BeginTransaction());
	FbDataReader rdr = cmd.ExecuteReader();
	while (rdr.Read())
	{
	   System.Console.WriteLine("Table_name: {0}",rdr.GetValue(0));
	}
	rdr.Close();
	cmd.Transaction.Rollback();
	cn.Close();
	System.Console.ReadLine();
		
}
}
 }
</code>
Produces output like this:

Table_name: RDB$FILTER
Table_name: RDB$FORMAT
Table_name: RDB$FUNCTI
Table_name: RDB$FUNCTI
Table_name: RDB$GENERA
Table_name: RDB$INDEX_
Table_name: RDB$INDICE

The size is trimmed to 10 chars

With a Provider 1.1 build: 1.0.1241.28320 the results are ok:

Table_name: RDB$FILTERS
Table_name: RDB$FORMATS
Table_name: RDB$FUNCTIONS
Table_name: RDB$FUNCTION_ARGUMENTS
Table_name: RDB$GENERATORS
Table_name: RDB$INDEX_SEGMENTS
Table_name: RDB$INDICES

btw. How to use restrictions in FbConnection.GetDbSchemaTable?

Best regards
PS. Sorry for English.
--
Tomasz (Tom) Bogucki 
Fundacja CBOS
Warsaw,Poland

Re: [Firebird-net-provider] Problem with rdb$ tables - possible bug in rc1

[<car...@te...>]

Hello:

> With a Provider 1.1 build: 1.0.1241.28320 the results are ok:

Fixed in CVS, the problem was in a change i have done for try to adjust 
the string readed to the number of real chars in the field character 
set, but this is not valid in the case of System Tables that are 
supposed to be UNICODE_FSS but they report a bad number of bytes (1 per 
character instead of 3 per character).

> btw. How to use restrictions in FbConnection.GetDbSchemaTable?

They works in very similar way to the OleDB provider ones, an example:

FbConnection connection = new FbConnection(connectionString);
connection.Open();

// Retrieve the list of SYSTEM TABLES
// Restrictions allowed:
//	TABLE_NAME
//	TABLE_TYPE
//	SYSTEM TABLE
DataTable schema = connection.GetDbSchemaTable(
	FbDbSchemaType.Tables,
	new object[] {null, null, 1});

foreach (DataRow row in schema.Rows)
{
	foreach (DataColumn column in schema.Columns)
	{
		Console.Write("{0} \t", row[column.ColumnName]);
	}
	Console.WriteLine("");
}

connection.Close();




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain