0035393: IN clause in view not properly exported using postgresql

Description

IN clause in view not properly exported using postgresql

Steps To Reproduce

Open c_invoice_candidate_v view with pgAdmin.

Change in the view:
(o.docstatus = 'CO' OR o.docstatus = 'CL' OR o.docstatus = 'IP')
with:
o.docstatus IN ('CO', 'CL', 'IP')

Save it and run ant export.database. Check view is correctly exported.

Revert previous change.

Change in the view:
AND ( dt.docsubtypeso <> 'ON'
AND dt.docsubtypeso <> 'OB'
AND dt.docsubtypeso <> 'WR' )
with:
AND dt.docsubtypeso NOT IN ('ON', 'OB', 'WR')

Save it and run ant export.database. Check view is correctly exported.

Revert previous change.

Now, make both changes together in the view, export them and check they are not correctly exported:

Instead of:
o.docstatus IN ('CO', 'CL', 'IP')
we get:
(o.docstatus IN ('CO', 'CL', 'IP']))

Instead of:
AND dt.docsubtypeso NOT IN ('ON', 'OB', 'WR')
we get:
(dt.docsubtypeso <> ALL (ARRAY['ON', 'OB', 'WR'))

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of	design defect	0029492		closed	alostale	Wrong export of a view
related to	defect	0035341		closed	mcobas	Wrong orders shown in "Create Invoices From Orders" window

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2017-03-01 10:26	aferraz	New Issue
2017-03-01 10:26	aferraz	Assigned To	=> platform
2017-03-01 10:26	aferraz	Modules	=> Core
2017-03-01 10:26	aferraz	Triggers an Emergency Pack	=> No
2017-03-01 10:28	aferraz	Relationship added	related to 0035341
2017-03-02 14:06	alostale	Relationship added	duplicate of 0029492
2017-03-02 14:06	alostale	Status	new => closed
2017-03-02 14:06	alostale	Resolution	open => duplicate