"Inappropriate self-reference of column" when using "with check option" with
extract(...)
-----------------------------------------------------------------------------------------
Key: CORE-4299
URL: http://tracker.firebirdsql.org/browse/CORE-4299
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.2 Update 1
Environment: Windows 8.1
Reporter: Peter Peter
Priority: Minor
Hey, I was told on Stackoverflow that this might be a bug, some I'm submitting
it here.
I tried to following SQL statement:
create view FOO as
select * from BAR
where extract(year from BAR.SOME_DATE) = '2011' with check option;
But I receive an error massage, saying, "SQL error code = -203. Inappropriate
self-reference of column."
However, the following statement will work properly:
create view FOO as
select * from BAR
where BAR.SOME_DATE between '2011-01-01' and '2011-12-31' with check option;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
