[Firebird-devel] ODP: SQL profiler

[Karol Bieniaszewski]

Really great feature 
but i am worried about the title „package (FB 5.0)”.
Is it for FB4 or for the future version FB5?

regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] SQL profiler

[Adriano dos Santos Fernandes]

Hi!

I've added SQL profiler to the previously PSQL profiler pull request.

See updated readme:
https://github.com/FirebirdSQL/firebird/blob/59abcdb8b97b794bf42c943c45da765100abcd4b/doc/sql.extensions/README.profiler.md

SQL profile data is put in RDB$PROFILE_RECORD_SOURCE_STATS which
reflects each node of an explained plan.

I've added separate columns for OPEN and FETCH stats.

They are important because SORT and GROUP, for example, has high open
time and fast fetches while simple record sources has fast open.


Adriano



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6438) ISQL: bad headers when text columns has >= 80 characters

[Adriano dos Santos Fernandes (JIRA)]

ISQL: bad headers when text columns has >= 80 characters


 Key: CORE-6438
 URL: http://tracker.firebirdsql.org/browse/CORE-6438
 Project: Firebird Core
  Issue Type: Bug
  Components: ISQL
Affects Versions: 3.0.7, 4.0 Beta 2
Reporter: Adriano dos Santos Fernandes


The count of "=" characters is generated incorrect when the declared column 
length is >= 80.

Test case:

OK:

SQL> select 
'1234567890123456789012345678901234567890123456789012345678901234567890123456789'
 x, 1 y from rdb$database;

X   
   Y 
=== 
 
1234567890123456789012345678901234567890123456789012345678901234567890123456789 
   1 

Bad:

SQL> select 
'12345678901234567890123456789012345678901234567890123456789012345678901234567890'
 x, 1 y from rdb$database;

X   
Y 
=== 
 
12345678901234567890123456789012345678901234567890123456789012345678901234567890
1 


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel