Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv21503/src/test/BugTracker-2009/Tests
Modified Files:
reorder.SF-2770608.stable.out
Log Message:
propagated changes of Sunday Jan 24 2010 - Tuesday Jan 26 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/24 - nielsnes:
src/test/BugTracker-2009/Tests/reorder.SF-2770608.stable.out,1.2.4.1
approved output (changes caused by new functions (ptr conversion) and
different plan order because of optimizer changes)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: reorder.SF-2770608.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/reorder.SF-2770608.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- reorder.SF-2770608.stable.out 4 Aug 2009 07:25:10 -0000 1.2
+++ reorder.SF-2770608.stable.out 26 Jan 2010 13:25:42 -0000 1.3
@@ -31,32 +31,33 @@
% 2, 9, 14, 2, 1, 2, 2, 1, 2, 9,
14, 2, 1, 2, 2, 1 # length
[ 0, "any", "any", 0, 0, 0, 0, 0, 0, "any",
"any", 0, 0, 0, 0, 0 ]
[ 1, "bat", "table", 0, 0, 0, 1, 0, 1,
"bat", "table", 0, 0, 0, 1, 0 ]
-[ 2, "bit", "boolean", 1, 0, 2, 2, 0, 2,
"bit", "boolean", 1, 0, 2, 2, 0 ]
-[ 3, "str", "char", 0, 0, 0, 3, 0, 3, "str",
"char", 0, 0, 0, 3, 0 ]
-[ 4, "str", "varchar", 0, 0, 0, 4, 0, 4,
"str", "varchar", 0, 0, 0, 4, 0 ]
-[ 5, "str", "clob", 0, 0, 0, 4, 0, 5, "str",
"clob", 0, 0, 0, 4, 0 ]
-[ 6, "bte", "tinyint", 8, 1, 2, 6, 0, 6,
"bte", "tinyint", 8, 1, 2, 6, 0 ]
-[ 7, "sht", "smallint", 16, 1, 2, 6, 0, 7,
"sht", "smallint", 16, 1, 2, 6, 0 ]
-[ 8, "oid", "oid", 31, 0, 2, 6, 0, 8, "oid",
"oid", 31, 0, 2, 6, 0 ]
-[ 9, "int", "int", 32, 1, 2, 6, 0, 9, "int",
"int", 32, 1, 2, 6, 0 ]
-[ 10, "lng", "bigint", 64, 1, 2, 6, 0, 10,
"lng", "bigint", 64, 1, 2, 6, 0 ]
-[ 11, "wrd", "wrd", 64, 1, 2, 6, 0, 11, "wrd",
"wrd", 64, 1, 2, 6, 0 ]
-[ 12, "bte", "decimal", 2, 1, 10, 8, 0, 12,
"bte", "decimal", 2, 1, 10, 8, 0 ]
-[ 13, "sht", "decimal", 4, 1, 10, 8, 0, 13,
"sht", "decimal", 4, 1, 10, 8, 0 ]
-[ 14, "int", "decimal", 9, 1, 10, 8, 0, 14,
"int", "decimal", 9, 1, 10, 8, 0 ]
-[ 15, "lng", "decimal", 19, 1, 10, 8, 0, 15,
"lng", "decimal", 19, 1, 10, 8, 0 ]
-[ 16, "flt", "real", 24, 2, 2, 9, 0, 16, "flt",
"real", 24, 2, 2, 9, 0 ]
-[ 17, "dbl", "double", 53, 2, 2, 9, 0, 17,
"dbl", "double", 53, 2, 2, 9, 0 ]
-[ 18, "int", "month_interval", 32, 0, 2, 7, 0,
18, "int", "month_interval", 32, 0, 2, 7, 0
]
-[ 19, "lng", "sec_interval", 19, 1, 10, 7, 0, 19,
"lng", "sec_interval", 19, 1, 10, 7, 0 ]
-[ 20, "daytime", "time", 7, 0, 0, 10, 0, 20,
"daytime", "time", 7, 0, 0, 10, 0 ]
-[ 21, "daytime", "timetz", 7, 1, 0, 10, 0,
21, "daytime", "timetz", 7, 1, 0, 10, 0
]
-[ 22, "date", "date", 0, 0, 0, 11, 0, 22, "date",
"date", 0, 0, 0, 11, 0 ]
-[ 23, "timestamp", "timestamp", 7, 0, 0, 12, 0,
23, "timestamp", "timestamp", 7, 0, 0, 12, 0
]
-[ 24, "timestamp", "timestamptz", 7, 1, 0, 12, 0,
24, "timestamp", "timestamptz", 7, 1, 0, 12, 0
]
-[ 25, "sqlblob", "blob", 0, 0, 0, 5, 0, 25,
"sqlblob", "blob", 0, 0, 0, 5, 0 ]
+[ 2, "ptr", "ptr", 0, 0, 0, 1, 0, 2, "ptr",
"ptr", 0, 0, 0, 1, 0 ]
+[ 3, "bit", "boolean", 1, 0, 2, 2, 0, 3,
"bit", "boolean", 1, 0, 2, 2, 0 ]
+[ 4, "str", "char", 0, 0, 0, 3, 0, 4, "str",
"char", 0, 0, 0, 3, 0 ]
+[ 5, "str", "varchar", 0, 0, 0, 4, 0, 5,
"str", "varchar", 0, 0, 0, 4, 0 ]
+[ 6, "str", "clob", 0, 0, 0, 4, 0, 6, "str",
"clob", 0, 0, 0, 4, 0 ]
+[ 7, "bte", "tinyint", 8, 1, 2, 6, 0, 7,
"bte", "tinyint", 8, 1, 2, 6, 0 ]
+[ 8, "sht", "smallint", 16, 1, 2, 6, 0, 8,
"sht", "smallint", 16, 1, 2, 6, 0 ]
+[ 9, "oid", "oid", 31, 0, 2, 6, 0, 9, "oid",
"oid", 31, 0, 2, 6, 0 ]
+[ 10, "int", "int", 32, 1, 2, 6, 0, 10, "int",
"int", 32, 1, 2, 6, 0 ]
+[ 11, "lng", "bigint", 64, 1, 2, 6, 0, 11,
"lng", "bigint", 64, 1, 2, 6, 0 ]
+[ 12, "wrd", "wrd", 64, 1, 2, 6, 0, 12, "wrd",
"wrd", 64, 1, 2, 6, 0 ]
+[ 13, "bte", "decimal", 2, 1, 10, 8, 0, 13,
"bte", "decimal", 2, 1, 10, 8, 0 ]
+[ 14, "sht", "decimal", 4, 1, 10, 8, 0, 14,
"sht", "decimal", 4, 1, 10, 8, 0 ]
+[ 15, "int", "decimal", 9, 1, 10, 8, 0, 15,
"int", "decimal", 9, 1, 10, 8, 0 ]
+[ 16, "lng", "decimal", 19, 1, 10, 8, 0, 16,
"lng", "decimal", 19, 1, 10, 8, 0 ]
+[ 17, "flt", "real", 24, 2, 2, 9, 0, 17, "flt",
"real", 24, 2, 2, 9, 0 ]
+[ 18, "dbl", "double", 53, 2, 2, 9, 0, 18,
"dbl", "double", 53, 2, 2, 9, 0 ]
+[ 19, "int", "month_interval", 32, 0, 2, 7, 0,
19, "int", "month_interval", 32, 0, 2, 7, 0
]
+[ 20, "lng", "sec_interval", 19, 1, 10, 7, 0, 20,
"lng", "sec_interval", 19, 1, 10, 7, 0 ]
+[ 21, "daytime", "time", 7, 0, 0, 10, 0, 21,
"daytime", "time", 7, 0, 0, 10, 0 ]
+[ 22, "daytime", "timetz", 7, 1, 0, 10, 0,
22, "daytime", "timetz", 7, 1, 0, 10, 0
]
+[ 23, "date", "date", 0, 0, 0, 11, 0, 23, "date",
"date", 0, 0, 0, 11, 0 ]
+[ 24, "timestamp", "timestamp", 7, 0, 0, 12, 0,
24, "timestamp", "timestamp", 7, 0, 0, 12, 0
]
+[ 25, "timestamp", "timestamptz", 7, 1, 0, 12, 0,
25, "timestamp", "timestamptz", 7, 1, 0, 12, 0
]
+[ 26, "sqlblob", "blob", 0, 0, 0, 5, 0, 26,
"sqlblob", "blob", 0, 0, 0, 5, 0 ]
-# 22:07:50 >
-# 22:07:50 > Done.
-# 22:07:50 >
+# 17:16:27 >
+# 17:16:27 > Done.
+# 17:16:27 >
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
