oracle10.1.0.4.0bug
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
SQL> select rownum from dual connect by rownum<=20;
ROWNUM
----------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
20 rows selected
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production
SQL> select rownum from dual connect by rownum<=20;
ROWNUM
----------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
ROWNUM
----------
21
21 rows selected
/*--------
该问题在10g release2 被解决了
http://www.itpub.net/showthread.php?s=&postid=5467062#post5467062
---------*/
10.1.0.3、10.1.0.5也是如此，但在10.2.0.1中是正确的
SQL> select rownum from dual connect by rownum <= 20;
ROWNUM
----------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
20 rows selected
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-242216/ ，如需转载，请注明出处，否则将追究法律责任。
