[prev in list] [next in list] [prev in thread] [next in thread]
List: sapdb-general
Subject: RE: Query about like command
From: "Zabach, Elke" <elke.zabach () sap ! com>
Date: 2003-07-10 10:15:30
[Download RAW message or body]
Yusuf Gangat wrote:
> We have just installed version 7.4.3.10 of the database and I am having
> a problem with a simple sql query that worked in our older version.
> The query is : SELECT * FROM STATUS WHERE DESCRIPTION LIKE ‘A*’.
> This brings back no result. If I try :
> SELECT * FROM STATUS WHERE DESCRIPTION LIKE ‘A%’ it brings back results.
> Even though the second query works our software uses the first query with
> the ‘*’ wildcard character. Is this a bug that has been fixed in a later version.
With 7.4.3.10 * and % were the same.
But as we wrote several times (could be found in the archive!):
Because of our main customer (our own company) we had to change
the like-predicate according to SQL92-standard, meaning that only
'%' and '_' as written in the docs
<http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/frameset.htm> \
http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/frameset.htm are \
handled starting with 7.4.3.17.
--> I do not believe that you installed 7.4.3.10
It is no bug, it is a feature
It will not rollbacked
Elke
SAP Labs Berlin
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<META content=Word.Document name=ProgId>
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<META content="Microsoft Word 10" name=Originator><LINK
href="cid:filelist.xml@01C346DA.E904B300" rel=File-List><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<STYLE>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</STYLE>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]--></HEAD>
<BODY lang=EN-US style="tab-interval: .5in" vLink=purple link=blue>
<DIV><FONT color=#0000ff><FONT size=2><FONT face=Tahoma>Yusuf Gangat <SPAN
class=512391210-10072003>wrote:</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff><FONT size=2><FONT face=Tahoma><SPAN
class=512391210-10072003></SPAN></FONT><BR>> We have just installed version
7.4.3.10 of the database and I am having <BR>> a problem with a simple
sql query that worked in our older version. <BR>> The query is : SELECT *
FROM STATUS WHERE DESCRIPTION LIKE ‘A*’. <BR>> This brings back no result. If
I try : <BR>> SELECT * FROM STATUS WHERE DESCRIPTION LIKE ‘A%’ it brings back
results. <BR>> Even though the second query works our software uses the first
query with <BR>> the ‘*’ wildcard character. Is this a bug that has been
fixed in a later version.</FONT></FONT></DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=512391210-10072003><FONT color=#0000ff size=2>With 7.4.3.10 *
and % were the same.</FONT></SPAN></DIV>
<DIV><SPAN class=512391210-10072003><FONT color=#0000ff size=2>But as we wrote
several times (could be found in the archive!):</FONT></SPAN></DIV>
<DIV><SPAN class=512391210-10072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=512391210-10072003><FONT face=Tahoma>Because of our main
customer (our own company) we had to change<BR>the like-predicate according to
SQL92-standard, meaning that only<BR>'%' and '_' as written in the docs <BR><A
href="http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/frameset.htm"><FONT \
color=#606420>http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/frameset.htm</FONT></A><BR>are \
handled starting with 7.4.3.17.<BR></FONT></SPAN></DIV>
<DIV><SPAN class=512391210-10072003><FONT><FONT size=2><FONT
color=#0000ff>--> I do not</FONT> <FONT color=#0000ff>believe that you
installed 7.4.3.10</FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=512391210-10072003><FONT><FONT color=#0000ff
size=2> It is no bug, it is a
feature</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=512391210-10072003><FONT><FONT color=#0000ff
size=2> It will not
rollbacked</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=512391210-10072003><FONT><FONT color=#0000ff
size=2></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=512391210-10072003><FONT><FONT color=#0000ff
size=2>Elke</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=512391210-10072003><FONT><FONT color=#0000ff size=2>SAP Labs
Berlin</FONT></DIV></FONT></SPAN></BODY></HTML>
_______________________________________________
sapdb.general mailing list
sapdb.general@listserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic