|
|
Sponsor |
[jira] Assigned: (DERBY-12) Quoted table names mishandled in select list ex: msg#00567apache.db.derby.devel
[ http://issues.apache.org/jira/browse/DERBY-12?page=all ] Jack Klebanoff reassigned DERBY-12: ----------------------------------- Assign To: Jack Klebanoff > Quoted table names mishandled in select list expansion > ------------------------------------------------------ > > Key: DERBY-12 > URL: http://issues.apache.org/jira/browse/DERBY-12 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.0 > Reporter: Ramandeep Kaur > Assignee: Jack Klebanoff > Priority: Minor > > Opening this bug on behalf of Satheesh Bandaram. > ------------------------------------------------------ > Select list expansion is incorrect when there is a quoted table > name with an embedded period. Consider the following SQL: > create table "S1.T1" (id int not null primary key, d1 int); > create schema s1; > create table s1.t1 (id int not null primary key, d2 int); > select s1.t1.* from "S1.T1"; > select "S1.T1".* from s1.t1; > The select statements should both throw errors, because s1.t1 > and "S1.T1" are different tables. However Derby does not > throw an error. However, the following SQL does throw an error, > as it should. > select "S1.T1".id from s1.t1; > select s1.t1.id from "S1.T1" -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | [jira] Closed: (DERBY-161) DATE function as documented in the manuals does not support integer arguments. i.e. DATE(1232) does not work although the manual specifies that this format will return a date field that is "x" number of days since day 0., Satheesh Bandaram (JIRA) |
|---|---|
| Next by Date: | Re: [jira] Commented: (DERBY-214) Remove System.exit() calls from the DB2jServerImpl.java, Jeremy Boynes |
| Previous by Thread: | [jira] Closed: (DERBY-161) DATE function as documented in the manuals does not support integer arguments. i.e. DATE(1232) does not work although the manual specifies that this format will return a date field that is "x" number of days since day 0., Satheesh Bandaram (JIRA) |
| Next by Thread: | Re: [jira] Assigned: (DERBY-12) Quoted table names mishandled in select list expansion, Shreyas Kaushik |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home | sitemap
| advertise | OSDir is
an inevitable website.
|