An error occurred fetching the project authors.
  1. 22 Feb, 2006 1 commit
    • unknown's avatar
      Bug#10460 SHOW CREATE TABLE uses inconsistent upper/lower case · 31a7a0d6
      unknown authored
      mysql-test/r/alter_table.result:
        Update test result
      mysql-test/r/analyse.result:
        Update test result
      mysql-test/r/archive.result:
        Update test result
      mysql-test/r/archive_bitfield.result:
        Update test result
      mysql-test/r/archive_gis.result:
        Update test result
      mysql-test/r/bdb.result:
        Update test result
      mysql-test/r/bdb_gis.result:
        Update test result
      mysql-test/r/bigint.result:
        Update test result
      mysql-test/r/binary.result:
        Update test result
      mysql-test/r/case.result:
        Update test result
      mysql-test/r/cast.result:
        Update test result
      mysql-test/r/constraints.result:
        Update test result
      mysql-test/r/create.result:
        Update test result
      mysql-test/r/ctype_collate.result:
        Update test result
      mysql-test/r/ctype_create.result:
        Update test result
      mysql-test/r/ctype_latin1_de.result:
        Update test result
      mysql-test/r/ctype_many.result:
        Update test result
      mysql-test/r/ctype_mb.result:
        Update test result
      mysql-test/r/ctype_recoding.result:
        Update test result
      mysql-test/r/ctype_sjis.result:
        Update test result
      mysql-test/r/ctype_tis620.result:
        Update test result
      mysql-test/r/ctype_ucs.result:
        Update test result
      mysql-test/r/ctype_ujis.result:
        Update test result
      mysql-test/r/ctype_utf8.result:
        Update test result
      mysql-test/r/default.result:
        Update test result
      mysql-test/r/events.result:
        Update test result
      mysql-test/r/federated.result:
        Update test result
      mysql-test/r/fulltext.result:
        Update test result
      mysql-test/r/func_gconcat.result:
        Update test result
      mysql-test/r/func_group.result:
        Update test result
      mysql-test/r/func_math.result:
        Update test result
      mysql-test/r/func_misc.result:
        Update test result
      mysql-test/r/func_str.result:
        Update test result
      mysql-test/r/func_system.result:
        Update test result
      mysql-test/r/gis-rtree.result:
        Update test result
      mysql-test/r/heap.result:
        Update test result
      mysql-test/r/index_merge_innodb.result:
        Update test result
      mysql-test/r/information_schema.result:
        Update test result
      mysql-test/r/innodb.result:
        Update test result
      mysql-test/r/innodb_gis.result:
        Update test result
      mysql-test/r/key.result:
        Update test result
      mysql-test/r/merge.result:
        Update test result
      mysql-test/r/myisam.result:
        Update test result
      mysql-test/r/mysqldump-max.result:
        Update test result
      mysql-test/r/mysqldump.result:
        Update test result
      mysql-test/r/ndb_bitfield.result:
        Update test result
      mysql-test/r/ndb_gis.result:
        Update test result
      mysql-test/r/ndb_partition_key.result:
        Update test result
      mysql-test/r/null.result:
        Update test result
      mysql-test/r/partition.result:
        Update test result
      mysql-test/r/partition_02myisam.result:
        Update test result
      mysql-test/r/partition_mgm_err.result:
        Update test result
      mysql-test/r/partition_range.result:
        Update test result
      mysql-test/r/ps_2myisam.result:
        Update test result
      mysql-test/r/ps_3innodb.result:
        Update test result
      mysql-test/r/ps_4heap.result:
        Update test result
      mysql-test/r/ps_5merge.result:
        Update test result
      mysql-test/r/ps_6bdb.result:
        Update test result
      mysql-test/r/rpl_mixed_ddl_dml.result:
        Update test result
      mysql-test/r/rpl_multi_engine.result:
        Update test result
      mysql-test/r/rpl_ndb_UUID.result:
        Update test result
      mysql-test/r/show_check.result:
        Update test result
      mysql-test/r/sp-vars.result:
        Update test result
      mysql-test/r/sp.result:
        Update test result
      mysql-test/r/sql_mode.result:
        Update test result
      mysql-test/r/strict.result:
        Update test result
      mysql-test/r/subselect.result:
        Update test result
      mysql-test/r/symlink.result:
        Update test result
      mysql-test/r/synchronization.result:
        Update test result
      mysql-test/r/system_mysql_db.result:
        Update test result
      mysql-test/r/temp_table.result:
        Update test result
      mysql-test/r/trigger.result:
        Update test result
      mysql-test/r/type_binary.result:
        Update test result
      mysql-test/r/type_bit.result:
        Update test result
      mysql-test/r/type_bit_innodb.result:
        Update test result
      mysql-test/r/type_blob.result:
        Update test result
      mysql-test/r/type_decimal.result:
        Update test result
      mysql-test/r/type_enum.result:
        Update test result
      mysql-test/r/type_float.result:
        Update test result
      mysql-test/r/type_nchar.result:
        Update test result
      mysql-test/r/type_newdecimal.result:
        Update test result
      mysql-test/r/type_set.result:
        Update test result
      mysql-test/r/type_timestamp.result:
        Update test result
      mysql-test/r/type_varchar.result:
        Update test result
      mysql-test/r/union.result:
        Update test result
      mysql-test/r/user_var.result:
        Update test result
      mysql-test/r/variables.result:
        Update test result
      sql/sql_show.cc:
        Make ouput from SHOW CREATE TABLE use uppercase for "CHARACTER SET", "COLLATE", "DEFAULT", "ON UPDATE" and "AUTO_INCREMENT"
      31a7a0d6
  2. 30 Nov, 2005 1 commit
    • unknown's avatar
      Fix union.result · b775d23f
      unknown authored
      mysql-test/r/union.result:
        Fix order of test results
      b775d23f
  3. 29 Oct, 2005 1 commit
  4. 27 Sep, 2005 1 commit
  5. 23 Sep, 2005 1 commit
    • unknown's avatar
      Merge from 4.1 to 5.0 · 72a8049b
      unknown authored
      mysql-test/r/loaddata.result:
        Add drop tablea after test case
      mysql-test/r/type_decimal.result:
        Update warnings
      mysql-test/r/union.result:
        Miss in merge
      mysql-test/t/loaddata.test:
        Add drop table after test case
      sql/opt_sum.cc:
        Add missing }
      sql/sql_load.cc:
        Manual merge
      72a8049b
  6. 21 Sep, 2005 1 commit
    • unknown's avatar
      a fix (bug #7589: Decimal types are ignored when updating data from another column). · 24922a30
      unknown authored
      mysql-test/r/union.result:
        a fix (bug #7589: Decimal types are ignored when updating data from another column).
        removed wrong test result (see #13372)
      mysql-test/t/union.test:
        a fix (bug #7589: Decimal types are ignored when updating data from another column).
        removed wrong test result (see #13372)
      sql/field_conv.cc:
        a fix (bug #7589: Decimal types are ignored when updating data from another column).
        use memcpy() only for identical decimals.
      24922a30
  7. 12 Aug, 2005 1 commit
    • unknown's avatar
      Implementation of WL#2486 - · 7517d7e1
      unknown authored
      "Process NATURAL and USING joins according to SQL:2003".
      
      * Some of the main problems fixed by the patch:
        - in "select *" queries the * expanded correctly according to
          ANSI for arbitrary natural/using joins
        - natural/using joins are correctly transformed into JOIN ... ON
          for any number/nesting of the joins.
        - column references are correctly resolved against natural joins
          of any nesting and combined with arbitrary other joins.
      
      * This patch also contains a fix for name resolution of items
        inside the ON condition of JOIN ... ON - in this case items must
        be resolved only against the JOIN operands. To support such
        'local' name resolution, the patch introduces a stack of
        name resolution contexts used at parse time.
      
      NOTICE:
      - This patch is not complete in the sense that
        - there are 2 test cases that still do not pass -
          one in join.test, one in select.test. Both are marked
          with a comment "TODO: WL#2486".
        - it does not include a new test specific for the task
      
      
      mysql-test/include/ps_query.inc:
        Adjusted according to standard NATURAL/USING join semantics.,
      mysql-test/r/bdb.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/derived.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/errors.result:
        The column as a whole cannot be resolved, so different error message.
      mysql-test/r/fulltext.result:
        Adjusted according to standard JOIN ... ON semantics =>
        the ON condition can refer only to the join operands.
      mysql-test/r/fulltext_order_by.result:
        More detailed error message.
      mysql-test/r/innodb.result:
        Adjusted according to standard NATURAL/USING join semantics.
        This test doesn't pass completetly yet!
      mysql-test/r/insert_select.result:
        More detailed error message.
      mysql-test/r/join.result:
        Adjusted according to standard NATURAL/USING join semantics.
        
        NOTICE: there is one test case that still fails, and it is
        commeted out and marked with WL#2486 in the test file.
      mysql-test/r/join_crash.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/join_nested.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/join_outer.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/multi_update.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/null_key.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/order_by.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/ps_2myisam.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/ps_3innodb.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/ps_4heap.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/ps_5merge.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/ps_6bdb.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/ps_7ndb.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/select.result:
        Adjusted according to standard NATURAL/USING join semantics.
        
        NOTICE: there is one failing test case which is commented with
        WL#2486 in the test file.
      mysql-test/r/subselect.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/type_ranges.result:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/r/union.result:
        More detailed error message.
      mysql-test/t/bdb.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/errors.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/fulltext.test:
        Adjusted according to standard JOIN ... ON semantics =>
        the ON condition can refer only to the join operands.
      mysql-test/t/fulltext_order_by.test:
        More detailed error message.
      mysql-test/t/innodb.test:
        Adjusted according to standard NATURAL/USING join semantics.
        This test doesn't pass completetly yet!
      mysql-test/t/insert_select.test:
        More detailed error message.
      mysql-test/t/join.test:
        Adjusted according to standard NATURAL/USING join semantics.
        
        NOTICE: there is one test case that still fails, and it is
        commeted out and marked with WL#2486 in the test file.
      mysql-test/t/join_crash.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/join_nested.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/join_outer.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/null_key.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/order_by.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/select.test:
        Adjusted according to standard NATURAL/USING join semantics.
        
        NOTICE: there is one test case that still fails, and it is
        commeted out and marked with WL#2486 in the test file.
      mysql-test/t/subselect.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/type_ranges.test:
        Adjusted according to standard NATURAL/USING join semantics.
      mysql-test/t/union.test:
        More detailed error message.
      sql/item.cc:
        - extra parameter to find_field_in_tables
        - find_field_in_real_table renamed to find_field_in_table
        - fixed comments/typos
      sql/item.h:
        - added [first | last]_name_resolution_table to class
          Name_resolution_context
        - commented old code
        - standardized formatting
      sql/mysql_priv.h:
        - refactored the find_field_in_XXX procedures,
        - added a new procedure for natural join table references,
        - renamed the find_field_in_XXX procedures to clearer names
      sql/sp.cc:
        - pass the top-most list of the FROM clause to setup_tables
        - extra parameter to find_field_in_tables
      sql/sql_acl.cc:
        - renamed find_field_in_table => find_field_in_table_ref
        - extra parameter to find_field_in_table_ref
        - commented old code
      sql/sql_base.cc:
        This file contains the core of the implementation of the processing
        of NATURAL/USING joins (WL#2486).
        - added many comments to old code
        - refactored the group of find_field_in_XXX procedures, and added a
          new procedure for natural joins. There is one find_field_in_XXX procedure
          per each type of table reference (stored table, merge view, or natural
          join); one meta-procedure that selects the correct one depeneding on the
          table reference; and one procedure that goes over a list of table
          referenes.
        - NATURAL/USING joins are processed through the procedures:
            mark_common_columns, store_natural_using_join_columns,
            store_top_level_join_columns, setup_natural_join_row_types.
          The entry point to processing NATURAL/USING joins is the
          procedure 'setup_natural_join_row_types'.
        - Replaced the specialized Field_iterator_XXX iterators with one
          generic iterator over the fields of a table reference.
        - Simplified 'insert_fields' and 'setup_conds' due to encapsulation of
          the processing of natural joins in a separate set of procedures.
      sql/sql_class.h:
        - Commented old code.
      sql/sql_delete.cc:
        - Pass the FROM clause to setup_tables.
      sql/sql_help.cc:
        - pass the end name resolution table to find_field_in_tables
        - adjust the list of tables for name resolution
      sql/sql_insert.cc:
        - Changed the code that saves and restores the current context to
          support the list of tables for name resolution -
          context->first_name_resolution_table, and
          table_list->next_name_resolution_table.
          Needed to support an ugly trick to resolve inserted columns only in
          the first table.
        - Added Name_resolution_context::[first | last]_name_resolution_table.
        - Commented old code
      sql/sql_lex.cc:
        - set select_lex.parent_lex correctly
        - set correct state of the current name resolution context
      sql/sql_lex.h:
        - Added a stack of name resolution contexts to support local
          contexts for JOIN ... ON conditions.
        - Commented old code.
      sql/sql_load.cc:
        - Pass the FROM clause to setup_tables.
      sql/sql_olap.cc:
        - Pass the FROM clause to setup_tables.
      sql/sql_parse.cc:
        - correctly set SELECT_LEX::parent_lex
        - set the first table of the current name resoltion context
        - added support for NATURAL/USING joins
        - commented old code
      sql/sql_select.cc:
        - Pass the FROM clause to setup_tables.
        - Pass the end table to find_field_in_tables
        - Improved comments
      sql/sql_show.cc:
        - Set SELECT_LEX::parent_lex.
      sql/sql_update.cc:
        - Pass the FROM clause to setup_tables.
      sql/sql_yacc.yy:
        - Added support for a stack of name resolution contexts needed to
          implement name resolution for JOIN ... ON. A context is pushed
          for each new JOIN ... ON, and popped afterwards.
        - Added support for NATURAL/USING joins.
      sql/table.cc:
        - Added new class Natural_join_column to hide the heterogeneous
          representation of column references for stored tables and for
          views.
        - Added a new list TABLE_LIST::next_name_resolution_table to
          support name resolution with NATURAL/USING joins. Also added
          other members to TABLE_LIST to support NATURAL/USING joins.
        - Added a generic iterator over the fields of table references
          of various types - class Field_iterator_table_ref
      sql/table.h:
        - Added new class Natural_join_column to hide the heterogeneous
          representation of column references for stored tables and for
          views.
        - Added a new list TABLE_LIST::next_name_resolution_table to
          support name resolution with NATURAL/USING joins. Also added
          other members to TABLE_LIST to support NATURAL/USING joins.
        - Added a generic iterator over the fields of table references
          of various types - class Field_iterator_table_ref
      tests/mysql_client_test.c:
        Adjusted according to standard NATURAL JOIN syntax.
      7517d7e1
  8. 26 May, 2005 2 commits
    • unknown's avatar
      Fix broken test case (after merge) · 6a7dedf2
      unknown authored
      mysql-test/r/union.result:
        Convert back the latin1 characters that where accidently changed during last merge
      mysql-test/t/union.test:
        Convert back the latin1 characters that where accidently changed during last merge
      6a7dedf2
    • unknown's avatar
      fixed problem with long string results of expressions in UNIONS (BUG#10025) · 80b0baa7
      unknown authored
      mysql-test/r/union.result:
        test for Bug #10025
      mysql-test/t/union.test:
        test for Bug #10025
      sql/item.cc:
        set HA_OPTION_PACK_RECORD and change type to MYSQL_TYPE_STRING, to allow correct field creation in case of length more then 255 (creation STRING field with length more then 255)
      80b0baa7
  9. 05 May, 2005 1 commit
    • unknown's avatar
      Tests and results fixed with last precision/decimal related modifications · 8a27426f
      unknown authored
      mysql-test/r/case.result:
        test result fixed
      mysql-test/r/create.result:
        test result fixed
      mysql-test/r/distinct.result:
        test result fixed
      mysql-test/r/func_group.result:
        test result fixed
      mysql-test/r/func_op.result:
        test result fixed
      mysql-test/r/group_by.result:
        test result fixed
      mysql-test/r/metadata.result:
        test result fixed
      mysql-test/r/olap.result:
        test result fixed
      mysql-test/r/ps_2myisam.result:
        test result fixed
      mysql-test/r/ps_3innodb.result:
        test result fixed
      mysql-test/r/ps_4heap.result:
        test result fixed
      mysql-test/r/ps_5merge.result:
        test result fixed
      mysql-test/r/ps_6bdb.result:
        test result fixed
      mysql-test/r/ps_7ndb.result:
        test result fixed
      mysql-test/r/select.result:
        test result fixed
      mysql-test/r/sp.result:
        test result fixed
      mysql-test/r/type_decimal.result:
        test result fixed
      mysql-test/r/type_newdecimal.result:
        test result fixed
      mysql-test/r/union.result:
        test result fixed
      mysql-test/r/variables.result:
        test result fixed
      mysql-test/t/func_group.test:
        test modified
      mysql-test/t/olap.test:
        test modified
      mysql-test/t/type_decimal.test:
        test modified
      8a27426f
  10. 26 Apr, 2005 1 commit
    • unknown's avatar
      union.result: · 783705fc
      unknown authored
        Results for the above test case
      union.test:
        A test case for bug #10032 involving UNION's and ORDER BY clause
      sql_yacc.yy:
        Fix for a bug #10032 involving a parser bug with UNION's and ORDER BY
      
      
      sql/sql_yacc.yy:
        Fix for a bug #10032 involving a parser bug with UNION's and ORDER BY
      mysql-test/t/union.test:
        A test case for bug #10032 involving UNION's and ORDER BY clause
      mysql-test/r/union.result:
        Results for the above test case
      783705fc
  11. 10 Apr, 2005 1 commit
    • unknown's avatar
      ctype_collate.result, ctype_collate.test, union.result, union.test: · ebdf2c01
      unknown authored
        fixing tests accordingly
      item.cc:
        Allow mixing non-binary collation and binary collation
        even if coercibility is the same. 
        For easier 4.0 -> 4.1 migrating.
      
      
      sql/item.cc:
        Allow mixing non-binary collation and binary collation
        even if coercibility is the same. 
        For easier 4.0 -> 4.1 migrating.
      mysql-test/t/union.test:
        fixing tests accordingly
      mysql-test/r/union.result:
        fixing tests accordingly
      mysql-test/t/ctype_collate.test:
        fixing tests accordingly
      mysql-test/r/ctype_collate.result:
        fixing tests accordingly
      ebdf2c01
  12. 04 Apr, 2005 1 commit
    • unknown's avatar
      Don't use -lsupc++ with gcc 3.3 and below as this gives linking problems when linking staticly · ce169a54
      unknown authored
      Fix that mysql.proc works with new VARCHAR fields
      Give warnings for wrong zero dates
      
      
      configure.in:
        Don't use -lsupc++ with gcc 3.3 and below as this gives linking problems when linking staticly
      mysql-test/r/func_time.result:
        New warnings
      mysql-test/r/row.result:
        Moved code around to get things to work with --ps-protocol
        Note that one on warning disappered, but it should appear again when bug #9600 is fixed
      mysql-test/r/strict.result:
        enabled more tests
        Added more tests
      mysql-test/r/union.result:
        Test that UNION generates correct row format
      mysql-test/t/row.test:
        Moved test to get things to work with --ps-protocol
      mysql-test/t/strict.test:
        enabled more tests
        Added more tests
      mysql-test/t/union.test:
        Test that UNION generates correct row format
      sql/item.cc:
        Removed compiler warning
        Simple cleanup
      sql/sp.cc:
        Fix that mysql.proc works with new VARCHAR fields
      sql/time.cc:
        Give warnings for wrong zero dates
      tests/mysql_client_test.c:
        More startup information
      ce169a54
  13. 31 Mar, 2005 1 commit
    • unknown's avatar
      postmerge 4.1->5.0 fixes · c831a156
      unknown authored
      mysql-test/r/group_by.result:
        result change
      mysql-test/r/union.result:
        result change
      mysql-test/r/view.result:
        result change
      mysql-test/t/subselect.test:
        fixed mistake of merge
      sql/field.cc:
        new 5.0 types support
        temporary table/db names detection in field fixed
      sql/field.h:
        removed non-existent methods
        added wrongly deleted during manual merge string
      sql/item.cc:
        support of new types added to merge of union types routines
      sql/item.h:
        fixed method definition
      sql/item_cmpfunc.cc:
        fixed type
      sql/item_func.h:
        item type name fixed
      sql/item_subselect.cc:
        added forgoten methods
      sql/item_subselect.h:
        fixed type
      sql/sql_derived.cc:
        fixed typo of manual merge
      sql/sql_view.cc:
        added new parameter
      c831a156
  14. 28 Mar, 2005 1 commit
    • unknown's avatar
      union.test: · e62a32a3
      unknown authored
        Bug #6519 UNION with collation binary and latin1_swedish_ci fails now
        Prove that this problem was fixed with bug9425 fix too.
      
      
      mysql-test/t/union.test:
        Bug #6519 UNION with collation binary and latin1_swedish_ci fails now
        Prove that this problem was fixed with bug9425 fix too.
      e62a32a3
  15. 23 Mar, 2005 1 commit
    • unknown's avatar
      fixed union types merging and table related metadata (BUG#8824) · 5a425250
      unknown authored
      mysql-test/r/func_group.result:
        new result
      mysql-test/r/metadata.result:
        new result
        test of metadata of variables, unions and derived tables
      mysql-test/r/union.result:
        new results
        test of union of enum
      mysql-test/t/metadata.test:
        test of metadata of variables, unions and derived tables
      mysql-test/t/union.test:
        test of union of enum
      sql/field.cc:
        Field type merging rules added
        Fixed table name/alias returting for field made from temporary tables
      sql/field.h:
        removed unned field type reporting
      sql/item.cc:
        fixed bug in NEW_DATE type field creartion
        replaced mechanism of merging types of UNION
      sql/item.h:
        replaced mechanism of merging types of UNION
      sql/item_func.h:
        new item type to make correct field type detection possible
      sql/item_subselect.cc:
        added table name parameter to prepare() to show right table alias for derived tables
      sql/sql_derived.cc:
        added table name parameter to prepare() to show right table alias for derived tables
      sql/sql_lex.h:
        added table name parameter to prepare() to show right table alias for derived tables
      sql/sql_parse.cc:
        made function for enum/set pack length calculation
      sql/sql_prepare.cc:
        added table name parameter to prepare() to show right table alias for derived tables
      sql/sql_select.cc:
        new temporary table field creation by Item_type_holder
        fixed table alias for temporary table
      sql/sql_union.cc:
        added table name parameter to prepare() to show right table alias for derived tables
      5a425250
  16. 13 Feb, 2005 1 commit
    • unknown's avatar
      Bug#2435 · a8d2152f
      unknown authored
        Alter handling for UNION syntax
        Tests for UNION and parentheses
      
      
      mysql-test/r/union.result:
        Bug#2435
          Tests for UNION and parentheses
      mysql-test/t/union.test:
        Bug#2435
          Tests for UNION and parentheses
      sql/sql_yacc.yy:
        Bug#2435
          Amend handling of UNION with parentheses.
      a8d2152f
  17. 08 Feb, 2005 1 commit
    • unknown's avatar
      Precision Math implementation · 91db48e3
      unknown authored
      BitKeeper/etc/ignore:
        Added client/decimal.c client/my_decimal.cc client/my_decimal.h to the ignore list
      91db48e3
  18. 04 Feb, 2005 1 commit
    • unknown's avatar
      A fix: bug#6931: Date Type column problem when using UNION-Table · 66eb71f3
      unknown authored
             bug#7833:  Wrong datatype of aggregate column is returned
      
      
      mysql-test/r/func_group.result:
        Test case for bug 7833:  Wrong datatype of aggregate column is returned
      mysql-test/r/union.result:
        Test case for bug 6931: Date Type column problem when using UNION-Table.
      mysql-test/t/func_group.test:
        Test case for bug 7833:  Wrong datatype of aggregate column is returned
      mysql-test/t/union.test:
        Test case for bug 6931: Date Type column problem when using UNION-Table.
      66eb71f3
  19. 18 Jan, 2005 3 commits
    • unknown's avatar
      fixing wrong value for "examined rows" when UNION's are used. · 59ef5bed
      unknown authored
      mysql-test/r/union.result:
        result for a test case for the wrong examined rows with UNION's
      mysql-test/t/union.test:
        test case for the wrong examined rows with UNION's
      sql/sql_union.cc:
        a patch for the wrong examined rows with UNION's
      59ef5bed
    • unknown's avatar
      After-merge clean-up · 764501e7
      unknown authored
      764501e7
    • unknown's avatar
      1. Item now uses my_charset_bin by default, · cd89ed9a
      unknown authored
      not default_charset_into. It fixes the
      problem that in some cases numbers where
      treated as CHAR(N), not as BINARY(N), e.g.
      wrong 'charsetnr' when sent to the client side.
      2. IFNULL didn't aggregate argument charsets
      and collations, so IFNULL(1,'a') produced
      a CHAR(N). Now produces a BINARY(N).
      3. SELECT PROCEDURE ANALIZE now returns
      BINARY columns, which is much better than it worked
      previously: CHAR with the default character set.
      But in the future it's worth to fix the fields
      'Field_name' and 'Optimal_fieldtype' to use UTF8,
      and 'Min_value' and 'Max_value' to inherit their charsets
      from the original items. But it is not important,
      and BINARY(N) is OK for now.
      4. Tests were fixed accordingly. No new tests were
      made, as the old onces cover everything.
      
      
      mysql-test/r/analyse.result:
        SELECT PROCEDURE ANALIZE now returns
        BINARY columns, which is much better than it worked
        previously: CHAR with the default character set.
        But in the future it's worth to fix the fields
        'Field_name' and 'Optimal_fieldtype' to use UTF8,
        and 'Min_value' and 'Max_value' to inherit their charsets
        from the original items. But it is not important,
        and BINARY(N) is OK for now.
      mysql-test/r/case.result:
        Test fix according to the changes
      mysql-test/r/metadata.result:
        Test fix according to the changes
      mysql-test/r/ps_1general.result:
        Test fix according to the changes
      mysql-test/r/ps_2myisam.result:
        Test fix according to the changes
      mysql-test/r/ps_3innodb.result:
        Test fix according to the changes
      mysql-test/r/ps_4heap.result:
        Test fix according to the changes
      mysql-test/r/ps_5merge.result:
        Test fix according to the changes
      mysql-test/r/ps_6bdb.result:
        Test fix according to the changes
      mysql-test/r/ps_7ndb.result:
        Test fix according to the changes
      mysql-test/r/union.result:
        Test fix according to the changes
      sql/item.cc:
        Item is now BINARY by default
      sql/item_cmpfunc.cc:
        IFNULL now collects arguments collations/charsets
        like other functions do.
      cd89ed9a
  20. 30 Dec, 2004 1 commit
    • unknown's avatar
      wl#1629 SHOW with WHERE(final part, after review) · 525242d3
      unknown authored
        added syntax:
        'show variables where', 'show status where', 'show open tables where'
      
      
      mysql-test/r/grant_cache.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/information_schema.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/query_cache.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/temp_table.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/union.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/t/information_schema.test:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/t/query_cache.test:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/item.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/mysql_priv.h:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_parse.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_select.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_show.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_yacc.yy:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/table.h:
        wl#1629 SHOW with WHERE(final part,after review)
      525242d3
  21. 08 Dec, 2004 1 commit
  22. 07 Dec, 2004 1 commit
    • unknown's avatar
      Update results for new varchar handling · 9ca50fe1
      unknown authored
      Fixed compiler warnings
      String results in CREATE ... SELECT are now created as CHAR(0), VARCHAR(X) or TEXT() depending on item->max_length
      
      
      myisam/myisampack.c:
        Indentation cleanup
      mysql-test/r/analyse.result:
        Update results for new varchar handling
      mysql-test/r/case.result:
        Update results for new varchar handling
      mysql-test/r/cast.result:
        Update results for new varchar handling
      mysql-test/r/create.result:
        Update results for new varchar handling
      mysql-test/r/ctype_mb.result:
        Update results for new varchar handling
      mysql-test/r/ctype_ucs.result:
        Update results for new varchar handling
      mysql-test/r/ctype_utf8.result:
        Update results for new varchar handling
      mysql-test/r/func_group.result:
        Update results for new varchar handling
      mysql-test/r/func_str.result:
        Update results for new varchar handling
      mysql-test/r/func_system.result:
        Update results for new varchar handling
      mysql-test/r/heap.result:
        Update results for new varchar handling
      mysql-test/r/heap_hash.result:
        Update results for new varchar handling
      mysql-test/r/information_schema.result:
        Update results for new varchar handling
      mysql-test/r/metadata.result:
        Update results for new varchar handling
      mysql-test/r/null.result:
        Update results for new varchar handling
      mysql-test/r/ps_2myisam.result:
        Update results for new varchar handling
      mysql-test/r/ps_3innodb.result:
        Update results for new varchar handling
      mysql-test/r/ps_4heap.result:
        Update results for new varchar handling
      mysql-test/r/ps_5merge.result:
        Update results for new varchar handling
      mysql-test/r/ps_6bdb.result:
        Update results for new varchar handling
      mysql-test/r/subselect.result:
        Update results for new varchar handling
      mysql-test/r/type_ranges.result:
        Update results for new varchar handling
      mysql-test/r/union.result:
        Update results for new varchar handling
      mysql-test/t/heap.test:
        Update results for new varchar handling
      mysql-test/t/type_ranges.test:
        Added extra test to test generated type for string functions
      sql/field.cc:
        Update results for new varchar handling
      sql/field.h:
        Update results for new varchar handling
        We have to use orig_table instead of table as 'table' may point to a new field in the created table
      sql/field_conv.cc:
        Update results for new varchar handling
      sql/ha_heap.cc:
        Indentation fixes
      sql/ha_innodb.cc:
        Update results for new varchar handling
      sql/item.cc:
        Update results for new varchar handling
        Remove compiler warnings
        String results in CREATE ... SELECT are now created as CHAR(0), VARCHAR(X) or TEXT() depending on item->max_length
      sql/item.h:
        Update results for new varchar handling
      sql/item_func.cc:
        Update results for new varchar handling
        String results in CREATE ... SELECT are now created as CHAR(0), VARCHAR(X) or TEXT() depending on item->max_length
      sql/item_func.h:
        ANALYZE now return VARCHAR columns
      sql/procedure.h:
        Update results for new varchar handling
      sql/sql_acl.cc:
        After merge fixes
      sql/sql_select.cc:
        Update results for new varchar handling
        String results in temporary tables are now created as CHAR(0), VARCHAR(X) or TEXT() depending on item->max_length
      sql/sql_show.cc:
        After merge fixes
      sql/sql_table.cc:
        After merge fixes
      strings/ctype-tis620.c:
        After merge fixes
      tests/client_test.c:
        Fixed results, as in MySQL 5.0 strings in CREATE ... SELECT are creates VARCHAR columns
      9ca50fe1
  23. 18 Nov, 2004 1 commit
  24. 18 Oct, 2004 1 commit
  25. 17 Sep, 2004 1 commit
  26. 06 Sep, 2004 1 commit
  27. 05 Sep, 2004 1 commit
    • unknown's avatar
      union.test: drop table added · e9a40452
      unknown authored
      BitKeeper/etc/ignore:
        Added support-files/my-innodb-heavy-4G.cnf to the ignore list
      mysql-test/r/union.result:
        drop table added
      mysql-test/t/union.test:
        drop table added
      e9a40452
  28. 04 Sep, 2004 1 commit
  29. 03 Sep, 2004 1 commit
  30. 20 Jul, 2004 1 commit
    • unknown's avatar
      mark subquery in the FROM clause like derived and quoate all identifiers (BUG#4609) · ec33aa2b
      unknown authored
      mysql-test/r/bench_count_distinct.result:
        Quoting of fields and tables names
      mysql-test/r/case.result:
        Quoting of fields and tables names
      mysql-test/r/fulltext.result:
        Quoting of fields and tables names
      mysql-test/r/func_default.result:
        Quoting of fields and tables names
      mysql-test/r/func_gconcat.result:
        Quoting of fields and tables names
      mysql-test/r/func_group.result:
        Quoting of fields and tables names
      mysql-test/r/func_if.result:
        Quoting of fields and tables names
      mysql-test/r/func_in.result:
        Quoting of fields and tables names
      mysql-test/r/func_regexp.result:
        Quoting of fields and tables names
      mysql-test/r/func_test.result:
        Quoting of fields and tables names
      mysql-test/r/gis.result:
        Quoting of fields and tables names
      mysql-test/r/group_by.result:
        Quoting of fields and tables names
      mysql-test/r/having.result:
        Quoting of fields and tables names
      mysql-test/r/insert_update.result:
        Quoting of fields and tables names
      mysql-test/r/join_nested.result:
        Quoting of fields and tables names
      mysql-test/r/olap.result:
        Quoting of fields and tables names
      mysql-test/r/query_cache.result:
        Quoting of fields and tables names
      mysql-test/r/select.result:
        Quoting of fields and tables names
      mysql-test/r/subselect.result:
        Quoting of fields and tables names
      mysql-test/r/union.result:
        Quoting of fields and tables names
      mysql-test/r/varbinary.result:
        Quoting of fields and tables names
      mysql-test/r/view.result:
        Quoting of fields and tables names
        test of view with quated fields
      mysql-test/t/view.test:
        test of view with quated fields
      sql/item.cc:
        Quoting of fields and tables names
      sql/item.h:
        Quoting of fields and tables names
      sql/sql_select.cc:
        Quoting of fields and tables names
      sql/sql_view.cc:
        mark subquery in the FROM clause like derived
      ec33aa2b
  31. 23 Jun, 2004 1 commit
    • unknown's avatar
      parameter of my_yyoverflow made independed from YYSIZE_T (BUG#4204) · a616e1de
      unknown authored
      mysql-test/r/union.result:
        test of correct parser stack overflow handling
      mysql-test/t/union.test:
        test of correct parser stack overflow handling
      sql/sql_parse.cc:
        parameter of my_yyoverflow made independed from YYSIZE_T
      sql/sql_yacc.yy:
        parameter of my_yyoverflow made independed from YYSIZE_T
      a616e1de
  32. 16 Jun, 2004 2 commits
  33. 15 Jun, 2004 1 commit
  34. 19 May, 2004 1 commit
    • unknown's avatar
      after review changes · 9fb55cef
      unknown authored
      mysql-test/r/derived.result:
        explain of hidden subselect changed according to review
      mysql-test/r/subselect.result:
        explain of hidden subselect changed according to review
      mysql-test/r/union.result:
        explain of hidden subselect changed according to review
      sql/sql_class.h:
        we bo not need sign for now
      sql/sql_lex.h:
        we do not need sign for now
      9fb55cef
  35. 13 May, 2004 1 commit
  36. 06 May, 2004 1 commit
    • unknown's avatar
      EXPLAIN UNION using same routing which used for execution which allow return... · 1a4f499c
      unknown authored
      EXPLAIN UNION using same routing which used for execution which allow return correct bug messages (Bug #3639)
      EXPLAIN of hidden SELECT of UNION
      
      
      mysql-test/r/derived.result:
        explain of hidden select
      mysql-test/r/subselect.result:
        explain of hidden select
      mysql-test/r/union.result:
        explain of hidden select
        correct error messages on explain
      mysql-test/t/subselect.test:
        show eliminated costants in WHERE clause
      mysql-test/t/union.test:
        correct error messages on EXPLAIN with union
      sql/item.cc:
        fixed name constructing for global ORDER BY items
      sql/sql_class.h:
        select ID can be negative (for hidden SELECTs)
        removed unused field
      sql/sql_lex.cc:
        new flag of UNION EXPLAIN
      sql/sql_lex.h:
        new flag of UNION EXPLAIN
        select ID can be negative (for hidden SELECTs)
      sql/sql_select.cc:
        EXPLAIN UNION using same routing which used for execution
        explain for hidden SELECT of UNION
      sql/sql_union.cc:
        EXPLAIN UNION using same routing which used for execution
      1a4f499c