Updating POM and fixing unit test

[dmaap/datarouter.git] / datarouter-prov / src / test / resources / create.sql

diff --git a/datarouter-prov/src/test/resources/create.sql b/datarouter-prov/src/test/resources/create.sql
index 74b6324..06150ab 100755 (executable)
--- a/datarouter-prov/src/test/resources/create.sql
+++ b/datarouter-prov/src/test/resources/create.sql
@@ -194,12 +194,6 @@ VALUES (2,2);
 insert into LOG_RECORDS(RECORD_ID,TYPE,EVENT_TIME,PUBLISH_ID,FEEDID,REQURI,METHOD,CONTENT_TYPE,CONTENT_LENGTH,FEED_FILEID,REMOTE_ADDR,USER,STATUS,DELIVERY_SUBID,DELIVERY_FILEID,RESULT,ATTEMPTS,REASON,FILENAME)
 VALUES(1,'pub',2536159564422,'ID',1,'URL/file123','PUT','application/vnd.dmaap-dr.log-list; version=1.0',100,1,'172.0.0.8','user',204,1,1,204,0,'other','file123');
 
-CREATE ALIAS IF NOT EXISTS `SUBSTRING_INDEX` AS $$
-    String Function(String one, String two, String three){
-        return "url";
-    }
-$$;
-
 insert into NETWORK_ROUTES(FROMNODE, TONODE, VIANODE)
 VALUES (1, 3, 2);