Subject: [jira] Commented: (DERBY-4399) Syntax description for TableViewOrFunctionExpression lack subquery option - msg#00439

Previous Message by Date: click to view message preview

[jira] Commented: (DERBY-4399) Syntax description for TableViewOrFunctionExpression lack subquery option

[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780686#action_12780686 ] Kim Haase commented on DERBY-4399: ---------------------------------- The new patch is DERBY-4399-2.diff. To avoid confusion, I removed the correlation-name topic that was modified for the first patch. > Syntax description for TableViewOrFunctionExpression lack subquery option > ------------------------------------------------------------------------- > > Key: DERBY-4399 > URL: https://issues.apache.org/jira/browse/DERBY-4399 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.5.3.0 > Reporter: Dag H. Wanvik > Assignee: Kim Haase > Attachments: DERBY-4399-2.diff, DERBY-4399.diff, rrefsqlj33215.html, > rrefsqlj33215.html, rreftableexpression.html, rreftableexpression.html > > > In the reference manual, we find these syntax descriptions (start with > http://db.apache.org/derby/docs/dev/ref/rrefsqlj21583.html): > TableExpression: > { > TableViewOrFunctionExpression | JOIN operation > } > TableViewOrFunctionExpression: > { table-Name | view-Name | TableFunctionInvocation} > [ [ AS ] correlation-Name > [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ] > I cannot find a way from the "FROM clause" to the TableSubquery production, > so I think the latter should read: > { table-Name | TableSubquery | view-Name | TableFunctionInvocation } > [ [ AS ] correlation-Name > [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ] > Also, the "JOIN operation" is not clickable. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.

Next Message by Date: click to view message preview

[jira] Resolved: (DERBY-4399) Syntax description for TableViewOrFunctionExpression lack subquery option

[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase resolved DERBY-4399. ------------------------------ Resolution: Fixed Fix Version/s: 10.6.0.0 Issue & fix info: (was: [Patch Available]) Thanks very much, Dag. Committed patch DERBY-4399-2.diff to documentation trunk at revision 882686. > Syntax description for TableViewOrFunctionExpression lack subquery option > ------------------------------------------------------------------------- > > Key: DERBY-4399 > URL: https://issues.apache.org/jira/browse/DERBY-4399 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.5.3.0 > Reporter: Dag H. Wanvik > Assignee: Kim Haase > Fix For: 10.6.0.0 > > Attachments: DERBY-4399-2.diff, DERBY-4399.diff, rrefsqlj33215.html, > rrefsqlj33215.html, rreftableexpression.html, rreftableexpression.html > > > In the reference manual, we find these syntax descriptions (start with > http://db.apache.org/derby/docs/dev/ref/rrefsqlj21583.html): > TableExpression: > { > TableViewOrFunctionExpression | JOIN operation > } > TableViewOrFunctionExpression: > { table-Name | view-Name | TableFunctionInvocation} > [ [ AS ] correlation-Name > [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ] > I cannot find a way from the "FROM clause" to the TableSubquery production, > so I think the latter should read: > { table-Name | TableSubquery | view-Name | TableFunctionInvocation } > [ [ AS ] correlation-Name > [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ] > Also, the "JOIN operation" is not clickable. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.

Previous Message by Thread: click to view message preview

[jira] Commented: (DERBY-4399) Syntax description for TableViewOrFunctionExpression lack subquery option

[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780686#action_12780686 ] Kim Haase commented on DERBY-4399: ---------------------------------- The new patch is DERBY-4399-2.diff. To avoid confusion, I removed the correlation-name topic that was modified for the first patch. > Syntax description for TableViewOrFunctionExpression lack subquery option > ------------------------------------------------------------------------- > > Key: DERBY-4399 > URL: https://issues.apache.org/jira/browse/DERBY-4399 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.5.3.0 > Reporter: Dag H. Wanvik > Assignee: Kim Haase > Attachments: DERBY-4399-2.diff, DERBY-4399.diff, rrefsqlj33215.html, > rrefsqlj33215.html, rreftableexpression.html, rreftableexpression.html > > > In the reference manual, we find these syntax descriptions (start with > http://db.apache.org/derby/docs/dev/ref/rrefsqlj21583.html): > TableExpression: > { > TableViewOrFunctionExpression | JOIN operation > } > TableViewOrFunctionExpression: > { table-Name | view-Name | TableFunctionInvocation} > [ [ AS ] correlation-Name > [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ] > I cannot find a way from the "FROM clause" to the TableSubquery production, > so I think the latter should read: > { table-Name | TableSubquery | view-Name | TableFunctionInvocation } > [ [ AS ] correlation-Name > [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ] > Also, the "JOIN operation" is not clickable. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.

Next Message by Thread: click to view message preview

Regression Test Report - Daily 881834 - Sun DBTG

[Auto-generated mail] *Daily* 881834/2009-11-18 18:02:02 MET Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.6* lin 0 11705 11705 0 1038.47% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 56.85% derbyall 0 2 2 0 563.99% compatibility 0 2 2 0 .% demoSuite sles 0 11705 11705 0 670.52% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 47.15% derbyall 0 2 2 0 283.36% compatibility 0 2 2 0 .% demoSuite sol 0 11705 11705 0 818.42% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 43.69% derbyall 0 2 2 0 310.35% compatibility 0 2 2 0 .% demoSuite solN+1 0 11705 11705 0 141.20% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 65.98% derbyall 0 2 2 0 296.41% compatibility 0 2 2 0 .% demoSuite sparc 0 11705 11705 0 531.63% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 47.45% derbyall 0 2 2 0 279.22% compatibility 0 2 2 0 .% demoSuite vista F:0,E:1 11699 11698 0 129.27% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 58.36% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite vista-64 0 11699 11699 0 187.50% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 57.01% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite w2003 0 11699 11699 0 229.12% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 69.35% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite Details in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.6/testing/Limited/testSummary-881834.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.6/FailReports/881834_bySig.html *Jvm: 1.5* lin 0 222 222 0 53.21% derbyall 0 9915 9915 0 1729.08% suitesAll sles 0 222 222 0 48.23% derbyall 0 9915 9915 0 1085.80% suitesAll sol 0 222 222 0 45.86% derbyall 0 9915 9915 0 1522.28% suitesAll solN+1 0 222 222 0 60.54% derbyall 0 9915 9915 0 1419.52% suitesAll sparc 0 222 222 0 47.66% derbyall 0 9915 9915 0 1224.78% suitesAll vista 0 222 222 0 44.65% derbyall 0 9909 9909 0 913.08% suitesAll vista-64 0 222 222 0 57.93% derbyall 0 9909 9909 0 210.54% suitesAll w2003 0 222 222 0 54.79% derbyall 0 9909 9909 0 569.03% suitesAll Details in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/testing/Limited/testSummary-881834.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/FailReports/881834_bySig.html *Jvm: 1.4* lin 0 219 219 2 51.34% derbyall 0 9762 9762 0 1537.86% suitesAll sles 0 219 219 2 43.15% derbyall 0 9762 9762 0 912.31% suitesAll sol 0 219 219 2 42.31% derbyall 0 9762 9762 0 1227.39% suitesAll solN+1 0 219 219 2 58.41% derbyall 0 9762 9762 0 1319.34% suitesAll sparc 0 219 219 2 46.96% derbyall 0 9762 9762 0 1223.67% suitesAll vista 0 219 219 2 44.39% derbyall 0 9756 9756 0 894.48% suitesAll vista-64 0 219 219 2 56.95% derbyall 0 9756 9756 0 215.39% suitesAll w2003 0 219 219 2 56.75% derbyall 0 9762 9762 0 566.32% suitesAll Details in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.4/testing/Limited/testSummary-881834.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.4/FailReports/881834_bySig.html ....................................................... *Jvm: 1.7* lin 0 11705 11705 0 .% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 .% derbyall 0 2 2 0 .% compatibility 0 2 2 0 .% demoSuite sol 0 11705 11705 0 .% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 .% derbyall 0 2 2 0 .% compatibility 0 2 2 0 .% demoSuite vista-64 0 11699 11699 0 .% suitesAll 0 13 13 0 .% jdbcapiAutoLoad 0 12 12 0 .% JDBCDriversAll 0 13 13 0 .% JDBCDriversClient 0 12 12 0 .% JDBCDriversEmbedded 0 221 221 0 .% derbyall NA NA NA NA compatibility 0 2 2 0 .% demoSuite Details in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/Limited/testSummary-881834.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/FailReports/881834_bySig.html *Jvm: phoneME* ubuntu 0 4412 4412 0 .% suitesAll Details in http://dbtg.foundry.sun.com/derby/test/Daily/javaME/testing/Limited/testSummary-881834.html Attempted failure analysis in http://dbtg.foundry.sun.com/derby/test/Daily/javaME/FailReports/881834_bySig.html ------------------------------------------------------- Changes in http://dbtg.foundry.sun.com/derby/test/Daily/UpdateInfo/881834.txt ( All results in http://dbtg.foundry.sun.com/derby/test/ )