Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv7588
Modified Files:
Tag: Feb2010
POWER_vs_prod.SF-2596114.stable.out
reorder.SF-2770608.stable.out
Log Message:
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.2.4.1
diff -u -d -r1.2 -r1.2.4.1
--- reorder.SF-2770608.stable.out 4 Aug 2009 07:25:10 -0000 1.2
+++ reorder.SF-2770608.stable.out 24 Jan 2010 16:26:34 -0000 1.2.4.1
@@ -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 >
Index: POWER_vs_prod.SF-2596114.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out,v
retrieving revision 1.9
retrieving revision 1.9.2.1
diff -u -d -r1.9 -r1.9.2.1
--- POWER_vs_prod.SF-2596114.stable.out 10 Jan 2010 15:33:36 -0000 1.9
+++ POWER_vs_prod.SF-2596114.stable.out 24 Jan 2010 16:26:34 -0000 1.9.2.1
@@ -33,16 +33,16 @@
barrier _46 := language.dataflow();
_2:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",0);
_7:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",2);
- _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
- _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_9 := algebra.kdifference(_2,_7);
_2:bat[:oid,:dbl] := nil:BAT;
_10 := algebra.kunion(_9,_7);
_9 := nil:BAT;
_7:bat[:oid,:dbl] := nil:BAT;
+ _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
_13 := algebra.kunion(_10,_11);
_10 := nil:BAT;
_11:bat[:oid,:dbl] := nil:BAT;
+ _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_15 := bat.reverse(_14);
_14:bat[:oid,:oid] := nil:BAT;
_16 := algebra.kdifference(_13,_15);
@@ -65,16 +65,16 @@
barrier _45 := language.dataflow();
_2:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",0);
_7:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",2);
- _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
- _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_9 := algebra.kdifference(_2,_7);
_2:bat[:oid,:dbl] := nil:BAT;
_10 := algebra.kunion(_9,_7);
_9 := nil:BAT;
_7:bat[:oid,:dbl] := nil:BAT;
+ _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
_13 := algebra.kunion(_10,_11);
_10 := nil:BAT;
_11:bat[:oid,:dbl] := nil:BAT;
+ _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_15 := bat.reverse(_14);
_14:bat[:oid,:oid] := nil:BAT;
_16 := algebra.kdifference(_13,_15);
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
