#339 Error in BETWEEN Operator

[Nihar Ranjan paital]

have Executed the following commands and found some erreneous result in
BETWEEN operation

SCENARIO 1:
CSQL>create index idx1 on t1(f1,f2) tree;
Statement Executed
CSQL>insert into t1(f1,f2) values(1,2);
Statement Executed: Rows Affected = 1
CSQL>insert into t1(f1,f2) values(3,4);
Statement Executed: Rows Affected = 1
CSQL>insert into t1(f1,f2) values(2,3);
Statement Executed: Rows Affected = 1
CSQL>insert into t1(f1,f2) values(3,2);
Statement Executed: Rows Affected = 1
CSQL>insert into t1(f1,f2) values(4,4);
Statement Executed: Rows Affected = 1
CSQL>select * from t1;
---------------------------------------------------------
f1 f2 f3
---------------------------------------------------------
1 2 NULL
3 4 NULL
2 3 NULL
3 2 NULL
4 4 NULL
CSQL>select * from t1 where f1 between 2 and 4;
---------------------------------------------------------
f1 f2 f3
---------------------------------------------------------
Illegal Operator:Not Supported for Binary

Exceptation :
The output of the above conditional select statement should be as follows
---------------------------------------------------------
f1 f2 f3
---------------------------------------------------------
3 4 NULL
2 3 NULL
3 2 NULL
4 4 NULL

[Bijaya kumar Sahu]

Currently composite index on tree is not supported.