Hughes Technologies Forums

Also tried gcc 5.3, same result.
As I can't get gdb to work with your sources - my fault, did not use it for a long time, i,'ve used your debug mode.
I made the same query without the index (<) and with the second index (>) and made a diff.

Without index it is using IDX 1, but with Index it is ...

Uups, that reminded me to a bug found in a linked library much later years ago. But msql4 doesn't use strange libraries:

root@q920:# ldd /opt/msql4/bin/msqld
linux-gate.so.1 (0xb7f10000)
libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7c6a000)
/lib/ld-linux.so.2 (0xb7f12000)

Just for the case, I ...

Hi David,

i still have to use msql-1.0.16 and msql-2.0.11, although both can not be compiled with modern gcc anymore.

Therefore i've tested mql-4.2.

My automated tests complained not in all conditons with several indizes.

Today tested msql-3.11, seems to be fine too.

Hello!

Please have a look at this strange behaviour using a second, non unique, index with a where clause. All required information is appended in an example.
As soon as index sgNode_Status is removed from the example table sgNode data are available again and vanish after recreating the index ...