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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031149
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminorhave not tried2015-10-14 11:152022-02-01 08:05
ReportermfuertesView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version3.0PR15Q1.5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031149: "minus" word in PL function shows warning when exporting db

DescriptionWhen columns have names like "yf_minus_one_point_eight" or "yf_minus1_point_five" it gets converted to different names containing [EXCEPT][minus+] and so on. So export.database its taking this in-between-quotes text as SQL keywords and it shouldn't.

Steps To Reproduce- Create a Module and a db prefix.
- Add a function to that module, in my case:

CREATE OR REPLACE FUNCTION HK_TEST(i integer) RETURNS integer AS $$
        BEGIN
                select 1 as minus_ten from c_order limit 1;
        END;
$$ LANGUAGE plpgsql;

- Export database and the result should be something like:

Found differences in HK_TEST
********************************************************
BEGIN
                select 1 as [EXCEPT][minus+]_ten from c_order limit 1;[ +]END[ ]
********************************************************
(see atachments for full export.log and client export images)




Aditionally, client used this query inside a function:

select ad_client_id, ad_org_id, isactive,
created, createdby, updated, updatedby, sapm_trip_detail_id,
container_no, seal_no, type_no, mix, loading_date, c_bpartner_id,
destination, status, yf_60, yf_40_60, yf_20_40, yf_10, yf_3_point_4,
yf_1_point_8, yf_minus_one_point_eight, yf_minus1_point_five,
sk_3_point_4, sk_1_point_8, skyfin_negative_1_point_8, sk_minus_1_point_5,
be_60, be_40_60, be_20_40, be_10_20, be_3_point_5, be_1_point_8,
be_ngvt_1_point_8, be_minus_1_point_5, ger, mel, rej, total,
booking_no, container_size from sapm_trip_detail_line
where sapm_trip_detail_id =v_record_id and c_bpartner_id=Cur_Parameter.c_bpartner_id
and destination=Cur_Parameter.destination and booking_no=Cur_Parameter.booking_no
TagsNo tags attached.
Attached Fileslog file icon export.log [^] (3,394 bytes) 2015-10-27 15:15
png file icon ScreenShot2015-08-19at11.10.06am.png [^] (339,367 bytes) 2015-10-27 15:16

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0029492 closedalostale Wrong export of a view 

-  Notes
(0081003)
alostale (manager)
2015-10-14 12:02
edited on: 2015-10-14 12:03

 Please, provide accurate steps to reproduce this issue.

Testing with the following steps, names are correctly exported:

$ psql -U postgres -d pi -h localhost -p 5432
psql (9.5alpha2, server 9.4.4)
Type "help" for help.

pi=# alter table c_order add column yf_minus_one_point_eight numeric, add column yf_minus1_point_five numeric;
ALTER TABLE
pi=# \q

$ ant export.database -Dforce=yes -Dvalidate.model=false
$ hg diff src-db/database/model/tables/C_ORDER.xml
  diff -r f1f0e628b7d9 src-db/database/model/tables/C_ORDER.xml
--- a/src-db/database/model/tables/C_ORDER.xml Mon Sep 28 13:17:45 2015 +0200
+++ b/src-db/database/model/tables/C_ORDER.xml Wed Oct 14 11:58:19 2015 +0200
@@ -341,6 +341,14 @@
         <default/>
         <onCreateDefault/>
       </column>
+ <column name="YF_MINUS_ONE_POINT_EIGHT" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
+ <column name="YF_MINUS1_POINT_FIVE" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
       <foreign-key foreignTable="C_DOCTYPE" name="C_DOCTYPE_CORDER">
         <reference local="C_DOCTYPE_ID" foreign="C_DOCTYPE_ID"/>
       </foreign-key>

- Issue History
Date Modified Username Field Change
2015-10-14 11:15 mfuertes New Issue
2015-10-14 11:15 mfuertes Assigned To => platform
2015-10-14 11:15 mfuertes Modules => Core
2015-10-14 11:15 mfuertes Triggers an Emergency Pack => No
2015-10-14 11:16 mfuertes Description Updated View Revisions
2015-10-14 12:02 alostale Note Added: 0081003
2015-10-14 12:02 alostale Assigned To platform => mfuertes
2015-10-14 12:02 alostale Status new => feedback
2015-10-14 12:02 alostale Note Edited: 0081003 View Revisions
2015-10-14 12:03 alostale Note Edited: 0081003 View Revisions
2015-10-27 15:15 mfuertes Assigned To mfuertes => platform
2015-10-27 15:15 mfuertes Steps to Reproduce Updated View Revisions
2015-10-27 15:15 mfuertes File Added: export.log
2015-10-27 15:16 mfuertes File Added: ScreenShot2015-08-19at11.10.06am.png
2015-10-27 15:18 mfuertes Status feedback => new
2015-10-27 15:18 mfuertes Steps to Reproduce Updated View Revisions
2015-10-27 15:24 alostale Status new => acknowledged
2015-11-10 16:32 alostale Priority high => normal
2015-11-10 16:32 alostale Summary "MINUS" keyword in colname => "minus" word in PL function shows warning when exporting db
2015-11-10 16:32 alostale Relationship added related to 0029492
2022-02-01 08:05 alostale Assigned To platform => Triage Platform Base

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker