Bug #13121 | access denied - bug or feature? | ||
---|---|---|---|
Submitted: | 12 Sep 2005 13:51 | Modified: | 18 Jul 2007 19:57 |
Reporter: | Oliver Peters | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
Version: | 3.51.11-2 & 5.0.0.-alpha | OS: | Windows (Windows2000) |
Assigned to: | CPU Architecture: | Any |
[12 Sep 2005 13:51]
Oliver Peters
[12 Sep 2005 14:42]
MySQL Verification Team
Could you please provide a test case script with all statement because on my own I was unable to reproduce on Excel 2003. Thanks in advance.
[12 Sep 2005 16:11]
Oliver Peters
no chance to add the view
Attachment: myodbc_excel_bug.png (image/png, text), 27.89 KiB.
[12 Sep 2005 16:11]
Oliver Peters
It's the view CREATE ALGORITHM=UNDEFINED VIEW `rohehastra`.`sortgrupp71` AS select `r`.`VKH03` AS `Anz Schuppen` from `rohehastra`.`roh2004` `r`; that makes the problem and the problem is solved by deleting the space in `Anz Schuppen` so that it is `AnzSchuppen` I can't do the query because I get no access (look at the png) and can't choose to add the view. BTW: I use EXCEL2003 with every available patch
[12 Sep 2005 18:35]
MySQL Verification Team
Thank you for the feedback and bug report. Now I understood what you meant: c:\mysql\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.11-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table tbl1 (id int, name char(20)); Query OK, 0 rows affected (0.09 sec) /* the below view not works on Excel */ mysql> create view tbl1_view as select name as "people name" -> from tbl1; Query OK, 0 rows affected (0.01 sec) mysql> insert into tbl1 set id=1, name="Peter"; Query OK, 1 row affected (0.03 sec) mysql> select * from tbl1_view; +-------------+ | people name | +-------------+ | Peter | +-------------+ 1 row in set (0.00 sec) mysql> drop view tbl1_view; Query OK, 0 rows affected (0.00 sec) /* The below view works */ mysql> create view tbl1_view as select name as "peoplename" -> from tbl1; Query OK, 0 rows affected (0.00 sec)
[17 May 2007 20:35]
Jim Winstead
Bug #14653 was marked as a duplicate of this bug.
[18 Jul 2007 19:57]
Jim Winstead
This is a duplicate of Bug #2966.