Changeset 23968

Timestamp:

Apr 24, 2009, 2:22:08 PM (17 years ago)

Author:

bills

Message:

minor change

File:

• trunk/ippTools/share/disttool_definebyquery_stack.sql (modified) (1 diff)

trunk/ippTools/share/disttool_definebyquery_stack.sql

@@ -3 +3 @@
     stackRun.stack_id AS stage_id,
     -- run tag in the form 'stack.$skycell_id.$stack_id'
-    CONCAT('stack.', stackRun.skycell_id, '.', convert(stackRun.stack_id, CHAR)) as run_tag,
+    CONCAT_WS('.', 'stack', stackRun.skycell_id, convert(stackRun.stack_id, CHAR)) as run_tag,
     rawExp.obs_mode,
     distTarget.target_id,