| Subject | RE: [IBO] Bugs: Strange query result that involve timestamp field with date params |
|---|---|
| Author | IBO Support List |
| Post date | 2012-06-07T01:29:54Z |
Here is the text comparison of the SQL monitor that shows the difference:
Text Compare
Produced: 2012/06/06 07:28:53 PM
Mode: All
File:
/*---
=
/*---
EXECUTE STATEMENT
EXECUTE STATEMENT
TR_HANDLE = 9
TR_HANDLE = 9
STMT_HANDLE = 8
STMT_HANDLE = 8
PARAMS = [ Version 1 SQLd 6 SQLn 6
PARAMS = [ Version 1 SQLd 6 SQLn 6
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 >
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 >
[TGL1] = <NULL> < Type: 511 SubType: 0 Len: 8 Scale: 0 Data: 0212C0EE >
<>
[TGL1] = '12 Jun 2011' < Type: 511 SubType: 0 Len: 8 Scale: 0 Data:
0212C0EE >
[TGL2] = <NULL> < Type: 511 SubType: 0 Len: 8 Scale: 0 Data: 0212C0F8 >
[TGL2] = '01 Jun 2013' < Type: 511 SubType: 0 Len: 8 Scale: 0 Data:
0212C0F8 >
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
=
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 > ]
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 > ]
----*/
----*/
/*---
/*---
OPEN CURSOR
OPEN CURSOR
STMT_HANDLE = 8
STMT_HANDLE = 8
NAME = C7066056054146233
NAME = C7066056054146233
----*/
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '14 Jan 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[TANGGAL] = '14 Jan 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 900000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[REGISTRASI] = 900000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[CALLR] = 900000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '14 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[TANGGAL] = '14 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 800000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[REGISTRASI] = 800000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[CALLR] = 800000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
-+
[TANGGAL] = '20 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
[CALLR] = 295000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
/*---
FETCH
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
=
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
----*/
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
ERRCODE = 100
ERRCODE = 100
----*/
----*/
/*---
/*---
CLOSE CURSOR
CLOSE CURSOR
STMT_HANDLE = 8
STMT_HANDLE = 8
----*/
----*/
What I conclude from this is you are using multiple parameters with the same
name and IBO is not properly binding all of the parameters. I should be able
to fix this.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Cipto
Sent: 22 May 2012 08:05 PM
To: IBObjects
Subject: [IBO] Bugs: Strange query result that involve timestamp field with
date params
I already upload an example Delphi 7 source code to reproduce that bug in
the files folder:
/Bug Testing Applications/IBO Bugs Cipto22May2012.rar
In that file there is 2 bugs that I want to reported, and for this subject
of email, the bugs is on the "Bugs 2" tabsheet.
I already put a little explanation on that source code.
Here is the little description about that bugs:
The result of the query for 1'st execution is wrong and when I refresh the
same query again the result will true. So there is inconsistency here about
the result (the result record is different)
TIA
[Non-text portions of this message have been removed]
Text Compare
Produced: 2012/06/06 07:28:53 PM
Mode: All
File:
/*---
=
/*---
EXECUTE STATEMENT
EXECUTE STATEMENT
TR_HANDLE = 9
TR_HANDLE = 9
STMT_HANDLE = 8
STMT_HANDLE = 8
PARAMS = [ Version 1 SQLd 6 SQLn 6
PARAMS = [ Version 1 SQLd 6 SQLn 6
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 >
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 >
[TGL1] = <NULL> < Type: 511 SubType: 0 Len: 8 Scale: 0 Data: 0212C0EE >
<>
[TGL1] = '12 Jun 2011' < Type: 511 SubType: 0 Len: 8 Scale: 0 Data:
0212C0EE >
[TGL2] = <NULL> < Type: 511 SubType: 0 Len: 8 Scale: 0 Data: 0212C0F8 >
[TGL2] = '01 Jun 2013' < Type: 511 SubType: 0 Len: 8 Scale: 0 Data:
0212C0F8 >
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
=
[TGL1] = '12 Jun 2011' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E2 >
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 > ]
[TGL2] = '01 Jun 2013' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0212C0E8 > ]
----*/
----*/
/*---
/*---
OPEN CURSOR
OPEN CURSOR
STMT_HANDLE = 8
STMT_HANDLE = 8
NAME = C7066056054146233
NAME = C7066056054146233
----*/
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '14 Jan 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[TANGGAL] = '14 Jan 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 900000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[REGISTRASI] = 900000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[CALLR] = 900000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
> ][CALLR] = 900000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
> ]----*/
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '14 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[TANGGAL] = '14 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 800000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[REGISTRASI] = 800000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B530 >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[CALLR] = 800000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
> ][CALLR] = 800000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
> ]----*/
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
-+
[TANGGAL] = '20 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
>[VISIT] = 295000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A
>[TRAINING] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B544 >
[CALLR] = 295000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data: 0215B54E
> ]----*/
/*---
FETCH
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
=
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
>[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
>[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
----*/
----*/
/*---
/*---
FETCH
FETCH
STMT_HANDLE = 8
STMT_HANDLE = 8
FIELDS = [ Version 1 SQLd 5 SQLn 5
FIELDS = [ Version 1 SQLd 5 SQLn 5
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[TANGGAL] = '21 May 2012' < Type: 571 SubType: 0 Len: 4 Scale: 0 Data:
0215B52A >
[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
>[REGISTRASI] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B530
>[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[VISIT] = 0 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data: 0215B53A >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[TRAINING] = 3000000 < Type: 581 SubType: 1 Len: 8 Scale: -2 Data:
0215B544 >
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
[CALLR] = 3000000 < Type: 581 SubType: 0 Len: 8 Scale: -2 Data:
0215B54E > ]
ERRCODE = 100
ERRCODE = 100
----*/
----*/
/*---
/*---
CLOSE CURSOR
CLOSE CURSOR
STMT_HANDLE = 8
STMT_HANDLE = 8
----*/
----*/
What I conclude from this is you are using multiple parameters with the same
name and IBO is not properly binding all of the parameters. I should be able
to fix this.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Cipto
Sent: 22 May 2012 08:05 PM
To: IBObjects
Subject: [IBO] Bugs: Strange query result that involve timestamp field with
date params
I already upload an example Delphi 7 source code to reproduce that bug in
the files folder:
/Bug Testing Applications/IBO Bugs Cipto22May2012.rar
In that file there is 2 bugs that I want to reported, and for this subject
of email, the bugs is on the "Bugs 2" tabsheet.
I already put a little explanation on that source code.
Here is the little description about that bugs:
The result of the query for 1'st execution is wrong and when I refresh the
same query again the result will true. So there is inconsistency here about
the result (the result record is different)
TIA
[Non-text portions of this message have been removed]