lib/blazer/adapters/sql_adapter.rb in sql-jarvis-2.0.3 vs lib/blazer/adapters/sql_adapter.rb in sql-jarvis-2.0.4
- old
+ new
@@ -54,10 +54,10 @@
if postgresql?
"SELECT * FROM \"{table}\" LIMIT 10"
elsif sqlserver?
"SELECT TOP (10) * FROM {table}"
else
- "SELECT * FROM {table} LIMIT 10"
+ "SELECT *\nFROM {table}\nORDER BY id DESC\nLIMIT 10"
end
end
def reconnect
connection_model.establish_connection(settings["url"])