On 05/08/2013 05:17, Dmitry Yemanov wrote: > 04.08.2013 16:47, Simonov Denis wrote: >> select 1 >> from rdb$database >> where true is true >> >> >> Work is correct >> >> select 1 >> from rdb$database >> where (1=1) and true >> >> >> Work is correct >> >> select 1 >> from rdb$database >> where (1=1) is true >> >> >> Invalid token. >> Dynamic SQL Error. >> SQL error code = -104. >> Token unknown - line 3, column 13. >> is. > Accordingly to the SQL specification, it should work. Adriano, is it > prohibited intentionally? > > We use some special rule combination which didn't added a lot of conflicts, but broke this case.
I'm not saying the standard has conflicts, but we certain have (say INSERTING and friends). The standard uses rules somewhat different than us, so it's not simple to test. I'm trying with it. Adriano ------------------------------------------------------------------------------ Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
