Crossproduct error

[monetdb-team]

Date: 2014-05-08 07:41:51 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

Last updated: 2014-05-22 09:52:26 +0200

Comment 19805

Date: 2014-05-08 07:41:51 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:28.0) Gecko/20100101 Firefox/28.0
Build Identifier:

Cross product does not produce the correct result

sql>create table t(i integer);
operation successful (72.464ms)
sql>insert into t values(0),(1);
2 affected rows (9.770ms)
sql>select * from t;
+------+
| i |
+======+
| 0 |
| 1 |
+------+
2 tuples (0.924ms)
sql>select * from t,t;
+------+------+
| i | i |
+======+======+
| 0 | 0 |
| 0 | 0 |
| 1 | 1 |
| 1 | 1 |
+------+------+
4 tuples (1.219ms)

Reproducible: Always

Steps to Reproduce:

create table t(i integer);
insert into t values(0),(1);
select * from t;

Actual Results:

+------+------+
| i | i |
+======+======+
| 0 | 0 |
| 0 | 0 |
| 1 | 1 |
| 1 | 1 |
+------+------+

Expected Results:

+------+------+
| i | i |
+======+======+
| 0 | 0 |
| 0 | 1 |
| 1 | 0 |
| 1 | 1 |
+------+------+

Comment 19806

Date: 2014-05-09 11:43:12 +0200
From: @mlkersten

This is only caused by a self-product and without using correlation names.
(select * from t as A, t as B) works

Comment 19809

Date: 2014-05-11 23:14:28 +0200
From: MonetDB Mercurial Repository <>

Changeset ec0a3ea4be34 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=ec0a3ea4be34

Changeset description:

fix for bug #3482, ie return an error on abiguous table names

Comment 19810

Date: 2014-05-11 23:14:41 +0200
From: @njnes

fixed by returning an error