This is an automated email from the ASF dual-hosted git repository.
dimuthuupe pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/develop by this push:
new b8dd324 Fixing case sensitive issues in database initialization
script.
new a205f25 Merge pull request #216 from sairohithA007/develop
b8dd324 is described below
commit b8dd3247dc0e5c693bf3a07778719da1873dd837
Author: Sai Rohith Achanta <[email protected]>
AuthorDate: Fri Mar 15 12:18:20 2019 -0400
Fixing case sensitive issues in database initialization script.
---
.../src/main/resources/database_scripts/init/01-databases.sql | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git
a/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
b/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
index ffcf4d9..a02c8f6 100644
---
a/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
+++
b/modules/ide-integration/src/main/resources/database_scripts/init/01-databases.sql
@@ -3530,7 +3530,7 @@ USE `experiment_catalog`;
/*!50001 SET collation_connection = utf8mb4_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
-/*!50001 VIEW `experiment_summary` AS select `E`.`EXPERIMENT_ID` AS
`EXPERIMENT_ID`,`E`.`PROJECT_ID` AS `PROJECT_ID`,`E`.`GATEWAY_ID` AS
`GATEWAY_ID`,`E`.`USER_NAME` AS `USER_NAME`,`E`.`EXECUTION_ID` AS
`EXECUTION_ID`,`E`.`EXPERIMENT_NAME` AS `EXPERIMENT_NAME`,`E`.`CREATION_TIME`
AS `CREATION_TIME`,`E`.`DESCRIPTION` AS `DESCRIPTION`,`es`.`STATE` AS
`STATE`,`UD`.`RESOURCE_HOST_ID` AS
`RESOURCE_HOST_ID`,`es`.`TIME_OF_STATE_CHANGE` AS `TIME_OF_STATE_CHANGE` from
((`experiment` `E` left join [...]
+/*!50001 VIEW `experiment_summary` AS select `E`.`EXPERIMENT_ID` AS
`EXPERIMENT_ID`,`E`.`PROJECT_ID` AS `PROJECT_ID`,`E`.`GATEWAY_ID` AS
`GATEWAY_ID`,`E`.`USER_NAME` AS `USER_NAME`,`E`.`EXECUTION_ID` AS
`EXECUTION_ID`,`E`.`EXPERIMENT_NAME` AS `EXPERIMENT_NAME`,`E`.`CREATION_TIME`
AS `CREATION_TIME`,`E`.`DESCRIPTION` AS `DESCRIPTION`,`es`.`STATE` AS
`STATE`,`UD`.`RESOURCE_HOST_ID` AS
`RESOURCE_HOST_ID`,`es`.`TIME_OF_STATE_CHANGE` AS `TIME_OF_STATE_CHANGE` from
((`EXPERIMENT` `E` left join [...]
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
@@ -3548,7 +3548,7 @@ USE `experiment_catalog`;
/*!50001 SET collation_connection = utf8mb4_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
-/*!50001 VIEW `latest_experiment_status` AS select `ES1`.`EXPERIMENT_ID` AS
`EXPERIMENT_ID`,`ES1`.`STATE` AS `STATE`,`ES1`.`TIME_OF_STATE_CHANGE` AS
`TIME_OF_STATE_CHANGE` from (`experiment_status` `ES1` left join
`experiment_status` `ES2` on(((`ES1`.`EXPERIMENT_ID` = `ES2`.`EXPERIMENT_ID`)
and (`ES1`.`TIME_OF_STATE_CHANGE` < `ES2`.`TIME_OF_STATE_CHANGE`)))) where
isnull(`ES2`.`TIME_OF_STATE_CHANGE`) */;
+/*!50001 VIEW `latest_experiment_status` AS select `ES1`.`EXPERIMENT_ID` AS
`EXPERIMENT_ID`,`ES1`.`STATE` AS `STATE`,`ES1`.`TIME_OF_STATE_CHANGE` AS
`TIME_OF_STATE_CHANGE` from (`EXPERIMENT_STATUS` `ES1` left join
`EXPERIMENT_STATUS` `ES2` on(((`ES1`.`EXPERIMENT_ID` = `ES2`.`EXPERIMENT_ID`)
and (`ES1`.`TIME_OF_STATE_CHANGE` < `ES2`.`TIME_OF_STATE_CHANGE`)))) where
isnull(`ES2`.`TIME_OF_STATE_CHANGE`) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
