MAXDB 7.7 crash

[Former Member]

Hallo,

The MAXDB 7.7 crashes when I execute the following actions. 7.6 works.

create table X (

id dec(22) primary key

)

;

select

a.id

from X a

where a.id<>a.id

;

Regards Thomas

[Former Member]

Hi,

sorry, I do not catch your meaning:

Yes, the select is incomplete and the column-specification is incorrect as you copied a.id together twice.

Therefore I got the correct error -8010 when trying to reproduce.

Do you really use this doubled column-specification in 7.6 where it 'worked'?

What do you mean with The problem is "". ???

You sent the same select twice. I do not see a " in.

And you told us that it is reproducable, but did not provide a traceback (can be found in knldiag/knlmsg).

How shall we help ?

Elke

[lbreddemann]

Hello Elke,

it's a problem of the forum software - it filters out the brackets!

select
a.id
from X a
where a.id != a.id

The above should have been the query semantics, but on my 7.7.07 Build 12 it correclty worked (without crash).

Also the execution plan showed the "No resultset possible" line; therefore, no errors here.

regards,

Lars

[Former Member]

It is the larger of small characters.

ok, I'll try again with version 7.7.07.16. We have 7.7.06

Thomas

Edited by: Thomas Eichler on Apr 9, 2010 3:17 PM

[Former Member]

Hello,

unbelievable, but it works in version 7.7.07.16

Thomas

[Former Member]

Hi,

mh, what does 'WORK' mean in 7.6? Does the select work or do you receive an error?

Do you have a user named A in 7.6? And does this user have a table named ida?

Otherwise you should receive error -8010 tablename must be in from list as I do when trying to reproduce your problem.

Or the other way round: may I ask for the traceback?

Elke

[Former Member]

Hallo Elke,

sorry, the select-statement was incomplete. The problem is "&lt;&gt;". The Select-statement works in MAXDB 7.6. The MAXDB 7.7 crashes reproducible (Linux 64bit or Windows 64bit).

create table X (

id dec(22) primary key

)

;

select

a.id

from X a

where a.id &lt;&gt; a.id

;

Thomas

Edited by: Thomas Eichler on Apr 9, 2010 2:55 PM

Edited by: Thomas Eichler on Apr 9, 2010 2:55 PM