Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010638Openbravo ERP01. General setuppublic2009-09-17 09:012009-12-11 00:00
Reporterwalle 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.50MP3 
Target VersionFixed in Version2.50MP10 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010638: SQL Query - 1 record result missing
Descriptionon querying with SQL Query the first result is missing, when
1 explicit record is searched it shows only the column description
but not the result
Steps To Reproduce..
Proposed Solution.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-17 09:01walleNew Issue
2009-09-17 09:01walleAssigned To => rafaroda
2009-09-18 08:11rafarodaNote Added: 0020172
2009-09-18 08:11rafarodaStatusnew => feedback
2009-09-18 08:11rafarodaNote Edited: 0020172
2009-09-29 23:31psarobeOBNetwork customer => No
2009-09-29 23:31psarobeAssigned Torafaroda => shuehner
2009-09-30 08:31walleNote Added: 0020576
2009-09-30 12:40shuehnerNote Added: 0020588
2009-09-30 12:40shuehnerStatusfeedback => new
2009-09-30 19:37psarobeStatusnew => scheduled
2009-09-30 19:37psarobefix_in_branch => pi
2009-11-23 16:18hgbotCheckin
2009-11-23 16:18hgbotNote Added: 0022116
2009-11-23 16:18hgbotStatusscheduled => resolved
2009-11-23 16:18hgbotResolutionopen => fixed
2009-11-23 16:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/882e0f7a9b8f75559fb5aa02c29aa3f43ab7939a [^]
2009-12-04 09:14hudsonbotCheckin
2009-12-04 09:14hudsonbotNote Added: 0022413
2009-12-10 19:11mtaalNote Added: 0022663
2009-12-10 19:11mtaalStatusresolved => closed
2009-12-10 19:11mtaalFixed in Version => 2.50MP10
2009-12-11 00:00anonymoussf_bug_id0 => 2912310

Notes
(0020172)
rafaroda   
2009-09-18 08:11   
Can you please provide some steps to reproduce this issue? http://wiki.openbravo.com/wiki/Bug_Reporting_Guidelines [^]

Thanks.
(0020576)
walle   
2009-09-30 08:31   
Hi...

This is easy to reproduce, you need one small and easy sql statement
(pay attention that sampledata are installed)

select * from m_product where m_product_id = '1000007'
no result, only the header are visualized

select * from m_product where m_product_id in ('1000007', '1000008')
only one line will be selected, not two

from my point of view the counter of the records will reach the end 1 record
to early because of the column header

Please check, thanks
Walter
(0020588)
shuehner   
2009-09-30 12:40   
The result display does always leave out the first record shown which can be seen by adding an explicit order by to the example queries.
(0022116)
hgbot   
2009-11-23 16:18   
Repository: erp/devel/pi
Changeset: 882e0f7a9b8f75559fb5aa02c29aa3f43ab7939a
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Nov 23 16:18:12 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/882e0f7a9b8f75559fb5aa02c29aa3f43ab7939a [^]

Fixed 10638: do not skip first row in output

---
M src/org/openbravo/erpCommon/ad_forms/SQLExecutor.java
---
(0022413)
hudsonbot   
2009-12-04 09:14   
---
A changeset related to this issue has passed a series of tests and has been promoted to main:

Changeset: http://code.openbravo.com/erp/devel/main/rev/f6bc559b1872 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
---
(0022663)
mtaal   
2009-12-10 19:11   
Tested and confirmed working.