aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/engines/sql/unit
diff options
context:
space:
mode:
authorEmilio Tagua <miloops@gmail.com>2010-03-01 12:51:44 -0300
committerEmilio Tagua <miloops@gmail.com>2010-03-01 12:51:44 -0300
commit1994d3e61dd841ad1367922c5c608c9f5f277161 (patch)
treebd99d1f86aba5094871507fb20b4beefdcf5e741 /spec/arel/engines/sql/unit
parent52b9eb1d8dea2615a8ff6182278dc53e1cf33c1d (diff)
downloadrails-1994d3e61dd841ad1367922c5c608c9f5f277161.tar.gz
rails-1994d3e61dd841ad1367922c5c608c9f5f277161.tar.bz2
rails-1994d3e61dd841ad1367922c5c608c9f5f277161.zip
Remove " AS " keyword from table aliasing.
Diffstat (limited to 'spec/arel/engines/sql/unit')
-rw-r--r--spec/arel/engines/sql/unit/relations/join_spec.rb12
-rw-r--r--spec/arel/engines/sql/unit/relations/table_spec.rb4
2 files changed, 8 insertions, 8 deletions
diff --git a/spec/arel/engines/sql/unit/relations/join_spec.rb b/spec/arel/engines/sql/unit/relations/join_spec.rb
index 2d23a06397..cbbcb18244 100644
--- a/spec/arel/engines/sql/unit/relations/join_spec.rb
+++ b/spec/arel/engines/sql/unit/relations/join_spec.rb
@@ -52,7 +52,7 @@ module Arel
adapter_is :mysql do
sql.should be_like(%Q{
SELECT `super_users`.`id`, `super_users`.`name`, `photos`.`id`, `photos`.`user_id`, `photos`.`camera_id`
- FROM `users` AS `super_users`
+ FROM `users` `super_users`
INNER JOIN `photos` ON `super_users`.`id` = `photos`.`user_id`
})
end
@@ -68,7 +68,7 @@ module Arel
adapter_is_not :mysql, :oracle do
sql.should be_like(%Q{
SELECT "super_users"."id", "super_users"."name", "photos"."id", "photos"."user_id", "photos"."camera_id"
- FROM "users" AS "super_users"
+ FROM "users" "super_users"
INNER JOIN "photos" ON "super_users"."id" = "photos"."user_id"
})
end
@@ -82,8 +82,8 @@ module Arel
adapter_is :mysql do
sql.should be_like(%Q{
SELECT `super_users`.`id`, `super_users`.`name`, `super_photos`.`id`, `super_photos`.`user_id`, `super_photos`.`camera_id`
- FROM `users` AS `super_users`
- INNER JOIN `photos` AS `super_photos` ON `super_users`.`id` = `super_photos`.`user_id`
+ FROM `users` `super_users`
+ INNER JOIN `photos` `super_photos` ON `super_users`.`id` = `super_photos`.`user_id`
})
end
@@ -98,8 +98,8 @@ module Arel
adapter_is_not :mysql, :oracle do
sql.should be_like(%Q{
SELECT "super_users"."id", "super_users"."name", "super_photos"."id", "super_photos"."user_id", "super_photos"."camera_id"
- FROM "users" AS "super_users"
- INNER JOIN "photos" AS "super_photos" ON "super_users"."id" = "super_photos"."user_id"
+ FROM "users" "super_users"
+ INNER JOIN "photos" "super_photos" ON "super_users"."id" = "super_photos"."user_id"
})
end
end
diff --git a/spec/arel/engines/sql/unit/relations/table_spec.rb b/spec/arel/engines/sql/unit/relations/table_spec.rb
index e497e1b6c2..6afd9964a4 100644
--- a/spec/arel/engines/sql/unit/relations/table_spec.rb
+++ b/spec/arel/engines/sql/unit/relations/table_spec.rb
@@ -40,7 +40,7 @@ module Arel
adapter_is :mysql do
sql.should be_like(%Q{
SELECT `super_users`.`id`, `super_users`.`name`
- FROM `users` AS `super_users`
+ FROM `users` `super_users`
})
end
@@ -54,7 +54,7 @@ module Arel
adapter_is_not :mysql, :oracle do
sql.should be_like(%Q{
SELECT "super_users"."id", "super_users"."name"
- FROM "users" AS "super_users"
+ FROM "users" "super_users"
})
end
end