MySQL Bugs: #35860: Views, Can they be used already?

Bug #35860	Views, Can they be used already?
Submitted:	6 Apr 2008 19:54	Modified:	11 May 2008 5:42
Reporter:	Louis Breda van	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Views	Severity:	S2 (Serious)
Version:	5.1.23 special / gui tools r12	OS:	Windows (VISTA 64)
Assigned to:		CPU Architecture:	Any
Tags:	Crazy Behavoir;

Description:
Hello,

I must admit, I only did a short trail with a view, 
but if my impression is correct, I will wait a little bit longer
before trying to use them.

What I did and noticed was the following:
- defined a table
- defined a view, which equals the table
- used the table pk as the unique view field 
(do not understand that, since the view should inherrit its defs from the table, in fact it is the table)
- tried to access the view from the query browser.
View where ? :> Just give the name, than it is there :>
- made a link towards the view using ODBC
- linked the view in access as a table
- did insert one / the first record, seems to be ok
- did insert a second record ==> now the table / view shows two times the same first record. whith of course two times the same unique PK
- did access the view via teh query browser, now the two differt records are there.

So, does not feel any thing neer ready, at least that is my first impression.

Hope I am wrong,

Louis   

5.1.23 special / gui tools r12 / odbc 5.1.3

How to repeat:
I do not think we need a testcase here

Thank you for a problem report. Please, send the results of SHOW CREATE TABLE for base table and SHOW CREATE VIEW for the view.

I suspect this is a bug in Connector/ODBC...

Valeriy,

I tryed to create the problem again, but it seemed to work now. Do not know why.

Important perhaps is that I saw the bug using ODBC 3.51.23 
now running 3.51.24. 

Ridiculously I am running two ODBC-connectors right now:
- 3.5.1.23 for table links
- 5.13 for the programming interface (vba)
That because, I can not create a table link using 5,13 (see bug #34908)

Sincerely,

Louis

So, can we consider this as not repeatable with newer versions of software?

My sugestion is to set it on hold for a few weeks.

I will probably start using a view in the next few days. I will keep you informed about the results.

For info, after creating the origional view, I also could not see the view in the query browser. That problem is gone as well. So I do not exclude that the noticed problems are gone as a result of a restart. I simply do not know.

Sincerely,

Louis

Any your comments on this report are welcomed.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".