Hello,
when i use the sql bundle to create a mysql view such as the following:
CREATE VIEW cp_qry_offset AS select O.offset_id, O.account_id, O.calculation_id O.quantity, O.type,
T.description as type_description from cp_offset O
join cp_offset_type T on O.type = T.type_id
for reasons unknown to me, but suspiciously related to the sql bundle's habit of returning 10 rows of a select at a time in the database browser, it seems the bundle is appending:
limit 0,10
to the view definition.
which means i then have to edit the view with another tool to remove this limit before it will work
do you know why that is happening?
i'm guessing its related to this in db_browser.rb in the sql bundle, but i don't know how to change it
if not query=~ /\bLIMIT\b/i and run_query =~ /\s*SELECT/i run_query << ' LIMIT %d OFFSET %d' % [@page_size, offset] @limited = false end
can anyone help?
thanks mathew