Search found 4 matches

by sgrf
Wed Apr 24, 2019 8:50 pm
Forum: mSQL Support
Topic: msql-4.2 bug with a second non uniq index and a where clause
Replies: 7
Views: 11220

Re: msql-4.2 bug with a second non uniq index and a where clause

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...
by sgrf
Wed Apr 24, 2019 12:21 pm
Forum: mSQL Support
Topic: msql-4.2 bug with a second non uniq index and a where clause
Replies: 7
Views: 11220

Re: msql-4.2 bug with a second non uniq index and a where clause

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...
by sgrf
Tue Apr 23, 2019 6:02 pm
Forum: mSQL Support
Topic: msql-4.2 bug with a second non uniq index and a where clause
Replies: 7
Views: 11220

Re: msql-4.2 bug with a second non uniq index and a where clause

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.
by sgrf
Mon Apr 22, 2019 1:56 pm
Forum: mSQL Support
Topic: msql-4.2 bug with a second non uniq index and a where clause
Replies: 7
Views: 11220

msql-4.2 bug with a second non uniq index and a where clause

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