We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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
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
create table t(i integer); insert into t values(0),(1); select * from t;
+------+------+ | i | i | +======+======+ | 0 | 0 | | 0 | 0 | | 1 | 1 | | 1 | 1 | +------+------+
+------+------+ | i | i | +======+======+ | 0 | 0 | | 0 | 1 | | 1 | 0 | | 1 | 1 | +------+------+
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
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
Date: 2014-05-11 23:14:41 +0200 From: @njnes
fixed by returning an error
The text was updated successfully, but these errors were encountered:
No branches or pull requests
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:
Comment 19810
Date: 2014-05-11 23:14:41 +0200
From: @njnes
fixed by returning an error
The text was updated successfully, but these errors were encountered: