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 using...

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've r...

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. Queri...