home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #3 / NN_1993_3.iso / spool / comp / database / sybase / 767 < prev    next >
Encoding:
Text File  |  1993-01-28  |  1.9 KB  |  73 lines
  1. Newsgroups: comp.databases.sybase
  2. Path: sparky!uunet!ukma!gatech!concert!glv!usenet
  3. From: bob@bobsled.glv.com (Bob Lunney)
  4. Subject: Re: patindex broken between 4.2 and 4.8
  5. Message-ID: <1993Jan28.195104.10557@glv.uucp>
  6. Keywords: patindex, bugs
  7. Sender: usenet@glv.uucp
  8. Nntp-Posting-Host: bobsled
  9. Organization: Encompass
  10. References: <1993Jan28.154119@genethon.fr>
  11. Date: Thu, 28 Jan 1993 19:51:04 GMT
  12. Lines: 59
  13.  
  14. In article <1993Jan28.154119@genethon.fr> stuart@genethon.fr (Stuart Pook)  
  15. writes:
  16. > 
  17. > Has anybody noticed that patindex has been broken
  18. > between Sybase versions 4.2 and 4.8?  The following
  19. > scripts illustrate how patindex used to be correct
  20. > (under 4.2) and how it now gives the wrong result.
  21. > 
  22. > Does the same problem exist under 4.9?
  23. > 
  24. > $ sql -SGENGDB
  25. > 1> select @@version
  26. > 2> go
  27. >                                                                    
  28. >  ----------------------------------------------------------------- 
  29. >  SQL Server/4.2/P/sun4/os4/EBF632/OPT/Tue Aug 27 11:58:42 PDT 1991 
  30. > 
  31. > (1 row affected)
  32. > 1> select patindex("%[^0]%", "000")
  33. > 2> go
  34. >              
  35. >  ----------- 
  36. >            0 
  37. > 
  38. > (1 row affected)
  39. > 
  40. > $ sql -SGENETHON
  41. > 1> select @@version
  42. > 2> go
  43. >                                                                        
  44. >  --------------------------------------------------------------------- 
  45. >  SQL Server/4.8/P/Sun 4/SunOS 4.1.X/5/OPT/Fri Apr 24 10:15:10 PDT 1992 
  46. > 
  47. > (1 row affected)
  48. > 1> select patindex("%[^0]%", "000")
  49. > 2> go
  50. >              
  51. >  ----------- 
  52. >            3 
  53. > 
  54. > (1 row affected)
  55.  
  56.  
  57. Works fine on our VAXes:
  58.  
  59. 1> select @@version
  60. 2> go
  61.                                                               
  62.  ------------------------------------------------------------ 
  63.  SQL Server/4.8/EBF1068/VMS/5.4-1A+/5/30-SEP-1992 14:08:42.15 
  64.  
  65. (1 row affected)
  66. 1> select patindex("%[^0]%", "000")
  67. 2> go
  68.              
  69.  ----------- 
  70.            0 
  71.  
  72. (1 row affected)
  73.