Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0007315

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] Z. Others

major

have not tried

2009-02-02 14:27

2009-04-21 12:39

Reporter

shuehner

View Status

public

Assigned To

dalsasua

Priority

normal

Resolution

fixed

Fixed in Version

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

PostgreSQL

Java version

OS Version

Database version

Ant version

Product Version

2.40MP1

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0007315: Invalid substr index (=0) in SQL query.

Description

We have several occurences of substr(<some string>,0,<length>) in the codebase. The first parameter is 1-based per SQL spec and a value of 0 does not work as expected on postgres.

List of affected files on both 2.40 and trunk:

- src-db/database/model/functions/C_COMMISSION_PROCESS.xml (2 times)
- src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql
- src/org/openbravo/erpCommon/ad_forms/InitialOrgSetup_data.xsql (trunk only)

More Files covered by different issues:

- src/org/openbravo/erpCommon/ad_forms/FileImport_data.xsql (7130, function is unused)
- src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql (7129, already resolved)

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0007129		closed	shuehner	Import accounts does not import element level on postgresql
related to	feature request	0007130		closed	shuehner	Invalid substr index in SQL query in used parse-method of FileImport_data.xsql
related to	defect	0007100		closed	dalsasua	While Importing Accounts Account type is coming as "Not found"
depends on	backport	0007411		closed	dalsasua	Invalid substr index (=0) in SQL query.

Notes
(0013212) svnbot (reporter) 2009-02-06 11:35	Repository: openbravo Revision: 12880 Author: davidalsasua Date: 2009-02-06 11:35:19 +0100 (Fri, 06 Feb 2009) Fixes Bug 0007315: Invalid substr index (=0) in SQL query. --- U trunk/src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql U trunk/src/org/openbravo/erpCommon/ad_forms/InitialOrgSetup_data.xsql U trunk/src-db/database/model/functions/C_COMMISSION_PROCESS.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12880&sc=1 [^]

(0013214) svnbot (reporter) 2009-02-06 11:42	Repository: openbravo Revision: 12882 Author: davidalsasua Date: 2009-02-06 11:42:41 +0100 (Fri, 06 Feb 2009) Fixes Bug 0007315: Invalid substr index (=0) in SQL query. --- U trunk/src-db/database/model/functions/C_COMMISSION_PROCESS.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12882&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2009-02-02 14:27	shuehner	New Issue
2009-02-02 14:27	shuehner	Assigned To	=> dalsasua
2009-02-02 14:27	shuehner	sf_bug_id	0 => 2556950
2009-02-02 14:27	shuehner	Regression testing	=> No
2009-02-02 14:28	shuehner	Relationship added	related to 0007129
2009-02-02 14:28	shuehner	Relationship added	related to 0007130
2009-02-02 14:28	shuehner	Relationship added	related to 0007100
2009-02-06 11:35	svnbot	Checkin
2009-02-06 11:35	svnbot	Note Added: 0013212
2009-02-06 11:35	svnbot	Status	new => resolved
2009-02-06 11:35	svnbot	Resolution	open => fixed
2009-02-06 11:35	svnbot	svn_revision	=> 12880
2009-02-06 11:36	dalsasua	Status	resolved => new
2009-02-06 11:36	dalsasua	Resolution	fixed => open
2009-02-06 11:36	dalsasua	Status	new => scheduled
2009-02-06 11:36	dalsasua	fix_in_branch	=> trunk
2009-02-06 11:36	dalsasua	Status	scheduled => resolved
2009-02-06 11:36	dalsasua	Resolution	open => fixed
2009-02-06 11:42	svnbot	Checkin
2009-02-06 11:42	svnbot	Note Added: 0013214
2009-02-06 11:42	svnbot	svn_revision	12880 => 12882
2009-04-21 12:39	psarobe	Status	resolved => closed

Copyright © 2000 - 2009 MantisBT Group