MonetDB: leftmart - use create ordered index

[Niels Nes]

Changeset: b5ba31c36a14 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b5ba31c36a14
Modified Files:
        sql/test/orderidx/Tests/simpletable.sql
        sql/test/orderidx/Tests/smalltable.sql
Branch: leftmart
Log Message:

use create ordered index


diffs (35 lines):

diff --git a/sql/test/orderidx/Tests/simpletable.sql 
b/sql/test/orderidx/Tests/simpletable.sql
--- a/sql/test/orderidx/Tests/simpletable.sql
+++ b/sql/test/orderidx/Tests/simpletable.sql
@@ -3,7 +3,8 @@ insert into xtmp1 values (1),(2),(4),(0)
 select * from xtmp1;
 
 select * from storage where "table"= 'xtmp1';
-call orderidx('sys','xtmp1','i');
+alter table xtmp1 set READ ONLY;
+create ordered index sys_xtmp1_i_oidx on xtmp1 (i);
 
 select * from storage where "table"= 'xtmp1';
 
diff --git a/sql/test/orderidx/Tests/smalltable.sql 
b/sql/test/orderidx/Tests/smalltable.sql
--- a/sql/test/orderidx/Tests/smalltable.sql
+++ b/sql/test/orderidx/Tests/smalltable.sql
@@ -1,14 +1,16 @@
 -- test robustness against small tables
 create table xtmp2( i integer);
 select * from storage where "table"= 'xtmp2';
-call orderidx('sys','xtmp2','i');
+alter table xtmp2 set read only;
+create ordered index sys_xtmp2_i_oidx on xtmp2(i);
 select * from storage where "table"= 'xtmp2';
 select * from xtmp2 where i>=0 and i <8;
 
 create table xtmp3( i integer);
 insert into xtmp3 values(3);
 select * from storage where "table"= 'xtmp3';
-call orderidx('sys','xtmp3','i');
+alter table xtmp3 set read only;
+create ordered index sys_xtmp3_i_oidx on xtmp3(i);
 select * from storage where "table"= 'xtmp3';
 select * from xtmp3 where i>=0 and i <8;
 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list