8000 Join table alias can't use uppercase · Issue #582 · actiontech/dble · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Join table alias can't use uppercase #582

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

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

Jump to bottom
Closed
cntechpower opened this issue Jul 2, 2018 · 1 comment
Closed

Join table alias can't use uppercase #582

cntechpower opened this issue Jul 2, 2018 · 1 comment
Assignees
@yexiaoli88
Labels
complex-query resolve problem has been fixed by developer verified issue's resolve was verified by tester
Milestone
2.18.09.0

Comments

@cntechpower
Copy link 
/*Pre Data*/
create table t1(id int primary key,name varchar(10));
create table t2(id int primary key,name varchar(10));
create table t3(id int primary key,name varchar(10));
insert into t1 values(1,'actiontech');
insert into t2 values(1,'actiontech');
insert into t3 values(1,'actiontech'); 

/*DBLE*/
mysql> select A.id,concat(A.id,'_',A.name) from t1 A join t2 B where A.id=B.id;
ERROR 4004 (42S22): column a.id not found

/*MySQL*/
mysql> select A.id,concat(A.id,'_',A.name) from t1 A join t2 B where A.id=B.id;
+----+-------------------------+
| id | concat(A.id,'_',A.name) |
+----+-------------------------+
|  1 | 1_actiontech            |
+----+-------------------------+
1 row in set (0.00 sec)
  • expect result：
    1.DBLE can use uppercase table alias
  • real result：
    1.DBLE can't use uppercase table alias

/label ~BUG
yanhuqing666 added a commit that referenced this issue Jul 3, 2018
@yanhuqing666
alias lowercase #582
5dd9d7b
@yanhuqing666 yanhuqing666 added this to the 2.18.08.0 milestone Jul 3, 2018
@yanhuqing666 yanhuqing666 added resolve problem has been fixed by developer complex-query labels Jul 3, 2018
@yexiaoli88
Copy link

verified on version: 5.6.29-dble-9.9.9.9-283f45d-20180717102231

@yexiaoli88 yexiaoli88 added the verified issue's resolve was verified by tester label Jul 18, 2018
yanhuqing666 added a commit that referenced this issue Jan 7, 2019
@yanhuqing666
show help #582
9fdecff
yanhuqing666 added a commit that referenced this issue Jan 7, 2019
@yanhuqing666
show help #582
c8a6ce0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yexiaoli88 yexiaoli88

Labels
complex-query resolve problem has been fixed by developer verified issue's resolve was verified by tester
Projects
None yet
Milestone
2.18.09.0
Development

No branches or pull requests
3 participants
@yanhuqing666 @cntechpower @yexiaoli88
0