Thursday, 15 September 2016

[firebird-support] Problem querying MON$STATEMENTS table

 

Hello

 

I have a problem when i querying the MON$STATEMENS table on Server 2.5.5 and also 2.5.6

 

Do the follow steps:

Open a connection to the database, then start a transaction an open a table to show the content and keep it open/active Now run the follow statement "SELECT * FROM MON$STATEMENS"

The Row that should shows you the active query are not correct!

The column MON$STATE shows allways Zero and also the columns MON$TRANSACTION_ID and MON$TIMESTAMP are also allways NULL!!

The Server 3.0.1 are not affected on this problem.

 

The follow databases with charset are not working (tested) NONE, WIN1250, ISO8859_1

 

A database with charset WIN1251 are working well.

 

 

May this could be a bug.

 

 

Best Regards

Gregor

__._,_.___

Posted by: gregorkobler@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment