Project:
| View Revisions: Issue #31149 | [ Back to Issue ] | ||
| Summary | 0031149: "minus" word in PL function shows warning when exporting db | ||
| Revision | 2015-10-27 15:18 by mfuertes | ||
| 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 |
||
| Revision | 2015-10-27 15:15 by mfuertes | ||
| 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) |
||
| Revision | 2015-10-14 12:02 by mfuertes | ||
| Steps To Reproduce | See Description. | ||
| Revision | 2015-10-14 11:16 by mfuertes | ||
| Description | When 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. |
||
| Revision | 2015-10-14 11:15 by mfuertes | ||
| Description | When tables 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. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |