From: Lukasz Misztal (miszlukgmail.com)
Date: Wed Aug 01 2007 - 12:44:46 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello everyone,

i have a simple question:
is order of fields in (left) join in MAXDB significant?

For example:

select * from "Table1"
left join "Table2" on "Table1_ID"="Table2_IDTable1"

Returns:
10 21 10
11 ? ?

but

select * from "Table1"
left join "Table2" on "Table2_IDTable1"="Table1_ID"

Returns:
? 20 ?
10 21 10

I get confused.
Two diffrent strategies (JOIN VIA KEY RANGE/JOIN VIA KEY COLUMN).

I have searched bugs.mysql.com but it gets nothing.
Is it bug whether my basic mistake?

Lukasz

---------------------
MAXDB 7.6.00.37 WinXp prof., test data:

CREATE TABLE "Table1"
(
        "Table1_ID" Fixed (12,0),
        PRIMARY KEY ("Table1_ID")
)
//
CREATE TABLE "Table2"
(
        "Table2_ID" Fixed (12,0),
        "Table2_IDTable1" Fixed (12,0),
        PRIMARY KEY ("Table2_ID")
)
//
insert into "Table1" values (10)
//
insert into "Table1" values (11)
//
insert into "Table2" values (20,null)
//
insert into "Table2" values (21,10)
//
select * from "Table1"
left join "Table2" on "Table2_IDTable1"="Table1_ID"
//
select * from "Table1"
left join "Table2" on "Table1_ID"="Table2_IDTable1"

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]