Archives of the TeradataForum
Message Posted: Wed, 27 Feb 2008 @ 18:45:06 GMT
Try using the TYPE function which will tell you the data type of each column in each Select list. I'd also suggest that for testing you include a "GROUP BY 1,2,3" within each select so you only get one row back. Check that the DBMS isn't doing an implicit cast for you. I've recently sorted out something similar and found that a TIME(0) column was being cast to an INTEGER. That took me most of the day to sort out but once I used the TYPE function and realised the problem I got it fixed in about 20 minutes.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|