"nzkoz" has given AR/SQLServer some love, but it's
still unhappy...
http://dev.
rubyonrails.org/changeset/7399
------------------------------------------------------------
------------
r7399 | nzkoz | 2007-09-02 16:52:58 -0700 (Sun, 02 Sep 2007)
| 2 lines
Ensure QueryCache doesn't try to dup numeric results (does
not affect the major OS database). Closes #7661 [tomafro,
nzkoz]
------------------------------------------------------------
------------
U activerecordtestquery_cache_test.rb
U activerecordlibactive_recordquery_cache.rb
Updated to revision 7399.
1) Error:
test_saves_both_date_and_time(DateTimeTest):
ArgumentError: argument out of range
./test/../lib/active_record/connection_adapters/sqlserver_ad
apter.rb:106:in `mktime'
./test/../lib/active_record/connection_adapters/sqlserver_ad
apter.rb:106:in `cast_to_datetime'
./test/../lib/active_record/connection_adapters/sqlserver_ad
apter.rb:79:in `type_cast'
./test/../lib/active_record/attribute_methods.rb:186:in
`read_attribute'
./test/../lib/active_record/base.rb:2148:in `send'
./test/../lib/active_record/base.rb:2148:in
`clone_attribute_value'
./test/../lib/active_record/base.rb:2142:in
`clone_attributes'
./test/../lib/active_record/attribute_methods.rb:128:in
`inject'
./test/../lib/active_record/base.rb:2141:in `each'
./test/../lib/active_record/base.rb:2141:in `inject'
./test/../lib/active_record/base.rb:2141:in
`clone_attributes'
./test/../lib/active_record/base.rb:1842:in
`attributes'
./test/../lib/active_record/base.rb:2026:in
`attributes_with_quotes'
./test/../lib/active_record/base.rb:2118:in
`quoted_column_names'
./test/../lib/active_record/base.rb:1975:in
`create_without_callbacks'
./test/../lib/active_record/callbacks.rb:226:in
`create_without_timestamps'
./test/../lib/active_record/timestamp.rb:29:in `create'
./test/../lib/active_record/base.rb:1951:in
`create_or_update_without_callbacks'
./test/../lib/active_record/callbacks.rb:213:in
`create_or_update'
./test/../lib/active_record/base.rb:1711:in
`save_without_validation!'
./test/../lib/active_record/validations.rb:890:in
`save_without_transactions!'
./test/../lib/active_record/transactions.rb:109:in
`save!'
./test/../lib/active_record/connection_adapters/abstract/dat
abase_statements.rb:59:in `transaction'
./test/../lib/active_record/transactions.rb:77:in
`transaction'
./test/../lib/active_record/transactions.rb:97:in
`transaction'
./test/../lib/active_record/transactions.rb:109:in
`save!'
./test/../lib/active_record/transactions.rb:117:in
`rollback_active_record_state!'
./test/../lib/active_record/transactions.rb:109:in
`save!'
./test/date_time_test.rb:11:in
`test_saves_both_date_and_time'
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_ca
se_adapter.rb:19:in `__send__'
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_ca
se_adapter.rb:19:in `run'
2) Error:
test_limited_eager_with_multiple_order_columns(EagerAssociat
ionTest):
ActiveRecord::StatementInvalid: DBI: atabaseE
rror: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for
SQL Server
ORDER BY items must appear in the select list if
SELECT DISTINCT is specified.
HRESULT error code:0x80020009
Exception occurred.: SELECT * FROM (SELECT TOP 2 *
FROM (SELECT DISTINCT TOP 3 posts.id FROM posts LEFT OUTER
JOIN authors ON authors.id = posts.author_id LEFT OUTER
JOIN comments ON comments.post_id = posts.id WHERE
(authors.name = 'David') ORDER BY UPPER(posts.title),
posts.id) AS tmp1 ORDER BY title DESC, id DESC) AS tmp2
ORDER BY title, id
./test/../lib/active_record/connection_adapters/abstract_ada
pter.rb:135:in `log'
./test/../lib/active_record/connection_adapters/sqlserver_ad
apter.rb:321:in `execute_without_counting'
./test/abstract_unit.rb:71:in `execute'
./test/../lib/active_record/connection_adapters/sqlserver_ad
apter.rb:517:in `select'
./test/../lib/active_record/connection_adapters/abstract/dat
abase_statements.rb:7:in `select_all'
./test/../lib/active_record/associations.rb:1312:in
`select_limited_ids_list'
./test/../lib/active_record/associations.rb:1304:in
`add_limited_ids_condition!'
./test/../lib/active_record/associations.rb:1293:in
`construct_finder_sql_with_included_associations'
./test/../lib/active_record/associations.rb:1281:in
`select_all_rows'
./test/../lib/active_record/associations.rb:1137:in
`find_with_associations'
./test/../lib/active_record/associations.rb:1135:in
`catch'
./test/../lib/active_record/associations.rb:1135:in
`find_with_associations'
./test/../lib/active_record/base.rb:998:in `find_every'
./test/../lib/active_record/base.rb:429:in `find'
./test/associations/eager_test.rb:313:in
`test_limited_eager_with_multiple_order_columns'
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_ca
se_adapter.rb:19:in `__send__'
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_ca
se_adapter.rb:19:in `run'
3) Error:
test_limited_eager_with_order(EagerAssociationTest):
ActiveRecord::StatementInvalid: DBI:atabaseE
rror: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for
SQL Server
ORDER BY items must appear in the select list if
SELECT DISTINCT is specified.
HRESULT error code:0x80020009
Exception occurred.: SELECT * FROM (SELECT TOP 2 *
FROM (SELECT DISTINCT TOP 3 posts.id FROM posts LEFT OUTER
JOIN authors ON authors.id = posts.author_id LEFT OUTER
JOIN comments ON comments.post_id = posts.id WHERE
(authors.name = 'David') ORDER BY UPPER(posts.title)) AS
tmp1 ORDER BY title DESC) AS tmp2 ORDER BY title
./test/../lib/active_record/connection_adapters/abstract_ada
pter.rb:135:in `log'
./test/../lib/active_record/connection_adapters/sqlserver_ad
apter.rb:321:in `execute_without_counting'
./test/abstract_unit.rb:71:in `execute'
./test/../lib/active_record/connection_adapters/sqlserver_ad
apter.rb:517:in `select'
./test/../lib/active_record/connection_adapters/abstract/dat
abase_statements.rb:7:in `select_all'
./test/../lib/active_record/associations.rb:1312:in
`select_limited_ids_list'
./test/../lib/active_record/associations.rb:1304:in
`add_limited_ids_condition!'
./test/../lib/active_record/associations.rb:1293:in
`construct_finder_sql_with_included_associations'
./test/../lib/active_record/associations.rb:1281:in
`select_all_rows'
./test/../lib/active_record/associations.rb:1137:in
`find_with_associations'
./test/../lib/active_record/associations.rb:1135:in
`catch'
./test/../lib/active_record/associations.rb:1135:in
`find_with_associations'
./test/../lib/active_record/base.rb:998:in `find_every'
./test/../lib/active_record/base.rb:429:in `find'
./test/associations/eager_test.rb:308:in
`test_limited_eager_with_order'
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_ca
se_adapter.rb:19:in `__send__'
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_ca
se_adapter.rb:19:in `run'
4) Error:
test_attributes(FixturesTest):
ActiveRecord::StatementInvalid: DBI:atabaseE
rror: Not enough SQL parameters: INSERT INTO binaries ([id],
[data]) VALUES (1, 'ÿØÿà%02 JFIF%02
%02H%02H%02%02ÿÛ%02C%02 %01 %00 %03
%03 $.'' ",# (7),01444 ''9=82<.342ÿÛ%02C
%00%00 2!
!22222222222222222222222222222222222222222222222222ÿÀ%02 ^
"%02 ÿÄ%02 %02%02
%02%02%02%02%02%02%02%02%02%02 ÿÄ%02E %02
%02 %02 !1A Qa"q 2'¡±Á #BÑ$Rbá3rðñ
C%4Scs,'¢D²ÒÿÄ%02%03 %02
%02%02%02%02%02%02%02%02%02%02%02 ÿÄ%02+ %02
%02%02%02%02%02 ! 1 A Q"2 a¡ #B q'±ÿÚ%02 %02
%02?%02÷ú(¢EURO%01(¢EURO%01(¢EURO%01(¢EURO%01(ª·ú...|(tm)h÷W
· Á%01õw8ú Sí ª9§ŠÞ -gT ff8%02%01A§ø²ÓZŠåôýÁ`--Ës Áè
8ô9ïéR |ýÄ¿(tm)Øóš ámïþ$hÖÒ g¹ ÿ%02Q øžOÐTpøÍõ
-lѨÇôŒã瞟...}1/4ðö‹q ´ö0|rZDø Ï""iú]žžÒý'6 Çþ$„
aØ{%01"í{ S Í(c)ßMÏÚe%02õ ýª3/4 fe>lŽÜ÷$ñøÔ<<·
1žø(r)F IùÔ› "1/4É(·"È`fÚ|1/2Ã#v8ÍA§ [U¶k--7
eÛ'ÎrqÏ1/2]i "Æ>¢³ž ±:(c)(tm)|gÃ;yŒ ñƒë[ zF 3/4
-ž¿táZ Ù NvŒîÎ8=hÔ|yy£4&âÍn"rAa"9ô¬Å¥
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-coregooglegroups.com
To unsubscribe from this group, send email to
rubyonrails-core-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---
|