[DataBase][Oracle]Oracle使用函数索引的一个bug
使用了函数索引, 结果导致执行计划走索引而不采用全表扫描, 从而返回错误结果.
字段为char类型，修改为varchar就不会有这个问题
此文待完善.
可参考:
奋斗中...
曾经的程序员。ASP.NET/C#, JavaScript, PL/SQL, T-SQL; 工具: VS2003/2005, Oracle, SQLServer; 偶尔写点CSS, 批处理.
头脑中经常有新想法, 可惜没有去实现.
Never give up.
Never get into a fight with a pig. Both of you will get dirty. But the pig actually enjoys it.
头脑中经常有新想法, 可惜没有去实现.
Never give up.
Never get into a fight with a pig. Both of you will get dirty. But the pig actually enjoys it.
浙公网安备 33010602011771号