Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010638
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2009-09-17 09:012009-12-11 00:00
ReporterwalleView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.50MP10
StatusclosedFix in branchpiFixed in SCM revision882e0f7a9b8f
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010638: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0020172)
rafaroda (developer)
2009-09-18 08:11
edited on: 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 (reporter)
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 (administrator)
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 (developer)
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 (developer)
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 (manager)
2009-12-10 19:11

Tested and confirmed working.

- Issue History
Date Modified Username Field Change
2009-09-17 09:01 walle New Issue
2009-09-17 09:01 walle Assigned To => rafaroda
2009-09-18 08:11 rafaroda Note Added: 0020172
2009-09-18 08:11 rafaroda Status new => feedback
2009-09-18 08:11 rafaroda Note Edited: 0020172
2009-09-29 23:31 psarobe Assigned To rafaroda => shuehner
2009-09-30 08:31 walle Note Added: 0020576
2009-09-30 12:40 shuehner Note Added: 0020588
2009-09-30 12:40 shuehner Status feedback => new
2009-09-30 19:37 psarobe Status new => scheduled
2009-09-30 19:37 psarobe fix_in_branch => pi
2009-11-23 16:18 hgbot Checkin
2009-11-23 16:18 hgbot Note Added: 0022116
2009-11-23 16:18 hgbot Status scheduled => resolved
2009-11-23 16:18 hgbot Resolution open => fixed
2009-11-23 16:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/882e0f7a9b8f75559fb5aa02c29aa3f43ab7939a [^]
2009-12-04 09:14 hudsonbot Checkin
2009-12-04 09:14 hudsonbot Note Added: 0022413
2009-12-10 19:11 mtaal Note Added: 0022663
2009-12-10 19:11 mtaal Status resolved => closed
2009-12-10 19:11 mtaal Fixed in Version => 2.50MP10
2009-12-11 00:00 anonymous sf_bug_id 0 => 2912310


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker