1#### --source suite/funcs_1/datadict/datadict_bug_12777.inc
2#
3
4# columns in INFORMATION_SCHEMA with VARCHAR(4096) on Linux and Intel or AMD
5# processor are shown as VARCHAR(512) on Windows, VARCHAR(1023) on AIX and HPUX,
6# VARCHAR(1024) on Solaris10, ... see below and in bug #12777 for details.
7# So we need to replace the output for these systems. There may be other still
8# not tested / detected systems.
9#
10# Setting the variables used below has been moved to the beginning of the datadict
11# tests to "suite/funcs_1/datadict/datadict_load.inc".
12#
13# SELECT character_maximum_length INTO @CML
14#   FROM information_schema.columns
15#  WHERE table_schema = 'information_schema'
16#    AND table_name   = 'columns'
17#    AND column_name  = 'table_catalog';
18
19# this enables the --replace_result only if needed, using this we never replace
20# results on 'simple Linux' and so we will see any changes that might be
21# suppressed by the - only on some systems used - replacements.
22
23
24# Windows XP 32bit
25if ($bug_12777_0512)
26{
27   # switch next 2 lines on for debugging the correct detection of the operating systems
28   # let $message= value 512 detected - 1st replace statement activated!;
29   # --source include/show_msg.inc
30   #                nnnn       3*n
31   --replace_result 512 4096  1536 12288
32}
33
34# aix52, aix52-64bit, hp3750, hp3750-64bit, hpux11, hpux11-64bit,
35if ($bug_12777_1023)
36{
37   #                nnnn       3*n
38   --replace_result 1023 4096  3069 12288
39}
40
41# Solaris10, 32bit
42if ($bug_12777_1024)
43{
44   #                nnnn       3*n
45   --replace_result 1024 4096  3072 12288
46}
47
48# Linux Suse 9.3 32bit Intel/AMD
49if ($bug_12777_2048)
50{
51   #                nnnn       3*n
52   --replace_result 2048 4096  6144 12288
53}
54
55# build-5.0-standard
56if ($bug_12777_4095)
57{
58   #                nnnn       3*n
59   --replace_result 4095 4096  12285 12288
60}
61