Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Tools    [ Add a report in this area ]  
Report #:  121286   Status: Need Feedback
Developer version of Interbase different in parser then production!
Project:  InterBase Build #:  WI-V10.0.5.595
Version:    10.0 Submitted By:   Karol Bieniaszewski
Report Type:  Crash / Data loss / Total failure Date Reported:  12/20/2013 12:19:31 AM
Severity:    Critical / Show Stopper Last Updated: 2/5/2014 5:50:30 PM
Platform:    Windows 95/98/NT 4.0 on Intel Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
Only developer version of Interbase is affected
production servers work ok (raise parser error)

there is one difference between production and server
on developer version is 32bit on Win7 64bit
on production version is 64bit and Win 2008 R2 Ent


Steps to Reproduce:
on LOCAL instalation of DEVELOPER version of Interbase XE

try this query

SELECT * FROM EMPLOYEE E WHERE E.EMP_NO=11 ddd and E.JOB_GRADE=2

as you can see after  E.EMP_NO=11
is hard space code #$160 (Alt + 0160) - converted by delphi to unicode C2A0
and unrecognized string ddd
but server run this query without problem!

on production server it raise parser error "tocken unknow"

the same is here - more intresting becouse you think that you get E.EMP_NO=11222 but query run against E.EMP_NO=11 without errors!

SELECT * FROM EMPLOYEE E WHERE E.EMP_NO=11 222 and E.JOB_GRADE=2


Now i do not beleve in any tests on developer version :(
Workarounds
None
Attachment
None
Comments

Karol Bieniaszewski at 2/4/2014 11:34:40 PM -
>>Karol,
>>- Are you using IBConsole or some other tool (please specify) to run the problem query?

I test this with IBConsole, my database manager application and real production delphi application
all results are the same

>>- are you setting your client-side character set explicitely (LC_CTYPE, LC_CSET)? I wonder if this is making the parser think it is Unicode string.

For my programs i have WIN1250
For test in IBConsole with my database also WIN1250
For test in IBConsole with Employee database i use NONE

Windows7 and Windows 2008 Server R2 have locale set to POLISH

>>- Do you run the Delphi program unmodified against both the Developer Edition server, and, the production Server of InterBase XE?

Yes - without modifications

Server Response from: ETNACODE01