Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010638 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | minor | always | 2009-09-17 09:01 | 2009-12-11 00:00 | |||
| Reporter | walle | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50MP10 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 882e0f7a9b8f | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.50MP3 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010638: SQL Query - 1 record result missing | |||||||
| Description | on 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 | . | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0020172) rafaroda (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 2009-12-10 19:11 |
Tested and confirmed working. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |