Order in left join 2007-08-01 - By Lukasz Misztal
Back
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
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
