An error occurred fetching the project authors.
  1. 31 Mar, 2008 1 commit
    • unknown's avatar
      Fix for · 00412389
      unknown authored
         Bug#35335 funcs_1: Some tests fail within load_file during
                            pushbuild runs
         Solution: 1. Move files with input data used in load_file, 
                      load data etc. 
                      from suite/funcs_1/<whatever>
                      to std_data
                   2. Use for testsuite funcs_1 the server option
                      --secure-file-priv=<MYSQLTEST_VARDIR>
                   3. Outfiles have to be stored under MYSQLTEST_VARDIR 
      + changes according to WL#4304 Cleanup in funcs_1 tests
        - backport of fixes/improvements made in 5.1 to 5.0
          The differences between scripts in 5.0 and 5.1 cause
          much additional and annoying work during any upmerge.
        - replace error numbers with names
        - improved comments
        - improved formatting
        - Unify storage engine names so that result files for
          storage engine variants do not differ (some tests)
        - remove a script no more used (tests are done in other scripts)
      
      
      BitKeeper/deleted/.del-triggers_master.test:
        Delete: mysql-test/suite/funcs_1/triggers/triggers_master.test
      mysql-test/std_data/funcs_1/innodb_tb1.txt:
        Rename: mysql-test/suite/funcs_1/data/innodb_tb1.txt -> mysql-test/std_data/funcs_1/innodb_tb1.txt
      mysql-test/std_data/funcs_1/innodb_tb2.txt:
        Rename: mysql-test/suite/funcs_1/data/innodb_tb2.txt -> mysql-test/std_data/funcs_1/innodb_tb2.txt
      mysql-test/std_data/funcs_1/innodb_tb3.txt:
        Rename: mysql-test/suite/funcs_1/data/innodb_tb3.txt -> mysql-test/std_data/funcs_1/innodb_tb3.txt
      mysql-test/std_data/funcs_1/innodb_tb4.txt:
        Rename: mysql-test/suite/funcs_1/data/innodb_tb4.txt -> mysql-test/std_data/funcs_1/innodb_tb4.txt
      mysql-test/std_data/funcs_1/memory_tb1.txt:
        Rename: mysql-test/suite/funcs_1/data/memory_tb1.txt -> mysql-test/std_data/funcs_1/memory_tb1.txt
      mysql-test/std_data/funcs_1/memory_tb2.txt:
        Rename: mysql-test/suite/funcs_1/data/memory_tb2.txt -> mysql-test/std_data/funcs_1/memory_tb2.txt
      mysql-test/std_data/funcs_1/memory_tb3.txt:
        Rename: mysql-test/suite/funcs_1/data/memory_tb3.txt -> mysql-test/std_data/funcs_1/memory_tb3.txt
      mysql-test/std_data/funcs_1/memory_tb4.txt:
        Rename: mysql-test/suite/funcs_1/data/memory_tb4.txt -> mysql-test/std_data/funcs_1/memory_tb4.txt
      mysql-test/std_data/funcs_1/myisam_tb1.txt:
        Rename: mysql-test/suite/funcs_1/data/myisam_tb1.txt -> mysql-test/std_data/funcs_1/myisam_tb1.txt
      mysql-test/std_data/funcs_1/myisam_tb2.txt:
        Rename: mysql-test/suite/funcs_1/data/myisam_tb2.txt -> mysql-test/std_data/funcs_1/myisam_tb2.txt
      mysql-test/std_data/funcs_1/myisam_tb3.txt:
        Rename: mysql-test/suite/funcs_1/data/myisam_tb3.txt -> mysql-test/std_data/funcs_1/myisam_tb3.txt
      mysql-test/std_data/funcs_1/myisam_tb4.txt:
        Rename: mysql-test/suite/funcs_1/data/myisam_tb4.txt -> mysql-test/std_data/funcs_1/myisam_tb4.txt
      mysql-test/std_data/funcs_1/t3.txt:
        Rename: mysql-test/suite/funcs_1/data/t3.txt -> mysql-test/std_data/funcs_1/t3.txt
      mysql-test/std_data/funcs_1/t4.txt:
        Rename: mysql-test/suite/funcs_1/data/t4.txt -> mysql-test/std_data/funcs_1/t4.txt
      mysql-test/std_data/funcs_1/t7.txt:
        Rename: mysql-test/suite/funcs_1/data/t7.txt -> mysql-test/std_data/funcs_1/t7.txt
      mysql-test/std_data/funcs_1/t9.txt:
        Rename: mysql-test/suite/funcs_1/data/t9.txt -> mysql-test/std_data/funcs_1/t9.txt
      mysql-test/Makefile.am:
        Introduce installation of funcs_1 files in std_data.
      mysql-test/mysql-test-run.pl:
        The tests within funcs_1 need a server started with
            --secure-file-priv=<MYSQLTEST_VARDIR>
        like the main regression tests.
      mysql-test/suite/funcs_1/README.txt:
        Extended description
      mysql-test/suite/funcs_1/datadict/datadict_bug_12777.inc:
        Cleanup
      mysql-test/suite/funcs_1/datadict/datadict_load.inc:
        Cleanup
      mysql-test/suite/funcs_1/include/innodb_tb1.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/innodb_tb2.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/innodb_tb3.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/innodb_tb4.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/memory_tb1.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/memory_tb2.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/memory_tb3.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/memory_tb4.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/myisam_tb1.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/myisam_tb2.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/myisam_tb3.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/myisam_tb4.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/include/sp_tb.inc:
        Adjustment to new storage place of infile.
      mysql-test/suite/funcs_1/r/innodb_func_view.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_02.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_06.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_07.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_10.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_0102.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_0407.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_09.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_1011ext.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_frkey.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_views.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_columns_innodb.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_columns_memory.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_columns_myisam.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_columns_ndb.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_tables_innodb.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_tables_memory.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_tables_myisam.result:
        Updated results
      mysql-test/suite/funcs_1/r/is_tables_ndb.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_func_view.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_02.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_06.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_07.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_10.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_0102.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_0407.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_09.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_1011ext.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_views.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_func_view.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_02.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_06.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_07.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_10.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_0102.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_0407.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_09.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_1011ext.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_views.result:
        Updated results
      mysql-test/suite/funcs_1/storedproc/cleanup_sp_tb.inc:
        "--echo" instead of SQL command.
      mysql-test/suite/funcs_1/storedproc/load_sp_tb.inc:
        Adjustment to new storage place of infile
        + correct formatting.
      mysql-test/suite/funcs_1/storedproc/storedproc_02.inc:
        Backport from 5.1 + correct formatting.
      mysql-test/suite/funcs_1/storedproc/storedproc_03.inc:
        Minor improvements + correct formatting.
      mysql-test/suite/funcs_1/storedproc/storedproc_06.inc:
        Backport from 5.1 + correct formatting
      mysql-test/suite/funcs_1/storedproc/storedproc_10.inc:
        Backport from 5.1. + correct formatting
      mysql-test/suite/funcs_1/t/innodb_trig_0407.test:
        Cleanup
      mysql-test/suite/funcs_1/t/is_basics_mixed.test:
        Adjustment to new storage place of outfile.
      mysql-test/suite/funcs_1/t/memory_storedproc_02.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_storedproc_03.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_storedproc_06.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_storedproc_07.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_storedproc_08.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_storedproc_10.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_storedproc_02.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_storedproc_03.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_storedproc_06.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_storedproc_07.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_storedproc_08.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_storedproc_10.test:
        Cleanup
      mysql-test/suite/funcs_1/triggers/trig_frkey2.inc:
        Cleanup
      mysql-test/suite/funcs_1/triggers/triggers_0102.inc:
        Cleanup
      mysql-test/suite/funcs_1/triggers/triggers_03.inc:
        Backport from 5.1
      mysql-test/suite/funcs_1/triggers/triggers_0407.inc:
        Backport from 5.1
      mysql-test/suite/funcs_1/triggers/triggers_08.inc:
        Backport from 5.1
      mysql-test/suite/funcs_1/triggers/triggers_09.inc:
        Backport from 5.1
      mysql-test/suite/funcs_1/triggers/triggers_1011ext.inc:
        Backport from 5.1
      mysql-test/suite/funcs_1/views/func_view.inc:
        Backport from 5.1
      mysql-test/suite/funcs_1/views/views_master.inc:
        Cleanup
      mysql-test/std_data/funcs_1/load_file.txt:
        New BitKeeper file ``mysql-test/std_data/funcs_1/load_file.txt''
      00412389
  2. 07 Mar, 2008 1 commit
    • unknown's avatar
      WL#4203 Reorganize and fix the data dictionary tests of · d6e42aac
      unknown authored
              testsuite funcs_1
      1. Fix the following bugs
         Bug#30440 "datadict" tests (all engines) fail: Character sets depend on configuration
            Solution: Test variants charset_collation_* adjusted to different builds
         Bug#32603 "datadict" tests (all engines) fail in "community" tree: "PROFILING" table
            Solution: Excluding "PROFILING" table from queries
         Bug#33654 "slow log" is missing a line
            Solution: Unify the content of the fields TABLES.TABLE_ROWS and
                      STATISTICS.CARDINALITY within result sets
         Bug#34532 Some funcs_1 tests do not clean up at end of testing
            Solution: DROP objects/reset global server variables modified during testing
                      + let tests missing implementation end before loading of tables
         Bug#31421 funcs_1: ndb__datadict fails, discrepancy between scripts and expected results
            Solution: Cut <engine>__datadict tests into smaller tests + generate new results.
         Bug#33599 INFORMATION_SCHEMA.STATISTICS got a new column INDEX_COMMENT: tests fail (2)
            Generation of new results during post merge fix
         Bug#33600 CHARACTER_OCTET_LENGTH is now CHARACTER_MAXIMUM_LENGTH * 4
            Generation of new results during post merge fix
         Bug#33631 Platform-specific replace of CHARACTER_MAXIMUM_LENGTH broken by 4-byte encoding
            Generation of new results during post merge fix
            + removal of platform-specific replace routine (no more needed)
      2. Restructure the tests
         - Test not more than one INFORMATION_SCHEMA view per testscript
         - Separate tests of I_S view layout+functionality from content related to the
           all time existing databases "information_schema", "mysql" and "test"
         - Avoid storage engine related variants of tests which are not sensible to
           storage engines at all.
      3. Reimplement or add some subtests + cleanup
         There is a some probability that even the reviewed changeset
         - does not fix all bugs from above   or
         - contains new bugs which show up on some platforms <> Linux or on one of
           the various build types
      4. The changeset contains fixes according to
         - one code review
         - minor bugs within testing code found after code review (accepted by reviewer)
         - problems found during tests with 5.0.56 in build environment
      
      
      mysql-test/suite/funcs_1/t/innodb_storedproc_02.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/innodb_storedproc_03.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/innodb_storedproc_06.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/innodb_storedproc_07.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/innodb_storedproc_08.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/innodb_storedproc_10.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/memory_storedproc_02.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/memory_storedproc_03.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/memory_storedproc_06.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/memory_storedproc_07.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/memory_storedproc_08.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/memory_storedproc_10.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/myisam_storedproc_02.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/myisam_storedproc_03.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/myisam_storedproc_06.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/myisam_storedproc_07.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/myisam_storedproc_08.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/t/myisam_storedproc_10.test:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/storedproc/storedproc_02.inc:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/storedproc/storedproc_03.inc:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/storedproc/storedproc_06.inc:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/storedproc/storedproc_07.inc:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/storedproc/storedproc_08.inc:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc:
        Change mode to -rw-rw-r--
      mysql-test/suite/funcs_1/storedproc/storedproc_10.inc:
        Change mode to -rw-rw-r--
      BitKeeper/deleted/.del-innodb__load.test:
        Delete: mysql-test/suite/funcs_1/t/innodb__load.test
      BitKeeper/deleted/.del-innodb__load.result:
        Delete: mysql-test/suite/funcs_1/r/innodb__load.result
      BitKeeper/deleted/.del-myisam__load.test:
        Delete: mysql-test/suite/funcs_1/t/myisam__load.test
      BitKeeper/deleted/.del-memory__load.test:
        Delete: mysql-test/suite/funcs_1/t/memory__load.test
      BitKeeper/deleted/.del-memory__load.result:
        Delete: mysql-test/suite/funcs_1/r/memory__load.result
      BitKeeper/deleted/.del-myisam__load.result:
        Delete: mysql-test/suite/funcs_1/r/myisam__load.result
      BitKeeper/deleted/.del-create_database.inc:
        Delete: mysql-test/suite/funcs_1/include/create_database.inc
      BitKeeper/deleted/.del-create_user_lowest_priv.inc:
        Delete: mysql-test/suite/funcs_1/include/create_user_lowest_priv.inc
      BitKeeper/deleted/.del-create_user_no_super.inc:
        Delete: mysql-test/suite/funcs_1/include/create_user_no_super.inc
      BitKeeper/deleted/.del-datadict_help_tables_build.result:
        Delete: mysql-test/suite/funcs_1/r/datadict_help_tables_build.result
      BitKeeper/deleted/.del-datadict_help_tables_build.test:
        Delete: mysql-test/suite/funcs_1/t/datadict_help_tables_build.test
      BitKeeper/deleted/.del-datadict_help_tables_dev.result:
        Delete: mysql-test/suite/funcs_1/r/datadict_help_tables_dev.result
      BitKeeper/deleted/.del-datadict_help_tables_dev.test:
        Delete: mysql-test/suite/funcs_1/t/datadict_help_tables_dev.test
      BitKeeper/deleted/.del-datadict_master.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_master.inc
      BitKeeper/deleted/.del-datadict_show_schema.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_show_schema.inc
      BitKeeper/deleted/.del-datadict_show_table_design.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_show_table_design.inc
      BitKeeper/deleted/.del-datadict_tables.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables.inc
      BitKeeper/deleted/.del-datadict_tables_error.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables_error.inc
      BitKeeper/deleted/.del-datadict_tables_error_1.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables_error_1.inc
      BitKeeper/deleted/.del-datadict_tables_error_1044.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables_error_1044.inc
      BitKeeper/deleted/.del-datadict_tables_error_1049.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables_error_1049.inc
      BitKeeper/deleted/.del-datadict_tables_error_1051.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables_error_1051.inc
      BitKeeper/deleted/.del-datadict_tables_error_1146.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables_error_1146.inc
      BitKeeper/deleted/.del-datadict_tables_error_1288.inc:
        Delete: mysql-test/suite/funcs_1/datadict/datadict_tables_error_1288.inc
      BitKeeper/deleted/.del-innodb__datadict.result:
        Delete: mysql-test/suite/funcs_1/r/innodb__datadict.result
      BitKeeper/deleted/.del-innodb__datadict.test:
        Delete: mysql-test/suite/funcs_1/t/innodb__datadict.test
      BitKeeper/deleted/.del-memory__datadict.test:
        Delete: mysql-test/suite/funcs_1/t/memory__datadict.test
      BitKeeper/deleted/.del-myisam__datadict.result:
        Delete: mysql-test/suite/funcs_1/r/myisam__datadict.result
      BitKeeper/deleted/.del-myisam__datadict.test:
        Delete: mysql-test/suite/funcs_1/t/myisam__datadict.test
      BitKeeper/deleted/.del-memory__datadict.result:
        Delete: mysql-test/suite/funcs_1/r/memory__datadict.result
      mysql-test/suite/funcs_1/README.txt:
        Cleanup in description
      mysql-test/suite/funcs_1/include/memory_tb1.inc:
        Move setting of variables into the caller scripts
      mysql-test/suite/funcs_1/include/memory_tb2.inc:
        Move setting of variables into the caller scripts
      mysql-test/suite/funcs_1/include/memory_tb3.inc:
        Move setting of variables into the caller scripts
      mysql-test/suite/funcs_1/include/memory_tb4.inc:
        Move setting of variables into the caller scripts
      mysql-test/suite/funcs_1/include/sp_tb.inc:
        Remove outdated comment
      mysql-test/suite/funcs_1/r/innodb_bitdata.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_cursors.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_02.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_06.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_07.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_storedproc_10.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_0102.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_0407.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_09.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_1011ext.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_trig_frkey.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb_views.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_bitdata.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_cursors.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_02.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_06.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_07.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_storedproc_10.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_0102.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_0407.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_09.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_trig_1011ext.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory_views.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_bitdata.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_cursors.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_02.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_06.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_07.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_storedproc_10.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_0102.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_03.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_0407.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_08.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_09.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_trig_1011ext.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam_views.result:
        Updated results
      mysql-test/suite/funcs_1/storedproc/load_sp_tb.inc:
        Move setting of variables into the caller scripts
      mysql-test/suite/funcs_1/t/innodb_bitdata.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_cursors.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_trig_0102.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_trig_03.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_trig_0407.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_trig_08.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_trig_09.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_trig_1011ext.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_trig_frkey.test:
        Cleanup
      mysql-test/suite/funcs_1/t/innodb_views.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_bitdata.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_cursors.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_trig_0102.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_trig_03.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_trig_0407.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_trig_08.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_trig_09.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_trig_1011ext.test:
        Cleanup
      mysql-test/suite/funcs_1/t/memory_views.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_bitdata.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_cursors.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_trig_0102.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_trig_03.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_trig_0407.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_trig_08.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_trig_09.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_trig_1011ext.test:
        Cleanup
      mysql-test/suite/funcs_1/t/myisam_views.test:
        Cleanup
      mysql-test/suite/funcs_1/t/charset_collation_1.test:
        Check content of information_schema views
           character_sets, collations,
           collation_character_set_applicability
        Build variant 1
      mysql-test/suite/funcs_1/t/charset_collation_2.test:
        Check content of information_schema views
           character_sets, collations,
           collation_character_set_applicability
        Build variant 2
      mysql-test/suite/funcs_1/t/charset_collation_3.test:
        Check content of information_schema views
           character_sets, collations,
           collation_character_set_applicability
        Build variant 3
      mysql-test/suite/funcs_1/t/is_basics_mixed.test:
        Test some basic properties which are independend of the storage
        engine used for the creation of tables.
      mysql-test/suite/funcs_1/t/is_character_sets.test:
        Tests related to functionality of
        information_schema.character_sets
      mysql-test/suite/funcs_1/t/is_collation_character_set_applicability.test:
        Tests related to functionality of
        information_schema.collation_character_set_applicability
      mysql-test/suite/funcs_1/t/is_collations.test:
        Tests related to functionality of
        information_schema.collations
      mysql-test/suite/funcs_1/t/is_column_privileges.test:
        Tests related to functionality of
        information_schema.column_privileges
      mysql-test/suite/funcs_1/t/is_column_privileges_is_mysql_test.test:
        Check content of information_schema.column_privileges about databases
        mysql and test
      mysql-test/suite/funcs_1/t/is_columns.test:
        Tests related to functionality of
        information_schema.columns
      mysql-test/suite/funcs_1/t/is_columns_innodb.test:
        Check content of information_schema.columns when some
        tables are preloaded
        Variant for InnoDB
      mysql-test/suite/funcs_1/t/is_columns_is.test:
        Check content of information_schema.columns about schema
        information_schema
      mysql-test/suite/funcs_1/t/is_columns_memory.test:
        Check content of information_schema.columns when some
        tables are preloaded
        Variant for MEMORY
      mysql-test/suite/funcs_1/t/is_columns_myisam.test:
        Check content of information_schema.columns when some
        tables are preloaded
        Variant for MyISAM
      mysql-test/suite/funcs_1/t/is_columns_mysql.test:
        Check content of information_schema.columns about schema
        mysql
      mysql-test/suite/funcs_1/t/is_columns_ndb.test:
        Check content of information_schema.columns when some
        tables are preloaded
        Variant for NDB
      mysql-test/suite/funcs_1/t/is_key_column_usage.test:
        Tests related to functionality of
        information_schema.key_column_usage
      mysql-test/suite/funcs_1/t/is_routines.test:
        Tests related to functionality of
        information_schema.routines
      mysql-test/suite/funcs_1/t/is_schema_privileges.test:
        Tests related to functionality of
        information_schema.schema_privileges
      mysql-test/suite/funcs_1/t/is_schema_privileges_is_mysql_test.test:
        Check content of information_schema.schema_privileges about schemas
        information_schema, mysql and test
      mysql-test/suite/funcs_1/t/is_schemata.test:
        Tests related to functionality of
        information_schema.schemata
      mysql-test/suite/funcs_1/t/is_schemata_is_mysql_test.test:
        Check content of information_schema.schemata about schemas
        information_schema, mysql and test
      mysql-test/suite/funcs_1/t/is_statistics.test:
        Tests related to functionality of
        information_schema.statistics
      mysql-test/suite/funcs_1/t/is_statistics_is.test:
        Check content of information_schema.statistics about schema
        information_schema
      mysql-test/suite/funcs_1/t/is_statistics_mysql.test:
        Check content of information_schema.statistics about schema
        mysql
      mysql-test/suite/funcs_1/t/is_table_constraints.test:
        Tests related to functionality of
        information_schema.table_constraints
      mysql-test/suite/funcs_1/t/is_table_constraints_is.test:
        Check content of information_schema.table_constraints about schema
        information_schema
      mysql-test/suite/funcs_1/t/is_table_constraints_mysql.test:
        Check content of information_schema.table_constraints about schema
        mysql
      mysql-test/suite/funcs_1/t/is_table_privileges.test:
        Tests related to functionality of
        information_schema.table_privileges
      mysql-test/suite/funcs_1/datadict/basics_mixed1.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/basics_mixed2.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/include/cleanup.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/r/charset_collation_1.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/charset_collation_2.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/charset_collation_3.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_basics_mixed.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_character_sets.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_collation_character_set_applicability.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_collations.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_column_privileges.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_column_privileges_is_mysql_test.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_columns.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_columns_innodb.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_columns_is.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_columns_memory.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_columns_myisam.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_columns_mysql.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_columns_ndb.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_key_column_usage.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_routines.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_schema_privileges.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_schema_privileges_is_mysql_test.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_schemata.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_schemata_is_mysql_test.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_statistics.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_statistics_is.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_statistics_mysql.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_table_constraints.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_table_constraints_is.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_table_constraints_mysql.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_table_privileges.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_tables.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_tables_innodb.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_tables_is.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_tables_memory.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_tables_myisam.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_tables_mysql.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_tables_ndb.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_triggers.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_user_privileges.result:
        Expected result for new test
      mysql-test/suite/funcs_1/r/is_views.result:
        Expected result for new test
      mysql-test/suite/funcs_1/t/is_tables.test:
        Tests related to functionality of
        information_schema.tables
      mysql-test/suite/funcs_1/t/is_tables_innodb.test:
        Check content of information_schema.tables when some
        tables are preloaded
        Variant for InnoDB
      mysql-test/suite/funcs_1/t/is_tables_is.test:
        Check content of information_schema.tables about schema
        information_schema
      mysql-test/suite/funcs_1/t/is_tables_memory.test:
        Check content of information_schema.tables when some
        tables are preloaded
        Variant for MEMORY
      mysql-test/suite/funcs_1/t/is_tables_myisam.test:
        Check content of information_schema.tables when some
        tables are preloaded
        Variant for MyISAM
      mysql-test/suite/funcs_1/t/is_tables_mysql.test:
        Check content of information_schema.tables about schema
        mysql
      mysql-test/suite/funcs_1/t/is_tables_ndb.test:
        Check content of information_schema.tables when some
        tables are preloaded
        Variant for NDB
      mysql-test/suite/funcs_1/t/is_triggers.test:
        Tests related to functionality of
        information_schema.triggers
      mysql-test/suite/funcs_1/t/is_user_privileges.test:
        Tests related to functionality of
        information_schema.user_privileges
      mysql-test/suite/funcs_1/t/is_views.test:
        Tests related to functionality of
        information_schema.views
      mysql-test/suite/funcs_1/datadict/basics_mixed3.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/charset_collation.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/columns.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/datadict.pre:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/is_table_query.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/statistics.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/table_constraints.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/tables1.inc:
        Auxiliary script
      mysql-test/suite/funcs_1/datadict/tables2.inc:
        Auxiliary script
      d6e42aac
  3. 29 Aug, 2007 1 commit
    • unknown's avatar
      Post merge fix 2 for · f5536380
      unknown authored
           ChangeSet@1.2509, 2007-08-28
           http://lists.mysql.com/commits/33239
        Fixes for the funcs_1 datadict test bugs
        #30418 "datadict" tests (all engines) fail:
               Dependency on the host name for ordering
        #30420 "datadict" tests (all engines) fail:
               Release build has help tables loaded
        #30438 "{memory,myisam,ndb}__datadict" tests fail:
               Use "InnoDB" without checking
        #30440 "datadict" tests (all engines) fail:
               Character sets depend on
                         configuration
      
      
      mysql-test/suite/funcs_1/README.txt:
        Improved README
      mysql-test/suite/funcs_1/datadict/datadict_load.inc:
        Additions for the NDB variant (currently not in use)
      mysql-test/suite/funcs_1/datadict/datadict_master.inc:
        Write a comment about Bug#30689 into the test protocols.
      mysql-test/suite/funcs_1/datadict/processlist_priv.inc:
        Fix for a not reported bug.
        The missing revoke usage and drop user harmed the next test.
      mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result:
        Updated results
      mysql-test/suite/funcs_1/r/b_processlist_priv_ps.result:
        Updated results
      mysql-test/suite/funcs_1/r/innodb__datadict.result:
        Updated results
      mysql-test/suite/funcs_1/r/memory__datadict.result:
        Updated results
      mysql-test/suite/funcs_1/r/myisam__datadict.result:
        Updated results
      mysql-test/suite/funcs_1/r/ndb__datadict.result:
        Updated results as far as they could be corrected.
        Attention:
           This test failed even before the current bug fixes.
           The updated expected results are now better than before,
           but they do not prevent that the test fails.
           It looks like one script is "damaged" and treats
           this NDB test different than expected within the
           file with expected results.
      f5536380
  4. 28 Aug, 2007 1 commit
    • unknown's avatar
      Fixes for · 8c1e2069
      unknown authored
           Bug#30418 "datadict" tests (all engines) fail: Dependency on the host name
                      for ordering
           Bug#30420 "datadict" tests (all engines) fail: Release build has help tables loaded
           Bug#30438 "{memory,myisam,ndb}__datadict" tests fail: Use "InnoDB" without checking
           Bug#30440 "datadict" tests (all engines) fail: Character sets depend on configuration
      Attention: Only the build team can check if Bug#30440 is really fixed.
      
      
      mysql-test/suite/funcs_1/README.txt:
        Update README
      mysql-test/suite/funcs_1/datadict/datadict_master.inc:
        1. Exclude the help tables from the INFORMATION_SCHEMA.TABLES
           and the INFORMATION_SCHEMA.STATISTICS selects.
        2. Replace error numbers with error names
        3. Sort some results with mysqltest builtin function
        4. Some other minor changes
      mysql-test/suite/funcs_1/r/innodb__datadict.result:
        Updated expected results
      mysql-test/suite/funcs_1/r/memory__datadict.result:
        Updated expected results
      mysql-test/suite/funcs_1/r/myisam__datadict.result:
        Updated expected results
      mysql-test/suite/funcs_1/t/innodb__datadict.test:
        Add $OTHER_ENGINE_TYPE variable which is used in data_dict_master.inc.
      mysql-test/suite/funcs_1/t/memory__datadict.test:
        Add $OTHER_ENGINE_TYPE variable which is used in data_dict_master.inc.
      mysql-test/suite/funcs_1/t/myisam__datadict.test:
        Add $OTHER_ENGINE_TYPE variable which is used in data_dict_master.inc.
      mysql-test/suite/funcs_1/r/datadict_help_tables_build.result:
        File with expected results
      mysql-test/suite/funcs_1/r/datadict_help_tables_dev.result:
        File with expected results
      mysql-test/suite/funcs_1/t/datadict_help_tables_build.test:
        Additional test checking the information about the help tables within
               INFORMATION_SCHEMA.TABLES/INFORMATION_SCHEMA.STATISTICS
        as compensation for the removed checks within datadict_master.inc.
        Variant for use during build tests (non empty help tables)
      mysql-test/suite/funcs_1/t/datadict_help_tables_dev.test:
        Additional test checking the information about the help tables within
               INFORMATION_SCHEMA.TABLES/INFORMATION_SCHEMA.STATISTICS
        as compensation for the removed checks within datadict_master.inc.
        Variant for use during development tests (empty help tables)
      8c1e2069
  5. 06 Feb, 2007 2 commits
    • unknown's avatar
      copy from test-extra-5.0 to main tree · 630091fe
      unknown authored
      BitKeeper/etc/ignore:
        Added mysql-test/mysql-test-run-shell to the ignore list
      mysql-test/suite/funcs_2/include/check_charset.inc:
        finished files with newline
      630091fe
    • unknown's avatar
      copy from test-extra-5.1 to main tree · ee5eb8bb
      unknown authored
      BitKeeper/etc/ignore:
        Added mysql-test/suite/funcs_1/r/innodb_views.warnings mysql-test/suite/funcs_1/r/memory_trig_03e.warnings mysql-test/suite/funcs_1/r/memory_views.warnings mysql-test/suite/funcs_1/r/myisam_trig_03e.warnings mysql-test/suite/funcs_1/r/myisam_views.warnings mysql-test/suite/funcs_1/r/ndb_trig_03e.warnings mysql-test/suite/funcs_1/r/ndb_views.warnings mysql-test/suite/partitions/r/diff mysql-test/suite/partitions/r/partition_bit_ndb.warnings mysql-test/suite/partitions/r/partition_special_innodb.warnings mysql-test/suite/partitions/r/partition_special_myisam.warnings storage/archive/archive_reader mysql-test/suite/funcs_1/r/innodb_trig_03e.warnings to the ignore list
      mysql-test/suite/funcs_2/include/check_charset.inc:
        inserted newline at the end of file.
      mysql-test/suite/objects/include/drop_all.inc:
        inserted newline at the end of file.
      mysql-test/suite/partitions/include/partition_key_32col.inc:
        inserted newline at the end of file.
      mysql-test/suite/rpl/data/rpl_mixed.dat:
        inserted newline at the end of file.
      mysql-test/suite/rpl/include/rpl_mixed_check_event.inc:
        inserted newline at the end of file.
      mysql-test/suite/rpl/include/rpl_mixed_check_select.inc:
        inserted newline at the end of file.
      mysql-test/suite/rpl/include/rpl_mixed_check_user.inc:
        inserted newline at the end of file.
      mysql-test/suite/rpl/include/rpl_mixed_check_view.inc:
        inserted newline at the end of file.
      ee5eb8bb