sqlserver

sqlserver copied to clipboard

fix: migrator force modification of fields with no default value

1

- [x] Do only one thing - [x] Non breaking API changes - [x] Tested ### What did this pull request do? `column.DefaultValueValue.Valid = true` causes almost all fields that...

iTanken

Bumps [gorm.io/gorm](https://github.com/go-gorm/gorm) from 1.25.7-0.20240204074919-46816ad31dde to 1.25.10. Commits See full diff in compare view [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter...

dependabot[bot]

Bumps [github.com/microsoft/go-mssqldb](https://github.com/microsoft/go-mssqldb) from 1.7.0 to 1.7.1. Release notes Sourced from github.com/microsoft/go-mssqldb's releases. v1.7.1 What's Changed fix: protocol version by @​srdan-bozovic-msft in microsoft/go-mssqldb#131 Implement Always Encrypted by @​shueybubbles in microsoft/go-mssqldb#116 Update...

dependabot[bot]

Cannot connect to SQL server using a # character in the password

1

Hi, I cannot find a way to connect using a password with a # in the password. The sqlstring is something like: `sqlserver://user:pass#word@theadress:23456?database=GENERIC"` This string would fail with an error...

dbkblk

DropTable的sql语法错了

1

```go err = conn.Db.Migrator().DropTable(&a) if err != nil { return } ``` 跟踪到sql执行的是 ```sql DROP TABLE IF EXISTS "AppDict" ```

cnwangfei

https://github.com/go-gorm/sqlserver/blob/ef8f762cc01457cd331d3d93cf5648f2d8dc5661/sqlserver.go#L188-L202 - https://learn.microsoft.com/zh-cn/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver16 Because in SQL Server, the range of values for the `tinyint` type is from `0` to `255`, which exactly matches the range of `uint8`, so when `field.Size...

iTanken

`Migrator().DropTable( &item{})` is not working properly when implementing `item.TableName()` and returning a name containing a schema, e.g: ``` type item struct { Name string } func (i *item)TableName() string {return...

hhindriks

MERGE queries shouldn't require primary key setting.

5

## Describe the feature Merge (upsert) queries currently require all of the columns in `clause.Conflict.Columns` to be primary keys, otherwise it silently falls back to a regular insert. A table...

sblackstone

Hello, I've noticed an issue with the way GORM maps Go's int8 and int16 types to SQL Server types. In the current implementation, int8 is mapped to smallint and int16...

Yunaido

https://learn.microsoft.com/en-us/archive/blogs/sqltips/output-clause-in-insertupdatedelete-statements the sqlalchermy implementation https://docs.sqlalchemy.org/en/20/core/connections.html#correlating-returning-rows-to-parameter-sets

magengbin