ulnet11.dll crash when executing SQL statement with IN or NOT IN sub query

[former_SQLA_member1694899]

Hi,

Here are the details of my environment:

Visual Studio 2008 - .NET CF 3.5 C#

SQL Anywhere 11.0.1.2960 - using an ultralite database

Windows Mobile 6.1 (a Motorola device)

I'm experiencing a crash in the ulnet11.dll when executing the following SQL statement:

SELECT WORK_ORDER_ID FROM REP_WORK_ORDER_HEADER WHERE BLACKOUT_SCHEDULE_CODE NOT IN (SELECT BLACKOUT_SCHEDULE_CODE FROM REP_BLACKOUT_SCHEDULE WHERE TODAY() BETWEEN BEGIN_BLACKOUT_DATE AND END_BLACKOUT_DATE)

I get the following error: ExceptionCode:0x80000002 ExceptionAddress: 0x7841cb70 Offset: 0x0006cb70

at

ULDataReader.ULNET_Cursor_GetRowCount(IntPtr key, Int32 threshold) at ULDataReader.GetRowCount(Int32 threshold) ... I'd attach a picture but I'm new and not allowed 🙂

If the sub query does not return records, the software does not crash. It only crashes when the sub query returns records.

Please Help!!

Thank you in advance,

Paula

[Former Member]

I tried to construct a schema with SQLA 16 that reproduces this problem, but was unsuccessful. It could be that it is not an issue with v16.

Thank you for the details you have given, but more details would be helpful:

• The relevant schema of your database, with sample data
• Is it purely a query processing issue? (ie. can it be reproduced with dbisql on Windows, without UL.NET) If the problem relies on UL.NET being involved, a code fragment would be helpful.

Thanks.

[former_SQLA_member1694878]

Hi Paula, how much RAM is available for use on the device? This could be the result of a low memory condition.

[chris_keating]

I have tried this in v11 (both from DBISQL and a .NET based desktop and CE application) and have not been able to reproduce.