diff options
| author | jakefeasel <jfeasel@gmail.com> | 2015-05-04 16:12:45 -0700 |
|---|---|---|
| committer | jakefeasel <jfeasel@gmail.com> | 2015-05-04 16:12:45 -0700 |
| commit | f0729a9aa42299356a95cda61fae2bb8bad5e22c (patch) | |
| tree | 187c261ba3fffbf74a90d02191da452a91ef917c | |
| parent | 29ed259421f7f4d427d0526eb7c04417bf058ccf (diff) | |
| download | sqlfiddle2-f0729a9aa42299356a95cda61fae2bb8bad5e22c.zip sqlfiddle2-f0729a9aa42299356a95cda61fae2bb8bad5e22c.tar.gz sqlfiddle2-f0729a9aa42299356a95cda61fae2bb8bad5e22c.tar.bz2 | |
Null values in DDL were causing problems; coalesce to empty string to work-around it
| -rw-r--r-- | src/main/resources/tools/fiddles/SearchScript.groovy | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/resources/tools/fiddles/SearchScript.groovy b/src/main/resources/tools/fiddles/SearchScript.groovy index 0837350..53427ea 100644 --- a/src/main/resources/tools/fiddles/SearchScript.groovy +++ b/src/main/resources/tools/fiddles/SearchScript.groovy @@ -358,7 +358,7 @@ switch ( objectClass.objectClassValue ) { s.short_code, to_char(s.last_used, 'YYYY-MM-DD HH24:MI:SS.MS') as last_used, floor(EXTRACT(EPOCH FROM age(current_timestamp, last_used))/60) as minutes_since_last_used, - s.ddl, + coalesce(s.ddl, '') as ddl, s.statement_separator, s.structure_json, s.deprovision, |