#20 Incorrect creation of sql query with order by cluase

[Giovanni Martone]

Let's image a query composed as shown below:

SELECT <fields_list> FROM <table> ORDER BY
<fields_list <type_ordering>

SqlStatement classe creates an incorrect sql query as
shown below:

SELECT <fields_list> FROM <table> WHERE ORDER
BY <fields_list <type_ordering>

Example code is shown below:

SelectCriteria selectCriteria = new
SelectCriteria("clients");
selectCriteria.addOrderBy("mcagrp",true);
QueryResults results = database.select("clients",
selectCriteria);

produces:

SELECT id_client,mcaGrp,mcades FROM clients
WHERE ORDER BY mcaGrp ASC