Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv24429

Modified Files:
      Tag: Nov2009
        All temp_table_fail_leaves_data.SF-2793286.stable.err 
Added Files:
      Tag: Nov2009
        like_bug.SF-2878994.sql 
Log Message:
approved output and added test for new like bug


Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v
retrieving revision 1.51.2.3
retrieving revision 1.51.2.4
diff -u -d -r1.51.2.3 -r1.51.2.4
--- All 14 Oct 2009 08:22:18 -0000      1.51.2.3
+++ All 8 Nov 2009 20:11:51 -0000       1.51.2.4
@@ -106,7 +106,7 @@
 updating_non-loaded_columns.SF-2864313_KO-3
 updating_non-loaded_columns.SF-2864313_OK-4
 function_call_not_handled.SF-2864179
-semijoin_bug.SF-2869818.sql
+semijoin_bug.SF-2869818
 #
 # The following test currently crashes and this fact (or its remains) might
 # harm sub-sequent tests; hence, this test should be last in this directory.

Index: temp_table_fail_leaves_data.SF-2793286.stable.err
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/temp_table_fail_leaves_data.SF-2793286.stable.err,v
retrieving revision 1.2
retrieving revision 1.2.4.1
diff -u -d -r1.2 -r1.2.4.1
--- temp_table_fail_leaves_data.SF-2793286.stable.err   28 May 2009 14:16:43 
-0000      1.2
+++ temp_table_fail_leaves_data.SF-2793286.stable.err   8 Nov 2009 20:11:51 
-0000       1.2.4.1
@@ -71,11 +71,11 @@
 # 15:05:11 >  mclient -lsql -umonetdb -Pmonetdb --host=alf --port=36217 
 # 15:05:11 >  
 
-MAPI  = mone...@alf:36217
+MAPI  = mone...@alf:37416
 QUERY = create temporary table testpk (hello int, primary key(hello));
 ERROR = !CONSTRAINT: constraints on temporary tables are not supported
-Table sys.testpk does not exist.
-MAPI  = mone...@alf:36217
+table sys.testpk does not exist
+MAPI  = mone...@alf:37416
 QUERY = create temporary table testpk (hello int, primary key(hello));
 ERROR = !CONSTRAINT: constraints on temporary tables are not supported
 

--- NEW FILE: like_bug.SF-2878994.sql ---
create table a (x varchar(10));
insert into a values ('aaa');

create table b (x varchar(10));
insert into b values ('aaa');
insert into b values ('aAa');
insert into b values ('aA');

select a.x from a,b where a.x LIKE b.x;

drop table b;
drop table a;


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to