Update of /cvsroot/monetdb/sql/src/backends/monet4/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23009/src/backends/monet4/Tests
Modified Files:
smack01.stable.out
Log Message:
Many fixes
changed how we handle selections over multiple columns of a single table
(should solve the preformance problem reported by Venks)
added a way to bulk request sequence numbers. When loading (copying) data
into tables which have a auto_increment (or alike) column lots of time
was spend in the many calls to get all the sequence numbers (observed a
performance in crease of about 10x when loading pieces of 100K rows)
added support for TINYINT (we map this too 'bte')
improved mapping functions onto the same signature too improve cached
function reuse
Index: smack01.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet4/Tests/smack01.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- smack01.stable.out 24 Oct 2006 16:02:12 -0000 1.7
+++ smack01.stable.out 29 Jun 2007 11:28:44 -0000 1.8
@@ -28,642 +28,642 @@
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 0 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 2 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 3 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 4 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 5 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 6 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 7 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 8 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 9 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 10 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 11 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 12 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 13 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 14 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 15 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 16 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 17 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 18 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 19 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 20 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 21 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 22 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 23 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 24 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 25 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 26 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 27 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 28 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 29 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 30 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 31 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 32 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 33 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 34 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 35 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 36 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 37 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 38 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 39 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 40 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 41 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 42 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 43 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 44 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 45 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 46 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 47 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 48 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 49 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 50 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 51 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 52 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 53 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 54 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 55 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 56 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 57 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 58 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 59 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 60 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 61 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 62 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 63 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 64 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 65 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 66 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 67 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 68 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 69 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 70 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 71 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 72 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 73 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 74 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 75 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 76 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 77 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 78 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 79 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 80 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 81 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 82 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 83 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 84 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 85 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 86 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 87 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 88 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 89 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 90 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 91 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 92 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 93 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 94 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 95 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 96 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 97 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 98 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 99 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 100 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 101 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 102 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 103 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 104 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 105 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 106 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 107 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 108 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 109 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 110 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 111 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 112 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 113 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 114 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 115 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 116 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 117 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 118 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 119 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 120 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 121 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 122 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 123 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 124 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 125 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 126 ]
% . # table_name
% single_value # name
-% smallint # type
+% tinyint # type
% 3 # length
[ 127 ]
% . # table_name
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
