Bug #13930 | views via ODBC | ||
---|---|---|---|
Submitted: | 11 Oct 2005 14:44 | Modified: | 8 Mar 2007 1:21 |
Reporter: | Benoit LEFEVRE | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
Version: | 3.51.12 | OS: | Windows (Windows XP) |
Assigned to: | Bogdan Degtyariov | CPU Architecture: | Any |
[11 Oct 2005 14:44]
Benoit LEFEVRE
[11 Oct 2005 15:55]
MySQL Verification Team
Could you please provide the dump of the tables ? You can upload it at: ftp://ftp.mysql.com:/pub/mysql/upload Please use a filename like bug13930.zip Thanks in advance.
[14 Oct 2005 18:02]
MySQL Verification Team
Sorry I was unable for to open the file uploaded, it is corrupted. Could you please try to upload again? Thanks.
[15 Oct 2005 13:15]
Benoit LEFEVRE
dump of tables
Attachment: bug13930.sql.bz2.aa (audio/audible, text), 200.00 KiB.
[15 Oct 2005 13:15]
Benoit LEFEVRE
part 2
Attachment: bug13930.sql.bz2.ab (application/octet-stream, text), 200.00 KiB.
[18 Oct 2005 23:32]
MySQL Verification Team
Thank you for the feedback I was able to repeat.
[1 Mar 2006 15:15]
Michael Zwach
I am now facing this problem! MyODBC5 does not work at all - it does not get any data. So is there a solution for MySQL5 and ÓDBC 3.51?
[26 Apr 2006 8:45]
Martijn Starrenburg
What's the status regarding this issue? I tested MyODBC 2.51.13 but the problem is still there. Martijn
[1 Jun 2006 6:57]
Olle Hints
Still facing this problem with MS Access 2003, MyODBC 3.51.12 and MySQL 5.0.22. It makes the long awaited views totally unusable for those poor fellows who use Access as the front-end to the data. Well, that's alright (though views could make developers life much easier in many cases). What worries me much more is that in this case the server returns more data via a view than expected. It is like if Access and MyODBC define a completely new view which is not aware of the criteria (like WHERE privilege>0) of the original view saved in MySQL server. Isn't that a bad thing? It seems to be pretty much of a security issue as well if someone (on the server side) uses views to restrict data access and neat users with MS Access and MyODBC can get much more out of it. So how can it be only the bug in MyODBC? Aren't there some problems on the server side too?
[9 Jun 2006 17:24]
Bogdan Degtyariov
It is a problem in the client library. See bug #19671. Its priority has been increased to high.
[8 Mar 2007 1:21]
Jim Winstead
This was a server problem which was fixed in MySQL 5.0.25.