on 04-09-2010 11:09 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hallo Elke,
sorry, the select-statement was incomplete. The problem is "<>". 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 <> 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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.