activerecord-cockroachdb-adapter
activerecord-cockroachdb-adapter copied to clipboard
cockroachdb
CockroachDB adapter for ActiveRecord.
``` Failure: PostgresqlTypeLookupTest#test_range_types_correctly_respect_registration_of_subtypes [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/type_lookup_test.rb:32]: ActiveModel::RangeError expected but nothing was raised. bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/type_lookup_test.rb:27 Error: PostgresqlTypeLookupTest#test_array_delimiters_are_looked_up_correctly: NoMethodError: undefined method `delimiter' for # Did you mean? limit /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/type_lookup_test.rb:14:in `block in ' bin/rails...
``` Failure: PostgresqlInfinityTest#test_update_all_with_infinity_on_a_datetime_column [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/infinity_test.rb:70]: --- expected +++ actual @@ -1 +1 @@ -Infinity +-292277022365-05-08 08:17:07 UTC bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/infinity_test.rb:66 Failure: PostgresqlInfinityTest#test_update_all_with_infinity_on_a_float_column [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/infinity_test.rb:43]: Expected: Infinity Actual: 0.0 bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/infinity_test.rb:39 Failure:...
``` Error: PostgresqlDataTypeTest#test_time_values: ActiveRecord::StatementInvalid: PG::InvalidDatetimeFormat: ERROR: could not parse "1 year 2 days ago" as type interval: interval: missing unit at position 14: "1 year 2 days ago" : INSERT...
``` Failure: PostgresqlCaseInsensitiveTest#test_case_insensitiveness [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb:14]: Expected /lower/i to match "\"defaults\".\"char1\" IS NULL". bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/case_insensitive_test.rb:8 ``` See the [Contributing Guide](https://github.com/cockroachdb/activerecord-cockroachdb-adapter/blob/master/CONTRIBUTING.md#setup-and-running-tests) for instructions on running tests. If the test isn't valid against...
``` Error: PostgresqlByteaTest#test_via_to_sql_with_complicating_connection: ActiveRecord::StatementInvalid: PG::InvalidParameterValue: ERROR: invalid value for parameter "standard_conforming_strings": "off" DETAIL: this parameter is currently recognized only for compatibility and has no effect in CockroachDB. HINT: Available values:...
``` Failure: PostgresqlBitStringTest#test_schema_dumping [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/bit_string_test.rb:58]: Expected /t\.bit\s+"a_bit",\s+limit: 8,\s+default: "00000011"$/ to match "# This file is auto-generated from the current state of the database. Instead\n# of editing this file, please use the...
``` Failure: ActiveRecord::ConnectionAdapters::PostgreSQLAdapterTest#test_default_sequence_name_bad_table [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/postgresql_adapter_test.rb:94]: Expected: "zomg_id_seq" Actual: nil bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/postgresql_adapter_test.rb:93 Error: ActiveRecord::ConnectionAdapters::PostgreSQLAdapterTest#test_exec_insert_with_returning_disabled_and_no_sequence_name_given: ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "postgresql_partitioned_table_parent" does not exist : insert into postgresql_partitioned_table_parent (number) VALUES (1) /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `exec_params'...
With savepoint support coming in 20.1, the customizations this library does around savepoints are no longer needed (for the new crdb version). They seem to break nested transactions. At least:...
https://github.com/cockroachdb/cockroach/issues/9682 suggests cockroachdb does not support `CREATE UNIQUE INDEX "index_users_on_login" ON "users" (LOWER("login"))` need to find some way to filter this in the adapter.
https://github.com/cockroachdb/cockroach/issues/32098 shows that Cockroachdb does not support timestamp precision (limit). The most obvious workaround is to create the schema without a limit, e.g. remove the (#) from timestamp field on...