sql - Same code executed on different servers (same version) yields different results -


issue delphi legacy code. added 1 line of code correct 1 error , created new error.

new error causing same executable yield different results on different servers(switched pointer dev prod environment on executable).

code:

sescapedstring:=stringreplace(sstringin,'[','''+char(27)+''[',[rfreplaceall]); sescapedstring:=stringreplace(sescapedstring,']','''+char(27)+'']',[rfreplaceall]); sescapedstring:=stringreplace(sescapedstring,'''','''''',[rfreplaceall]);// line created new  bug result:=' ''' + trim(sescapedstring) + '%'''+'  escape char(27) ';

when running code against dev query finds objects characters '[' , ']' in against prod query not find items:

the first thing checked data: identical in both cases second thing checked sql server versions (11.0.3128 on both servers) third thing checking settings on servers: dbcc useroptions; -- same on both select name, collation_name sys.databases -- same on both select @@options -- same on both. quoted identifiers 'on' both servers

it comes down fact know 1 server treating escape character (chr(27)) differently other knot know why.

does have theory(or answer) why 2 similar servers treating escape characters differently?

the goal here getting prod server return values '[' , ']', setting system work legacy code take lot of additional time. have fix code 

sescapedstring:=stringreplace(sstringin,'[','[[]',[rfreplaceall]);

but faster option seem getting server read values same.

update: found root cause of difference , more mundane expected, turns out query running executed twice. second execution missing key piece on production server. issue resolved moving new line of code executed first rather last.

i first try find out if sql causes different behaviour when sent application: sending sql interactive sql client tool both servers.

to make sure manually tested sql same in application, try log or capture exact sql sent application text file , paste content sql client tool.

if server culprit, using sql different client tool should cause same difference 2 servers. if client tool shows same (correct) result on both servers, going on in delphi application.

p.s. upvoted, interesting phenomenon


Comments

Post a Comment

Popular posts from this blog

Linux vanilla kernel on QEMU and networking with eth0 -

i have downloaded , compiled vanilla linux kernel (3.7.1) used busybox ramdisk booted using qemu. qemu command line qemu-system-i386 -kernel bzimage -initrd ramdisk.img -append "root=/dev/ram rw console=ttys0 rdinit=/bin/ash" -nographic -net nic -net user everything goes well. however, can't use networking on vanilla kernel busybox. 'ifup eth0' tells me / # ifup eth0 ip: siocgifflags: no such device i googled internet can' clue... advice nice thank in advance. most there no driver (in example should e1000) loaded or device has name. in /sys/class/net/ should find listing of available net-devices. if there none (besides lo) driver not loaded. in qemu monitor type "info pci" , show pci-address of ethernet card. should this: ... bus 0, device 3, function 0: ethernet controller: pci device 8086:100e ... this device corresponds /sys/devices/pci0000:00/0000:00:03.0/. files "vendor" , "device" must c...
Read more

rdbms - what exactly the undo information lives in oracle? -

some docs says, there "undo tablespaces" implies should create tablespace undo imformation. some docs says, there "undo segment" implies undo information lives in normal tablespaces , use of it's segment. so, undo information lives , organized? earlier releases of oracle database used rollback segments store undo. oracle9i introduced automatic undo management, simplifies undo space management eliminating complexities associated rollback segment management. oracle recommends (oracle 9i , on words) use undo tablespace (automatic undo management) manage undo rather rollback segments. when creating undo tablespace, these automatically created: n undo segments (based on sessions parameter value) named _syssmun$ owned public (usable ops configuration) not manually manageable
Read more

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque...
Read more