Yii 1.1.1 OCI does not have to quote names...

Archives Bug Discussions
1

Why have Oracle AR started to quote table and column names in 1.1.1 version? It simply doesn’t work…

I had to remove quoting to make it work.

2

No answer? This is a serious bug…

3

table alias is quote, column is not~

is confused~

4

Neither table or column names have to be quoted. Oracle just treat these as simple strings. It is not as in MySQL

5

If you think it’s a bug, fill an issue on the bug tracker

6

hi

i have the same problem

the error:

the command:

if put

work fine

is solved in the next release?

7

the solution is modify the class COciSchema

in framework/db/schema/oci

change the function




	public function quoteTableName($name)

	{

		//return '"'.$name.'"';

                return $name;

	}


	public function quoteColumnName($name)

	{

		//return '"'.$name.'"';

                return $name;

	}

in release r1825 is ok

in new release r1864 is bad

see

http://code.google.com/p/yii/source/diff?spec=svn2055&r=1864&format=side&path=/trunk/framework/db/schema/oci/COciSchema.php&old_path=/trunk/framework/db/schema/oci/COciSchema.php&old=1825

the motive is http://code.google.com/p/yii/issues/detail?id=988

but in oracle xe not work

sorry for my inglish