[sohail malik]

I am trying to evaluate the level of effort needed to migrate SQL source code from implementations using Oracle driver to the new NetSuite supplied driver. I thought it might be useful to have a list of incompatabilities uncovered that will require SQL code changes. I anticipate there are going to be alot of source and feature gottchas. May-be discussion on bug/feature/root cause/workaround could be contributed.
This is a cached copy. Click here to see the original post.

[sohail malik]

FROM clause subquery not supported

From clause subquery does not work (anymore).

SELECT TX.TRANSACTION_ID

FROM

(SELECT * FROM TRANSACTIONS) TX

results in:

Error: Subquery in FROM clause is not supported in Pushdown Query mode (State:IM002, Native Code: 0)

BTW, subquery doesn’t work in select list either, they do work in where clause

[longlam]

RE: Migration Oracle driver SQL -> NetSuite ODBC driver SQL

Yes I have noticed that and it is a huge issue especially from a performance point of view. I brought this up but was to lazy to follow up with a query. I think yours will suffice.

[sohail malik]

RE: Migration Oracle driver SQL -> NetSuite ODBC driver SQL

Unary operator not allowed in select list

This now causes syntax error:

SELECT -TXL.NET_AMOUNT

FROM TRANSACTION_LINES TXL

Error: Syntax error in SQL statement. syntax error line 1 at or after token . (State:37000, Native Code: 0)

Workaround? 0-TXL.NET_AMOUNT

[Author]

Posts