26.03.2013 10:59, Alex Peshkoff wrote: > Dmitry, what do you think - will the users be happy to rewrite lots of > SQL operators to match this restriction?
World is cruel, you know. They did that in the past for ambiguity issues, bad grouping clauses etc, now they have to do one more exercise. It was not just a wild idea to please the SQL committee, this change also closes a big can of worms in the optimizer area. I cannot provide many examples at the moment but you might start looking at CORE-2812 and its links. Just for the record, I validated such queries in PGSQL, MSSQL and Oracle - and they work the way FB3 does now. Dmitry ------------------------------------------------------------------------------ Own the Future-Intel® Level Up Game Demo Contest 2013 Rise to greatness in Intel's independent game demo contest. Compete for recognition, cash, and the chance to get your game on Steam. $5K grand prize plus 10 genre and skill prizes. Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
