[jira] [Updated] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

2017-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6905: --- Attachment: dblook_tests.diff I agree with Rick's assessment that these tests are failing due

[jira] [Commented] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

2017-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053316#comment-16053316 ] Bryan Pendleton commented on DERBY-6905: The 'derbytools' suite only runs dblook_test and

Re: next derby release

2017-06-18 Thread Bryan Pendleton
I, too, would like to see a Derby release prior to summer 2018. I am comfortable with either proposal. Thanks for volunteering to make this happen! I'll chip in as much as I can. bryan

Re: broken tests on trunk

2017-06-18 Thread Bryan Pendleton
I reproduced (I think) the failures by doing the following: 1) building jars (ant buildJars) 2) creating a new empty directory and cd'ing there 3) export CLASSPATH=/path/to/derbyrun.jar:/path/to/derbyTesting.jar:/path/to/junit.jar 4) java org.apache.derbyTesting.functionTests.harness.RunSuite

[jira] [Commented] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

2017-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053305#comment-16053305 ] Bryan Pendleton commented on DERBY-6905: I reproduced (I think) the failures by doing the

[jira] [Reopened] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

2017-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton reopened DERBY-6905: Reopening because there appear to be some regression tests failing after this change. See the

Re: broken tests on trunk

2017-06-18 Thread Bryan Pendleton
Hi Rick, I'm sorry for the stupid question, but: can you remind me how to run these tests? Are they run by 'ant junit-all' or by running 'ant -Dderby.junit.testclass=org.apache.derbyTesting.functionTests.tests.tools._Suite junit-single'? Or do I have to run them some other way? FWIW, running the

[jira] [Comment Edited] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053198#comment-16053198 ] Harshvardhan Gupta edited comment on DERBY-6940 at 6/18/17 1:56 PM:

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053201#comment-16053201 ] Harshvardhan Gupta commented on DERBY-6940: --- Additionally we need to work on upgrade procedures,

[jira] [Updated] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6940: -- Description: Derby should collect extra statistics during index build time, statistics

[jira] [Updated] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6940: -- Attachment: derby-6940.diff Attaching an initial patch which add the following

[jira] [Assigned] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6940: - Assignee: Harshvardhan Gupta > Enhance derby statistics for more accurate

[jira] [Created] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
Harshvardhan Gupta created DERBY-6940: - Summary: Enhance derby statistics for more accurate selectivity estimates. Key: DERBY-6940 URL: https://issues.apache.org/jira/browse/DERBY-6940 Project:

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053197#comment-16053197 ] Harshvardhan Gupta commented on DERBY-6938: --- Tracking work on statistics enhancement at

[jira] [Comment Edited] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

2017-06-18 Thread Harshvardhan Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053201#comment-16053201 ] Harshvardhan Gupta edited comment on DERBY-6940 at 6/18/17 1:53 PM: