主题 : oracle版的一个BUG |
级别: 商业授权用户
|
1# 发表于:2018-03-23 16:34:52 IP:222.216.*.*
|
||||
---|---|---|---|---|---|
级别: 商业授权用户
|
3# 发表于:2018-03-23 16:43:36 IP:222.216.*.*
数据中心--网站概况--内容发布数,其他功能还没测试,应该类似统计的地方都存在,8.1版本也有这个问题
|
||
---|---|---|---|
级别: 商业授权用户
|
4# 发表于:2018-03-23 16:44:22 IP:222.216.*.*
回复第2楼
最近升级到9.3发现的,以前用8.1的时候没发现,不过我看了老版本也有这个问题 |
||
---|---|---|---|
级别: 商业授权用户
|
8# 发表于:2018-03-23 16:47:23 IP:222.216.*.*
Caused by: java.sql.SQLException: ORA-30076: 对析出来源无效的析出字段
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) |
||
---|---|---|---|
级别: 商业授权用户
|
9# 发表于:2018-03-23 16:48:09 IP:222.216.*.*
Hibernate:
select count(content0_.content_id) as col_0_0_, extract(hour from contentext1_.release_date) as col_1_0_ from jc_content content0_ inner join jc_content_ext contentext1_ on content0_.content_id=contentext1_.content_id where content0_.site_id=? and contentext1_.release_date>=? and contentext1_.release_date<=? and content0_.status=? group by extract(hour from contentext1_.release_date) order by extract(hour from contentext1_.release_date) asc |
||
---|---|---|---|