MySQL Bugs: #36622: LIMIT IN SELECT STATEMENT not recognised in XSD

Bug #36622	LIMIT IN SELECT STATEMENT not recognised in XSD
Submitted:	9 May 2008 11:04	Modified:	10 Jun 2008 14:28
Reporter:	R Roberts	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	5.2.1	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Hello

I am using VS 2005 C#. I am using SQLYog Community Edition v6.16. MySql server is 5.0. I am also using MySQL Connector/Net which is 5.2.1

I have an SQL statement that needs to be incorporated in the XSD using LIMIT.

I found that I get an error on the tableadapter wizard when clicking 'Next>' after putting
the SQL query.

The error states "Generated 'SELECT' statement; unable to parse query text.'.

I think it is a bug because it seems not to be accepting it. I have tried the sql text directly on the SQLYog Community Edition, it seems to be working alright and brings out the records fine.

Any ideas or suggestions please?

Thanks

How to repeat:
1.Create new table adapter on XSD

2. Put SQL text (Not stored Procedure)

i.e. SELECT a.ID,a.Desc,
From table a
ORDER BY a.ID ASC
LIMIT 100

3. Click "Next>", error appears.

Hi and thanks for your report.

Truly, I do see same error as you do at the end of wizard but I just clicked "Finish" and than "Preview data" and all works as expected... I'm attaching 250000 records table preview now.

Data retrieval window, all correct

Attachment: Bug36622.JPG (image/jpeg, text), 56.43 KiB.

Hi

That is interesting. I did not realise you can click 'Finish' rather than 'Next>'. 

I will give it a try now...

Thanks for your assistance.

Much appreciated.

No problem, waiting on your result.

This is not a bug for the same reason that bug # 36566 is not a bug.

It seems to be ok as Tonci suggested an approach for this.