mysql selects from dual on empty from statements

1 files changed, 7 insertions, 1 deletions

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