diff options
author | Emilio Tagua <miloops@gmail.com> | 2010-03-01 12:51:44 -0300 |
---|---|---|
committer | Emilio Tagua <miloops@gmail.com> | 2010-03-01 12:51:44 -0300 |
commit | 1994d3e61dd841ad1367922c5c608c9f5f277161 (patch) | |
tree | bd99d1f86aba5094871507fb20b4beefdcf5e741 /spec/arel/engines/sql/unit | |
parent | 52b9eb1d8dea2615a8ff6182278dc53e1cf33c1d (diff) | |
download | rails-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.rb | 12 | ||||
-rw-r--r-- | spec/arel/engines/sql/unit/relations/table_spec.rb | 4 |
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 |