If he simple function call is giving you a more lazy evaluation evaluation, that might explain what's occurring.
It may be that the database engine requires the subquery to break the possibility of a cycle in the code, and sequence the computation.
But you see you are in the Windows CE embedded niche. Your vision is clouded.
I'm not in a "windows CE embedded" niche and the grandparent poster is right.
It's not an issue with the target. It's an issue with the platform(s) supported by the development tool vendors and the chip manufacturers.
For instance: With Bluetooth 4.0 / Bluetooth Low Energy (BLE), two of the premier system-on-a-chip product families are from Texas Instruments and Nordic Semiconductors.
TI developed their software in IAR's proprietary development environment and only supports that. Their bluetooth stack is only distributed in object form - for IAR's tools - with a "no reverse engineering" and "no linking to open source (which might force disclosure)". IAR, in turn, doesn't support anything but Windows. (You can't even use Wine: The IAR license manager needs real Windows to install, and the CC Debugger dongle, for burning the chip and necessary for hooking the debugger to the hardware debugging module, keeps important parts of its functionality in a closed-source windows driver.) IAR is about $3,000/seat after the one-month free evaluation (though they also allow a perpetual evaluation that is size-crippled, and too small to run the stack.)
The TI system-on-a-chip comes with some very good and very cheap hardware development platforms. (The CC Debugger dongle, the USB/BLE-radio stick, and the Sensor Tag (a battery-powered BLE device with buttons, magnetometer, gyro, barometer, humidity sensor, ambient temp sensor, and IR remote temp sensor), go for $49 for each of the three kits.) Their source code is free-as-in-beer, even when built into a commercial product, and gives you the whole infrastructure on which to build your app. But if you want to program these chips you either do it on Windows with the pricey IAR tools or build your own toolset and program the "bare metal", discarding ALL TI's code and writing a radio stack and OS from scratch.
Nordic is similar: Their license lets you reverse-engineer and modify their code (at your own risk). But their development platforms are built by Segger and the Windows-only development kit comes with TWO licenses. The Segger license (under German law), for the burner dongle and other debug infrastruture, not only has a no-reverse-engineering clause but also an anti-compete: Use their tools (even for comparison while developing your own) and you've signed away your right to EVER develop either anything similar or any product that competes with any of theirs.
So until the chip makers wise up (or are out-competed by ones who have), or some open-source people build something from scratch, with no help from them, to support their products, you're either stuck on Windows or stuck violating contracts and coming afoul of the law.
It took a millennium and a half for the reformation to try to straighten out Scripture.
The point I made was that Luther incorrectly removed this.
So which would you use to inform your life and society? If you said, "The Bible", then even God thinks you're a moron. Because, way before there was scripture, there was man's ability to reason.
Read the Gospel; specifically read how Jesus reacted to Thomas' skepticism, and his message about those who haven't seen and still believe.
Man's ability to reason is deeply flawed. Man's "reason" once told the Egyptians it was OK to use the Hebrews as slaves. Man's "reason" today says it's OK for women to butcher their children in the womb.
That is not true. If my job is important and my systems are important, i'm on site to make sure that change is successful.
When I was with IBM, our policy was to open up a conference call and have all the requisite support staff on the call until the change window closed. You paid through the nose for that kind of support, but our downtime was minimal and some customers needed that.
When I am working in theater on critical systems in wartime, I don't sit in my fucking hooch and use automated tools. My ass is in front of the boxes in question to respond instantly. The alternative is broken tactical systems meaning bad information being used to make decisions meaning dead people.
Your slack attitude doesn't cut it in the places I work.
To this day, males 18+ must register. Those who do not cannot receive Federal financial aid, nor work as a GS or contract employee for the Fed.
Did it do a 4G inverted dive?
google broke into internet search with the page rank algorithm whose essential purpose is to combat "search engine optimization."
Yeah. They destroy legitimate businesses with their wonderful algorithms...
SEO isn't a legitimate business. If your website is getting pushed into the search-result basement, odds are you're doing it wrong.
How about looking up "pedantry".