Migrated Universe generates different SQL in WebI to DeskI

[system]

Hi Rich,

So you have found another gem then… 8)

As in my post, below,

120×120 10.4 KB

Hi, I have noticed some rather strange and rather alarming behaviour during our test migration to XIr2 and was wondering whether anyone had come accross the issue… Migration using either to upgrading to 6.5 repo or using the all in one upgrade from 6.1b made no difference to the problem, described below. ODBC or OLEDB connection strings made no difference either. Using Ansi or Non-Ansi settings also made no difference, results below are using universe parameter ANSI set to ‘Yes’ SQL Server …

concerning incorrect SQL generation by Deski, I found that the SQL generated by the Java panel is different from the Deski SQL.

I would imagine that this is because the SQL engines are written in a different (buggy) way…

I don’t know if the post, below, may also be of interest…

120×120 10.4 KB

XI R2 Designer, Oracle 9i RDBMS We have two tables: customers and orders, with cardinalities set to indicate a customer places many orders. We have an Order Type object using orders.order_type as the select, and Number of Unique Customers using select(distinct customers.cust_id) as the object select. In the Designer Query Panel, DeskI and WebI, when a query is defined with Number of Unique customers as a result object and Order Type = ‘ABC’ as a condition, it throws an “Incompatible combinati…

Cheers,

Mark.

---

Mak 1 (BOB member since 2005-01-06)