Comment 5 for bug 583590

Revision history for this message
Monty Taylor (mordred) wrote : Re: [Bug 583590] Re: opensolaris-64-test-only has failing tests due to show tables ordering difference

On 5/20/2010 7:33 PM, Stewart Smith wrote:
> On Thu, 20 May 2010 23:06:56 -0000, Patrick Crews<email address hidden> wrote:
>> http://hudson.drizzle.org/job/drizzle-build-opensolaris-64-test-
>> only/lastBuild/console
>>
>> and grep for the tests above.
>
> Is that machine running UFS? Does the test create the tables in the
> order printed out?
>
> There is no really sane reason to order the SHOW TABLES output (and good
> reasons against it, materialising everything and sorting it sucks).
>
> However... we should do it in test results to compare things properly.
>

I believe these values are spending some time in an unordered_map. On
Solaris, we're using boost::unordered_map, whereas on not-solaris we're
using gcc's builtin std::unordered_map.

For sanity in the testing system, I think show tables pretty much has to
be sorted. Last I spoke to Brian, he said that show tables was being
re-written into a data_dictionary query that did include an order by ...
but I didn't look in to it far enough to verify.

If someone could find where the data_dictionary query is made...

Monty