Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv8377/src/test/bugs/Tests
Modified Files:
foreignkey_leftjoin-bug-sf-854312.stable.err
Log Message:
propagated changes of Friday Aug 07 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/08/07 - nielsnes:
src/test/bugs/Tests/foreignkey_leftjoin-bug-sf-854312.stable.err,1.14.6.1
bug fixing
prepare/execute statements now go to seperate query cache
check for ambiguous order by columns
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: foreignkey_leftjoin-bug-sf-854312.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/foreignkey_leftjoin-bug-sf-854312.stable.err,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -d -r1.14 -r1.15
--- foreignkey_leftjoin-bug-sf-854312.stable.err 7 Dec 2008 18:53:30
-0000 1.14
+++ foreignkey_leftjoin-bug-sf-854312.stable.err 7 Aug 2009 21:26:04
-0000 1.15
@@ -10,69 +10,69 @@
# 21:30:23 > Mtimeout -timeout 60 MapiClient --language=sql -u monetdb -P
monetdb --host=stem --port=52668 < foreignkey_leftjoin-bug-sf-854312.sql
# 21:30:23 >
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = SELECT * FROM a LEFT JOIN b ON a.var1 = b.id WHERE var1 = 'aJan';
-ERROR = !SELECT: identifier 'var1' unknown or ambiguous
-MAPI = mone...@alf:31350
+ERROR = !SELECT: identifier 'var1' ambiguous
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('1', 'aaab',
1877611059, 2136665433, 'Bibliotheek', 'U');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('2', 'aaab',
1181479988, NULL, 'hier', 'verwachten');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('3', 'aaab',
1906079357, 1955202416, 'tot', 'van');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('4', 'aaac',
676937782, NULL, 'als zijn', 'z');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('5', 'aaac',
429573099, 1767983525, 'o', 'het');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('6', 'aaad',
1173429043, 216615742, 'Welk', 'nieuwe boeken');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('7', 'aaad',
1722898798, 412510482, 'onlangs', 'oege');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('8', 'aaad',
1111774637, 2025755091, 'Er is', 'lijst met');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('9', 'aaad',
2106443074, 500880029, 'be', 'schikb');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('10', 'aaae',
1862088833, 1636412274, '', 'Klik');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('11', 'aaae',
740103512, 1959552303, 'om een gratis', 'te');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('12', 'aaae',
615168073, 1166551474, 'Doo', 'met de rechter');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('13', 'aaae',
1714170141, 1144940450, 'is', 'op');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('14', 'aaaf',
293281126, 1101721875, 'klikken', 'kunt u');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('15', 'aaaf',
1371008872, 1420507527, 'bestan', 'naar uw');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('16', 'aaaf',
1238690311, 2013589728, 'overhalen', 'en');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('17', 'aaaf',
1598516811, 1682499981, 'opslaan. U', 'op');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('18', 'aaag',
1551706168, 1147370461, 'reide', 'en');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = INSERT INTO b (r_id, id, var1, var2, var3, var4) VALUES ('19', 'aaag',
1178314077, 670110160, '', 'boek');
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'b.b_id_fkey'
violated
-MAPI = mone...@alf:31350
+MAPI = mone...@alf:33079
QUERY = SELECT * FROM a LEFT JOIN b ON a.var1 = b.id WHERE var1 = 'aJan';
-ERROR = !SELECT: identifier 'var1' unknown or ambiguous
+ERROR = !SELECT: identifier 'var1' ambiguous
# 21:30:24 >
# 21:30:24 > Done.
------------------------------------------------------------------------------
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
