Re: Abbreviated keys for Numeric

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
>> For those following along at home, the failures are on these queries:
>> SELECT 1.1 AS two UNION SELECT 2.2;>> SELECT 1.1 AS two UNION SELECT 2;>> SELECT 1 AS two UNION SELECT 2.2;>> SELECT
1.1AS three UNION SELECT 2 UNION ALL SELECT 2;
 
>> In each case, the expected result is with the values in ascending>> numerical order.  In each case, the 1 or 1.1
valuewhich ought to>> appear before 2 or 2.2 instead appears after it.  Strictly speaking,>> this is not the wrong
answerto the query, and could be perhaps>> explained by the planner choosing a hash aggregate rather than a sort>> +
uniqueplan.  But this patch doesn't change the planner at all, so>> the plan should be the same as it has always been.
 
Tom> Yeah.  We could add an EXPLAIN to make certain, perhaps, but sinceTom> none of the other critters are failing I
doubtthis explanation.
 

This failure in the union.sql test is exactly the one that happens if
you build with --disable-float8-byval, for what that's worth.

Does the windows build perhaps not define USE_FLOAT8_BYVAL? that would
explain the breakage.

-- 
Andrew (irc:RhodiumToad)