yiisoft/yii — Issue #449: CDbHttpSession quoting table name
Author: redguy666
Created: 2012-03-05 12:56:26+00:00
State: open

There are problem when using CDbHttpSession with db engine that is case sensitive when table name/alias is provided in quotes (postgresql, oracle).

Some functions reference table name without quotes (creating table, GC, destroysession, etc), but there are some function that use command builder which put table name in quotes (regenerateId has: $db->createCommand()->insert(...) reference for egzample).

there would be no problem if default table name do not have camelCase name (YiiSession) but lower-case name (yiisession), or if everywhere there was quoting applied. In my opinion - there could be quoting everywhere, and creating a session table should use standard interface Yii::app()->db->schema->createTable() to be DBMS independent...