Skip to Content
avatar image
Former Member

MAXDB 7.7 crash

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 09, 2010 at 10:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Apr 09, 2010 at 12:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded