Alexander Makarov
Alexander Makarov
It's not the same for all databases we support. Need a research at least for: - MySQL. - Cubrid. - MSSQL. - Oracle. - PostgreSQL. - SQLite. Also it would...
@klimov-paul these aren't equal in MySQL but yes, generally I don't think we'll support non-standard SQL for each database.
Related to https://github.com/yiisoft/yii2/issues/13879
@swartzlib7 it's planned for 2.1.
Done for insert (not batch).
That would potentially hurt ability to adjust table rapidly during development, right?
So the following could be a solution: 1. Create a console command that can dump schema to a file. 2. Add ability to use the file *instead of* getting fresh...
It's [part of SQL99](https://mariadb.com/kb/en/sql-99/sqls-case-expression/) so likely to supported by all DBs we have. A shortcut could be introduced...
``` php $c = new \yii\db\Case()->when("1>0")->then(true)->else(false); $query->select(['c' => $c])->... ```
@rob006 what's constructor argument in the 2nd argument for? Yeah, can't use `Case` :( Need another name. Probably `CaseQuery` would do.