Hello 

Sent from Yahoo Mail. Get the app 

    On Friday, September 16, 2016 3:47 AM, "Helen Borrie hele...@iinet.net.au 
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
 

     Friday, September 16, 2016, 12:02:28 AM, Gregor Kobler wrote:

> 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!
Open output set <> active query.
Once the SELECT statement has finished fetching, its state is no
longer active...it becomes "idle".
> 
> The column MON$STATE shows allways Zero
Zero is the "idle" state. It will go to "active" (1) next time the
cursor restarts.

> and also the columns
> MON$TRANSACTION_ID and MON$TIMESTAMP are also allways NULL!!

Both of those fields will hold values only while the statement is
active. A statement that is idle is not active.
> 
> 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.

If you suspect a bug, please try to give a proper description of what
you mean by "working well" and "not working" and post it, with your
statements, to firebird-devel. Also give the build number of the
snapshot that you refer to as "Server 3.0.1", as these snapshots are
refreshed very regularly.

The core devs have been working pretty solidly on Fb3 bugs over the
past 3 months so you should be able to discover what kind of a problem
(if any) you are actually observing and whether it is fixed.

HB

  #yiv0145561509 #yiv0145561509 -- #yiv0145561509ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0145561509 
#yiv0145561509ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0145561509 
#yiv0145561509ygrp-mkp #yiv0145561509hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0145561509 #yiv0145561509ygrp-mkp #yiv0145561509ads 
{margin-bottom:10px;}#yiv0145561509 #yiv0145561509ygrp-mkp .yiv0145561509ad 
{padding:0 0;}#yiv0145561509 #yiv0145561509ygrp-mkp .yiv0145561509ad p 
{margin:0;}#yiv0145561509 #yiv0145561509ygrp-mkp .yiv0145561509ad a 
{color:#0000ff;text-decoration:none;}#yiv0145561509 #yiv0145561509ygrp-sponsor 
#yiv0145561509ygrp-lc {font-family:Arial;}#yiv0145561509 
#yiv0145561509ygrp-sponsor #yiv0145561509ygrp-lc #yiv0145561509hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0145561509 
#yiv0145561509ygrp-sponsor #yiv0145561509ygrp-lc .yiv0145561509ad 
{margin-bottom:10px;padding:0 0;}#yiv0145561509 #yiv0145561509actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0145561509 
#yiv0145561509activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0145561509
 #yiv0145561509activity span {font-weight:700;}#yiv0145561509 
#yiv0145561509activity span:first-child 
{text-transform:uppercase;}#yiv0145561509 #yiv0145561509activity span a 
{color:#5085b6;text-decoration:none;}#yiv0145561509 #yiv0145561509activity span 
span {color:#ff7900;}#yiv0145561509 #yiv0145561509activity span 
.yiv0145561509underline {text-decoration:underline;}#yiv0145561509 
.yiv0145561509attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0145561509 .yiv0145561509attach div a 
{text-decoration:none;}#yiv0145561509 .yiv0145561509attach img 
{border:none;padding-right:5px;}#yiv0145561509 .yiv0145561509attach label 
{display:block;margin-bottom:5px;}#yiv0145561509 .yiv0145561509attach label a 
{text-decoration:none;}#yiv0145561509 blockquote {margin:0 0 0 
4px;}#yiv0145561509 .yiv0145561509bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0145561509 
.yiv0145561509bold a {text-decoration:none;}#yiv0145561509 dd.yiv0145561509last 
p a {font-family:Verdana;font-weight:700;}#yiv0145561509 dd.yiv0145561509last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0145561509 
dd.yiv0145561509last p span.yiv0145561509yshortcuts 
{margin-right:0;}#yiv0145561509 div.yiv0145561509attach-table div div a 
{text-decoration:none;}#yiv0145561509 div.yiv0145561509attach-table 
{width:400px;}#yiv0145561509 div.yiv0145561509file-title a, #yiv0145561509 
div.yiv0145561509file-title a:active, #yiv0145561509 
div.yiv0145561509file-title a:hover, #yiv0145561509 div.yiv0145561509file-title 
a:visited {text-decoration:none;}#yiv0145561509 div.yiv0145561509photo-title a, 
#yiv0145561509 div.yiv0145561509photo-title a:active, #yiv0145561509 
div.yiv0145561509photo-title a:hover, #yiv0145561509 
div.yiv0145561509photo-title a:visited {text-decoration:none;}#yiv0145561509 
div#yiv0145561509ygrp-mlmsg #yiv0145561509ygrp-msg p a 
span.yiv0145561509yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0145561509 
.yiv0145561509green {color:#628c2a;}#yiv0145561509 .yiv0145561509MsoNormal 
{margin:0 0 0 0;}#yiv0145561509 o {font-size:0;}#yiv0145561509 
#yiv0145561509photos div {float:left;width:72px;}#yiv0145561509 
#yiv0145561509photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0145561509 
#yiv0145561509photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0145561509
 #yiv0145561509reco-category {font-size:77%;}#yiv0145561509 
#yiv0145561509reco-desc {font-size:77%;}#yiv0145561509 .yiv0145561509replbq 
{margin:4px;}#yiv0145561509 #yiv0145561509ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0145561509 #yiv0145561509ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0145561509 
#yiv0145561509ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0145561509 
#yiv0145561509ygrp-mlmsg select, #yiv0145561509 input, #yiv0145561509 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0145561509 
#yiv0145561509ygrp-mlmsg pre, #yiv0145561509 code {font:115% 
monospace;}#yiv0145561509 #yiv0145561509ygrp-mlmsg * 
{line-height:1.22em;}#yiv0145561509 #yiv0145561509ygrp-mlmsg #yiv0145561509logo 
{padding-bottom:10px;}#yiv0145561509 #yiv0145561509ygrp-msg p a 
{font-family:Verdana;}#yiv0145561509 #yiv0145561509ygrp-msg 
p#yiv0145561509attach-count span {color:#1E66AE;font-weight:700;}#yiv0145561509 
#yiv0145561509ygrp-reco #yiv0145561509reco-head 
{color:#ff7900;font-weight:700;}#yiv0145561509 #yiv0145561509ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv0145561509 #yiv0145561509ygrp-sponsor 
#yiv0145561509ov li a {font-size:130%;text-decoration:none;}#yiv0145561509 
#yiv0145561509ygrp-sponsor #yiv0145561509ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0145561509 
#yiv0145561509ygrp-sponsor #yiv0145561509ov ul {margin:0;padding:0 0 0 
8px;}#yiv0145561509 #yiv0145561509ygrp-text 
{font-family:Georgia;}#yiv0145561509 #yiv0145561509ygrp-text p {margin:0 0 1em 
0;}#yiv0145561509 #yiv0145561509ygrp-text tt {font-size:120%;}#yiv0145561509 
#yiv0145561509ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv0145561509 

   
  • [firebird-s... gregorkob...@yahoo.com [firebird-support]
    • Re: [f... Helen Borrie hele...@iinet.net.au [firebird-support]
      • Re... monteropetronila...@yahoo.com [firebird-support]
      • AW... 'Gregor Kobler' g...@gksoft.ch [firebird-support]
        • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
          • ... 'Gregor Kobler' g...@gksoft.ch [firebird-support]
          • ... 'Gregor Kobler' g...@gksoft.ch [firebird-support]
        • ... Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
          • ... 'Gregor Kobler' g...@gksoft.ch [firebird-support]
            • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
              • ... 'Gregor Kobler' g...@gksoft.ch [firebird-support]
                • ... fabia...@itbizolutions.com.au [firebird-support]
                • ... hv...@users.sourceforge.net [firebird-support]

Reply via email to