这象不象10201的BUG？

carny · 发表于 2006-2-26 21:44

10G R2 10.2.0.2 linux patchset 已出
去download 來, patch 一下
吧

biti_rainy · 发表于 2006-5-16 15:13

[admin@forum2 admin]$ sql

SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 16 15:12:32 2006

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters and Data Mining options

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0    Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

SQL>
SQL>  declare
  2 strPPState varchar2(10);
  3 begin
  4 select max(('')) into strPPState from dual;
  5 --dbms_output.put_line(to_char(strPPState));
  6 dbms_output.put_line(strPPState);
  7 end;
  8  /

PL/SQL procedure successfully completed.

SQL>

richking · 发表于 2006-5-16 16:44

SQL> declare
  2 strPPState varchar2(10);
  3 begin
  4 select max(('')) into strPPState from dual;
  5 --dbms_output.put_line(to_char(strPPState));
  6 dbms_output.put_line(strPPState);
  7 end;
  8  /

PL/SQL procedure successfully completed.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0    Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

ZALBB · 发表于 2006-5-17 09:47

最初由 richking 发布
[B]SQL> declare
  2 strPPState varchar2(10);
  3 begin
  4 select max(('')) into strPPState from dual;
  5 --dbms_output.put_line(to_char(strPPState));
  6 dbms_output.put_line(strPPState);
  7 end;
  8  /

PL/SQL procedure successfully completed.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0    Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production [/B]

你是在作测试吗？你看清楚我的例子了？

richking · 发表于 2006-5-17 12:03

最初由 ZALBB 发布
[B]

你是在作测试吗？你看清楚我的例子了？ [/B]

兄弟，人总有犯错误的时候，但是你也不要用这种口气说话好不好？

biti_rainy · 发表于 2006-5-17 12:08

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0    Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

SQL> declare
  2 strPPState varchar2(10);
  3 begin
  4 select max(('1')) into strPPState from dual;
  5 --dbms_output.put_line(to_char(strPPState));
  6 dbms_output.put_line(strPPState);
  7 end;
  8
  9  /

PL/SQL procedure successfully completed.

SQL>

ZALBB · 发表于 2006-5-18 11:09

最初由 richking 发布
[B]

兄弟，人总有犯错误的时候，但是你也不要用这种口气说话好不好？ [/B]

抱歉。看到你犯这么简单的错误，我生气了。

husthxd · 发表于 2006-8-30 10:55

最初由 xzh2000 发布
[B]哎,不算是什么bug,应该是10g中隐式数据类型转换改变有关... [/B]

this is a bug..

[原创] 这象不象10201的BUG？