Hi, A public JIRA is raised in [1].
[1] https://wso2.org/jira/browse/REGISTRY-3610 Thanks. On Tue, May 10, 2016 at 12:11 PM, Janaka Ranabahu <jan...@wso2.com> wrote: > Hi Thushara > > On Tue, May 10, 2016 at 12:06 PM, Thushara Ranawaka <thusha...@wso2.com> > wrote: > >> Hi Thilini, >> >> AFAIU you workaround need to be updated with the current timestamp[1][2]. >> Setting default value to zero is not nice. You might have to figure out the >> correct syntax for other DB types and test against them. >> > What Thilini is pointing is an issue in the Registry database creation > script. Hence we will create a public JIRA and assign it to you guys. > Please fix them. > > We can not modify the Registry database creation script since API Manager > would not capture the complete scenarios of G-Reg. > > Thanks, > Janaka > > >> >> >> [1] - DEFAULT CURRENT_TIMESTAMP >> [2] - >> http://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column >> >> Thanks, >> Thushara. >> >> On Tue, May 10, 2016 at 11:52 AM, Thilini Cooray <thili...@wso2.com> >> wrote: >> >>> Hi GReg team, >>> >>> We encounter following issue [1] while testing API Manager with MySQL 5.7 >>> MySQL 5.7 has enabled NO_ZERO_IN_DATE, NO_ZERO_DATE policies by >>> default. Therefore it does not allow 0 as a valid default value for >>> date/time. >>> >>> As a workaround we can set MySQL server to accept 0 changing the default >>> server settings if the database owner agrees on it. >>> [2] contains the related table creation script. >>> >>> Appreciate your feedback on a fix for this. >>> >>> [1] https://wso2.org/jira/browse/APIMANAGER-4645 >>> >>> [2] CREATE TABLE IF NOT EXISTS REG_RESOURCE ( >>> REG_PATH_ID INTEGER NOT NULL, >>> REG_NAME VARCHAR(256), >>> REG_VERSION INTEGER NOT NULL AUTO_INCREMENT, >>> REG_MEDIA_TYPE VARCHAR(500), >>> REG_CREATOR VARCHAR(31) NOT NULL, >>> REG_CREATED_TIME TIMESTAMP NOT NULL *DEFAULT 0*, >>> REG_LAST_UPDATOR VARCHAR(31), >>> REG_LAST_UPDATED_TIME TIMESTAMP NOT NULL *DEFAULT 0*, >>> REG_DESCRIPTION VARCHAR(1000), >>> REG_CONTENT_ID INTEGER, >>> REG_TENANT_ID INTEGER DEFAULT 0, >>> REG_UUID VARCHAR(100) NOT NULL, >>> CONSTRAINT PK_REG_RESOURCE PRIMARY KEY(REG_VERSION, >>> REG_TENANT_ID) >>> )ENGINE INNODB; >>> >>> Thanks. >>> >>> -- >>> Best Regards, >>> >>> *Thilini Cooray* >>> Software Engineer >>> Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194> >>> E-mail : thili...@wso2.com >>> >>> WSO2 Inc. www.wso2.com >>> lean.enterprise.middleware >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Thanks, >> Thushara Kasun Ranawaka >> Software Engineer >> WSO2 Inc.; <http://www.wso2.com> >> lean.enterprise.middleware >> Mobile : *+94 (0) 773438949 <%2B94%20%280%29%20773438949>* >> *thusha...@wso2.com <thusha...@wso2.com>* >> > > > > -- > *Janaka Ranabahu* > Associate Technical Lead, WSO2 Inc. > http://wso2.com > > > *E-mail: jan...@wso2.com <http://wso2.com>**M: **+94 718370861 > <%2B94%20718370861>* > > Lean . Enterprise . Middleware > -- Best Regards, *Thilini Cooray* Software Engineer Mobile : +94 (0) 774 570 112 <%2B94%20%280%29%20773%20451194> E-mail : thili...@wso2.com WSO2 Inc. www.wso2.com lean.enterprise.middleware
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev