/
germanubis
/
sqlx
Обзор
Документация
Войти
/
germanubis
/
sqlx
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
tests/mssql/types.rs
50 строк
1 KB
Tobias Tschinkowitz
fix: mssql uses unsigned for tinyint instead of signed (#2074)
01 сен 2022, 04:10
Не верифицирован
01 сен 2022, 04:10
9de70d2
Код
Авторство
О чём код?
use sqlx::mssql::Mssql; use sqlx_test::test_type; test_type!(null<Option<i32>>(Mssql, "CAST(NULL as INT)" == None::<i32> )); test_type!(u8( Mssql, "CAST(5 AS TINYINT)" == 5_u8, "CAST(0 AS TINYINT)" == 0_u8, "CAST(255 AS TINYINT)" == 255_u8, )); test_type!(i8( Mssql, "CAST(5 AS TINYINT)" == 5_i8, "CAST(0 AS TINYINT)" == 0_i8 )); test_type!(i16(Mssql, "CAST(21415 AS SMALLINT)" == 21415_i16)); test_type!(i32(Mssql, "CAST(2141512 AS INT)" == 2141512_i32)); test_type!(i64(Mssql, "CAST(32324324432 AS BIGINT)" == 32324324432_i64)); test_type!(f32( Mssql, "CAST(3.1410000324249268 AS REAL)" == 3.141f32 as f64 as f32 )); test_type!(f64( Mssql, "CAST(939399419.1225182 AS FLOAT)" == 939399419.1225182_f64 )); test_type!(str_nvarchar<String>(Mssql, "CAST('this is foo' as NVARCHAR)" == "this is foo", )); test_type!(str<String>(Mssql, "'this is foo'" == "this is foo", "''" == "", )); test_type!(bool( Mssql, "CAST(1 as BIT)" == true, "CAST(0 as BIT)" == false ));