Changeset: afcfec6f1d1d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=afcfec6f1d1d
Modified Files:
sql/test/orderidx/Tests/simpletable.sql
sql/test/orderidx/Tests/simpletable.stable.out
Branch: default
Log Message:
A sql test that calls CREATE ORDERED INDEX
diffs (224 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
@@ -1,24 +1,24 @@
-create table xtmp1( i integer);
-insert into xtmp1 values (1),(2),(4),(0);
-select * from xtmp1;
+CREATE TABLE xtmp1(i integer);
+INSERT INTO xtmp1 VALUES (1),(2),(4),(0),(10),(7),(3),(1),(1),(-4),(-9),(-1);
+SELECT * FROM xtmp1;
-select schema, table, column, type, mode, count, hashes, phash, "imprints",
sorted, orderidx from storage where "table" = 'xtmp1';
-alter table xtmp1 set READ ONLY;
-call createorderindex('sys','xtmp1','i');
---create ordered index sys_xtmp1_i_oidx on xtmp1 (i);
+SELECT schema, table, column, type, mode, count, hashes, phash, imprints,
sorted, orderidx FROM storage WHERE "table" = 'xtmp1';
+ALTER TABLE xtmp1 SET READ ONLY;
+--call createorderindex('sys','xtmp1','i');
+CREATE ORDERED INDEX sys_xtmp1_i_oidx ON xtmp1(i);
-select schema, table, column, type, mode, count, hashes, phash, "imprints",
sorted, orderidx from storage where "table" = 'xtmp1';
+SELECT schema, table, column, type, mode, count, hashes, phash, imprints,
sorted, orderidx FROM storage WHERE "table" = 'xtmp1';
-select * from xtmp1 where i <0;
-select * from xtmp1 where i <1;
-select * from xtmp1 where i <2;
-select * from xtmp1 where i <5;
-select * from xtmp1 where i <8;
+SELECT * FROM xtmp1 WHERE i<0;
+SELECT * FROM xtmp1 WHERE i<1;
+SELECT * FROM xtmp1 WHERE i<2;
+SELECT * FROM xtmp1 WHERE i<5;
+SELECT * FROM xtmp1 WHERE i<8;
-select * from xtmp1 where i>=0 and i <8;
-select * from xtmp1 where i>=2 and i <=2;
+SELECT * FROM xtmp1 WHERE i>=0 AND i<8;
+SELECT * FROM xtmp1 WHERE i>=2 AND i<=2;
-call droporderindex('sys','xtmp1','i');
---drop index sys_xtmp1_i_oidx;
+--call droporderindex('sys','xtmp1','i');
+DROP INDEX sys_xtmp1_i_oidx;
-drop table xtmp1;
+DROP TABLE xtmp1;
diff --git a/sql/test/orderidx/Tests/simpletable.stable.out
b/sql/test/orderidx/Tests/simpletable.stable.out
--- a/sql/test/orderidx/Tests/simpletable.stable.out
+++ b/sql/test/orderidx/Tests/simpletable.stable.out
@@ -65,10 +65,101 @@ Ready.
# 11:38:22 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-25471" "--port=33382"
# 11:38:22 >
-#create table xtmp1( i integer);
-#insert into xtmp1 values (1),(2),(4),(0);
+#CREATE TABLE xtmp1(i integer);
+#INSERT INTO xtmp1 VALUES (1),(2),(4),(0),(10),(7),(3),(1),(1),(-4),(-9),(-1);
+[ 12 ]
+#SELECT * FROM xtmp1;
+% sys.xtmp1 # table_name
+% i # name
+% int # type
+% 2 # length
+[ 1 ]
+[ 2 ]
[ 4 ]
-#select * from xtmp1;
+[ 0 ]
+[ 10 ]
+[ 7 ]
+[ 3 ]
+[ 1 ]
+[ 1 ]
+[ -4 ]
+[ -9 ]
+[ -1 ]
+#SELECT schema, table, column, type, mode, count, hashes, phash, imprints,
sorted, orderidx FROM storage WHERE "table" = 'xtmp1';
+% .storage, .storage, .storage, .storage, .storage,
.storage, .storage, .storage, .storage, .storage,
.storage # table_name
+% schema, table, column, type, mode, count, hashes, phash,
imprints, sorted, orderidx # name
+% clob, clob, clob, clob, clob, bigint, bigint, boolean,
bigint, boolean, bigint # type
+% 3, 5, 1, 3, 8, 2, 1, 5, 1, 5,
1 # length
+[ "sys", "xtmp1", "i", "int", "writable", 12, 0,
false, 0, false, 0 ]
+#ALTER TABLE xtmp1 SET READ ONLY;
+#CREATE ORDERED INDEX sys_xtmp1_i_oidx ON xtmp1(i);
+#SELECT schema, table, column, type, mode, count, hashes, phash, imprints,
sorted, orderidx FROM storage WHERE "table" = 'xtmp1';
+% .storage, .storage, .storage, .storage, .storage,
.storage, .storage, .storage, .storage, .storage,
.storage # table_name
+% schema, table, column, type, mode, count, hashes, phash,
imprints, sorted, orderidx # name
+% clob, clob, clob, clob, clob, bigint, bigint, boolean,
bigint, boolean, bigint # type
+% 3, 5, 1, 3, 8, 2, 1, 5, 1, 5,
3 # length
+[ "sys", "xtmp1", "i", "int", "readonly", 12, 0,
false, 0, false, 112 ]
+#SELECT * FROM xtmp1 WHERE i<0;
+% sys.xtmp1 # table_name
+% i # name
+% int # type
+% 2 # length
+[ -4 ]
+[ -9 ]
+[ -1 ]
+#SELECT * FROM xtmp1 WHERE i<1;
+% sys.xtmp1 # table_name
+% i # name
+% int # type
+% 2 # length
+[ 0 ]
+[ -4 ]
+[ -9 ]
+[ -1 ]
+#SELECT * FROM xtmp1 WHERE i<2;
+% sys.xtmp1 # table_name
+% i # name
+% int # type
+% 2 # length
+[ 1 ]
+[ 0 ]
+[ 1 ]
+[ 1 ]
+[ -4 ]
+[ -9 ]
+[ -1 ]
+#SELECT * FROM xtmp1 WHERE i<5;
+% sys.xtmp1 # table_name
+% i # name
+% int # type
+% 2 # length
+[ 1 ]
+[ 2 ]
+[ 4 ]
+[ 0 ]
+[ 3 ]
+[ 1 ]
+[ 1 ]
+[ -4 ]
+[ -9 ]
+[ -1 ]
+#SELECT * FROM xtmp1 WHERE i<8;
+% sys.xtmp1 # table_name
+% i # name
+% int # type
+% 2 # length
+[ 1 ]
+[ 2 ]
+[ 4 ]
+[ 0 ]
+[ 7 ]
+[ 3 ]
+[ 1 ]
+[ 1 ]
+[ -4 ]
+[ -9 ]
+[ -1 ]
+#SELECT * FROM xtmp1 WHERE i>=0 AND i<8;
% sys.xtmp1 # table_name
% i # name
% int # type
@@ -77,66 +168,11 @@ Ready.
[ 2 ]
[ 4 ]
[ 0 ]
-#select schema, table, column, type, mode, count, hashes, phash, imprints,
sorted, orderidx from storage where "table" = 'xtmp1';
-% .storage, .storage, .storage, .storage, .storage,
.storage, .storage, .storage, .storage, .storage,
.storage # table_name
-% schema, table, column, type, mode, count, hashes, phash,
imprints, sorted, orderidx # name
-% clob, clob, clob, clob, clob, bigint, bigint, boolean,
bigint, boolean, bigint # type
-% 3, 5, 1, 3, 8, 1, 1, 5, 1, 5,
1 # length
-[ "sys", "xtmp1", "i", "int", "writable", 4, 0,
false, 0, false, 0 ]
-#alter table xtmp1 set READ ONLY;
-#create ordered index sys_xtmp1_i_oidx on xtmp1 (i);
-#select schema, table, column, type, mode, count, hashes, phash, imprints,
sorted, orderidx from storage where "table" = 'xtmp1';
-% .storage, .storage, .storage, .storage, .storage,
.storage, .storage, .storage, .storage, .storage,
.storage # table_name
-% schema, table, column, type, mode, count, hashes, phash,
imprints, sorted, orderidx # name
-% clob, clob, clob, clob, clob, bigint, bigint, boolean,
bigint, boolean, bigint # type
-% 3, 5, 1, 3, 8, 1, 1, 5, 1, 5,
2 # length
-[ "sys", "xtmp1", "i", "int", "readonly", 4, 0,
false, 0, false, 48 ]
-#select * from xtmp1 where i <0;
-% sys.xtmp1 # table_name
-% i # name
-% int # type
-% 1 # length
-#select * from xtmp1 where i <1;
-% sys.xtmp1 # table_name
-% i # name
-% int # type
-% 1 # length
-[ 0 ]
-#select * from xtmp1 where i <2;
-% sys.xtmp1 # table_name
-% i # name
-% int # type
-% 1 # length
+[ 7 ]
+[ 3 ]
[ 1 ]
-[ 0 ]
-#select * from xtmp1 where i <5;
-% sys.xtmp1 # table_name
-% i # name
-% int # type
-% 1 # length
[ 1 ]
-[ 2 ]
-[ 4 ]
-[ 0 ]
-#select * from xtmp1 where i <8;
-% sys.xtmp1 # table_name
-% i # name
-% int # type
-% 1 # length
-[ 1 ]
-[ 2 ]
-[ 4 ]
-[ 0 ]
-#select * from xtmp1 where i>=0 and i <8;
-% sys.xtmp1 # table_name
-% i # name
-% int # type
-% 1 # length
-[ 1 ]
-[ 2 ]
-[ 4 ]
-[ 0 ]
-#select * from xtmp1 where i>=2 and i <=2;
+#SELECT * FROM xtmp1 WHERE i>=2 AND i<=2;
% sys.xtmp1 # table_name
% i # name
% int # type
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
