Skip to content

binary(n) aka binary_basic Not Working Properly #1248

@slavad

Description

@slavad

Issue

binary(n) is loaded from schema/migrations always as binary(1)

Expected behavior

It should be created as binary(n) in the db, (e.g. binary(2), binary(8) etc)

Actual behavior

For all binary with n > 1 it's always created as binary(1)

How to reproduce

run this

  create_table "test_table", id: false, force: :cascade do |t|
    t.binary_basic "test_col", limit: 16
  end

or this migration

 add_column :test_table, :other_column, :binary_basic, limit: 16

Details

  • Rails version: 3.3.0
  • SQL Server adapter version: 7.2.1
  • TinyTDS version: 2.1.7
  • FreeTDS details: 1.3.17
Compile-time settings (established with the "configure" script)
                           Version: freetds v1.3.17
            freetds.conf directory: /etc/freetds
    MS db-lib source compatibility: no
       Sybase binary compatibility: yes
                     Thread safety: yes
                     iconv library: yes
                       TDS version: auto
                             iODBC: no
                          unixodbc: yes
             SSPI "trusted" logins: no
                          Kerberos: yes
                           OpenSSL: no
                            GnuTLS: yes
                              MARS: yes

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions