search

patoui / laravel-clickhouse

An Eloquent model and Query builder with support for Clickhouse using the SeasClick (https://github.com/seasx/seasclick) extension.
MIT License
8 stars 2 forks source link

problem with Bool type and with null #1

Open ArtemYurov opened 5 days ago

ArtemYurov commented 5 days ago

i create table with:

applicable  Bool,

when i try to do

...::create([
  "applicable" => true,
  ]);

i get error

  ErrorException 

  array_flip(): Can only flip string and integer values, entry skipped

  at vendor/patoui/laravel-clickhouse/src/ClickhouseConnection.php:266

also if i do

...::create([
  "applicable" => 1,
  ]);

i get error

 Exception 

  unsupported column type: Bool
ArtemYurov commented 5 days ago

also 

state_moysklad_id           UUID            DEFAULT NULL,

"state_id" => null,

get error array_flip(): Can only flip string and integer values, entry skipped

ArtemYurov commented 5 days ago

also if do ::where(...)->update(...) where some values is null get error:

 DB::Exception: Syntax error: failed at position 277 (','): , "description" = , 

   at vendor/patoui/laravel-clickhouse/src/ClickhouseConnection.php:133