From 22a38c6a86bc6323f7aa1fd3179a9f8ed7591267 Mon Sep 17 00:00:00 2001 From: Aaron Patterson Date: Fri, 5 Nov 2010 14:28:36 -0700 Subject: mysql selects from dual on empty from statements --- test/visitors/test_mysql.rb | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'test') diff --git a/test/visitors/test_mysql.rb b/test/visitors/test_mysql.rb index 1d38161caf..871d662d4b 100644 --- a/test/visitors/test_mysql.rb +++ b/test/visitors/test_mysql.rb @@ -14,7 +14,13 @@ module Arel stmt = Nodes::SelectStatement.new stmt.offset = Nodes::Offset.new(1) sql = @visitor.accept(stmt) - sql.must_be_like "SELECT LIMIT 18446744073709551615 OFFSET 1" + sql.must_be_like "SELECT FROM DUAL LIMIT 18446744073709551615 OFFSET 1" + end + + it 'uses DUAL for empty from' do + stmt = Nodes::SelectStatement.new + sql = @visitor.accept(stmt) + sql.must_be_like "SELECT FROM DUAL" end end end -- cgit v1.2.3