An error occurred fetching the project authors.
  1. 11 Feb, 2004 1 commit
  2. 23 Jan, 2004 2 commits
    • unknown's avatar
      define name fixed · 7580623e
      unknown authored
      sql/lex.h:
        Wrong define name
      7580623e
    • unknown's avatar
      SCRUM · 214c178f
      unknown authored
      wl #1163 (Make spatial code optional)
      Patch I cleaned with Serg & Monty's suggestions
      
      
      sql/gen_lex_hash.cc:
        mysql_priv.h was included for SYM_GROUP declaration
      sql/lex.h:
        sym_group_xxx made global so we can use texts from them
        throughout the code
      sql/lex_symbol.h:
        SYM_GROUP declaration moved to mysql_priv.h
      sql/mysql_priv.h:
        declarations about SYM_GROUP
      sql/sql_table.cc:
        sym_group_xxx objects used instead of text constants
        a couple of HAVE_SPATIAL removed
      sql/sql_yacc.yy:
        sym_group_xxx used instead of text constants
        some duplicated code restructured
        MYF(0) parameters removed from net_printf calls
      214c178f
  3. 15 Jan, 2004 1 commit
    • unknown's avatar
      SCRUM: · 235f1a4d
      unknown authored
      WL#1163 (Making spatial code optional)
      Pack of changes to do in sql/ code.
      
      
      sql/field.cc:
        Spatial code #ifdef-ed
      sql/field.h:
        Spatial code #ifdef-ed
      sql/item_create.cc:
        Spatial code #ifdef-ed
      sql/item_create.h:
        Spatial code #ifdef-ed
      sql/item_geofunc.cc:
        Spatial code #ifdef-ed
      sql/item_geofunc.h:
        Spatial code #ifdef-ed
        GEOM_NEW implementation
      sql/lex.h:
        Code was significally modified to support optional group
        of functions
      sql/lex_symbol.h:
        SYM_GROUP structure presented
      sql/sql_table.cc:
        Spatial code #ifdef-ed
      sql/sql_yacc.yy:
        Several modifications to make spatial code optional
      sql/table.cc:
        Spatial code #ifdef-ed
      sql/unireg.cc:
        Spatial code #ifdef-ed
      235f1a4d
  4. 17 Dec, 2003 1 commit
    • unknown's avatar
      WorkLog #1323 (part 2) · 69cee792
      unknown authored
      New Statement: SHOW [STORAGE] ENGINES
      New System Variable: storage_engine
      New mysqld Argument: --default-storage-engine=
      
      
      include/mysqld_error.h:
        We now call handlers STORAGE ENGINEs
      include/sql_state.h:
        We now call handlers STORAGE ENGINEs
      mysql-test/r/create.result:
        table_type system variable becomes storage_engine
      mysql-test/r/key_cache.result:
        table_type system variable becomes storage_engine
      mysql-test/r/variables.result:
        table_type system variable becomes storage_engine
      mysql-test/r/warnings.result:
        Test for deprecated table_type system variable
      mysql-test/t/create.test:
        table_type system variable becomes storage_engine
      mysql-test/t/key_cache.test:
        table_type system variable becomes storage_engine
      mysql-test/t/variables.test:
        table_type system variable becomes storage_engine
      mysql-test/t/warnings.test:
        Test for deprecated table_type system variable
      sql/handler.cc:
        change name for consistency
      sql/handler.h:
        change name for consistency
      sql/lex.h:
        New keywords - ENGINES and STORAGE
      sql/mysql_priv.h:
        change name for consistency
      sql/mysqld.cc:
        New command like argument for default-storage-engine
      sql/set_var.cc:
        New system variable for storage_engine
      sql/set_var.h:
        New system variable for storage_engine
      sql/sql_lex.h:
        Change for consistancy
      sql/sql_parse.cc:
        Change for consistancy
      sql/sql_show.cc:
        Change for consistancy
      sql/sql_table.cc:
        Change for consistancy
      sql/sql_yacc.yy:
        New keywords: STORAGE and ENGINES
        Change table_types to storage_engines
        New statement: SHOW [STORAGE] ENGINES
      69cee792
  5. 16 Dec, 2003 2 commits
    • unknown's avatar
      Post-merge fixes. · bc748bef
      unknown authored
      Multiple result sets from stored procedures now works with the
      mysql and mysqltest clients.
      
      
      client/mysqltest.c:
        Post-merge fixes.
      mysql-test/r/index_merge_innodb.result:
        Post-merge fixes.
      mysql-test/r/sp-error.result:
        Post-merge fixes.
        Removed now obsolete error test for multiple selects (without "into").
      mysql-test/r/sp.result:
        Post-merge fixes.
        Added test for mulple result sets.
      mysql-test/r/variables.result:
        Post-merge fixes.
      mysql-test/t/index_merge_innodb.test:
        Post-merge fixes.
      mysql-test/t/sp-error.test:
        Post-merge fixes.
        Removed now obsolete error test for multiple selects (without "into").
      mysql-test/t/sp.test:
        Post-merge fixes.
        Added test for mulple result sets.
      sql/lex.h:
        Post-merge fixes.
      bc748bef
    • unknown's avatar
      Portability fixes (mostly test suite) · 3357bc7e
      unknown authored
      Make ENGINE= an alias for TYPE= (Compabiltiy with 4.1)
      Fix when using symlinked data files and realpath() is not working
      
      
      client/mysqltest.c:
        Copied mysqltest from 4.1 and modified this to compile in 4.0
        This was needed to get replace_columns to work.
      include/my_sys.h:
        Stop compiler warnings about alloca on freebsd
      myisam/mi_check.c:
        Fix when using symlinked data files and realpath() is not working
      mysql-test/r/handler.result:
        test engine=
      mysql-test/r/rpl_max_relay_size.result:
        Use replace_columns to replace some 'not constant' columns
      mysql-test/r/rpl_rotate_logs.result:
        Use replace_columns to replace some 'not constant' columns
      mysql-test/r/rpl_trunc_binlog.result:
        Use replace_columns to replace some 'not constant' columns
      mysql-test/t/handler.test:
        test engine=
      mysql-test/t/rpl_log_pos.test:
        Use replace_columns to replace some 'not constant' columns
      mysql-test/t/rpl_max_relay_size.test:
        Use replace_columns to replace some 'not constant' columns
      mysql-test/t/rpl_rotate_logs.test:
        Use replace_columns to replace some 'not constant' columns
      mysql-test/t/rpl_trunc_binlog.test:
        Use replace_columns to replace some 'not constant' columns
      mysys/my_symlink.c:
        More debugging
      sql/lex.h:
        Make ENGINE= an alias for TYPE=
      sql/mysqld.cc:
        Code cleanup
      strings/strto.c:
        Fix for True64
      strings/strtoll.c:
        Fix for True64
      strings/strtoull.c:
        Remove not needed include file
      3357bc7e
  6. 10 Dec, 2003 2 commits
    • unknown's avatar
      WL#1363: Update the mysql.proc table and add new fields. · 3702a1db
      unknown authored
      Also made the parsing and handling of SP characteristics
      more general and extendable, and added a few ch:istics.
      
      
      Docs/sp-imp-spec.txt:
        Updated spec with new schema.
      Docs/sp-implemented.txt:
        Added info about ALTER and SHOW.
      mysql-test/r/sp.result:
        Minor change in SHOW FUNCTION|PROCEDURE STATUS output.
      scripts/mysql_create_system_tables.sh:
        New mysql.proc schema.
      scripts/mysql_fix_privilege_tables.sql:
        New mysql.proc schema.
      sql/lex.h:
        New lex words for SP characteristics.
      sql/sp.cc:
        New mysql.proc schema.
        Also made the characteristics handling slightly more extendable.
      sql/sp.h:
        Made the characteristics handling slightly more extendable.
      sql/sp_head.cc:
        Made the characteristics handling slightly more extendable.
      sql/sp_head.h:
        Made the characteristics handling slightly more extendable.
      sql/sql_lex.h:
        Made the characteristics handling slightly more extendable.
      sql/sql_parse.cc:
        Made the characteristics handling slightly more extendable.
      sql/sql_yacc.yy:
        Made the characteristics handling slightly more extendable
        and made the parsing of characteristics more general, and
        added a few new dito. (LANGUAGE SQL, and [NOT] DETERMINISTIC
        for starters).
      3702a1db
    • unknown's avatar
      WorkLog#1323 · 80ec8079
      unknown authored
      Deprecate the use of TYPE=... Preferred syntax is ENGINE=
      
      
      include/mysqld_error.h:
        New warning for deprecated syntax
      sql/lex.h:
        Introduce ENGINE keyword
        Sort order of symbols
      sql/share/czech/errmsg.txt:
        New warning for deprecated syntax
      sql/share/danish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/dutch/errmsg.txt:
        New warning for deprecated syntax
      sql/share/english/errmsg.txt:
        New warning for deprecated syntax
      sql/share/estonian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/french/errmsg.txt:
        New warning for deprecated syntax
      sql/share/german/errmsg.txt:
        New warning for deprecated syntax
      sql/share/greek/errmsg.txt:
        New warning for deprecated syntax
      sql/share/hungarian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/italian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/japanese/errmsg.txt:
        New warning for deprecated syntax
      sql/share/korean/errmsg.txt:
        New warning for deprecated syntax
      sql/share/norwegian-ny/errmsg.txt:
        New warning for deprecated syntax
      sql/share/norwegian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/polish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/portuguese/errmsg.txt:
        New warning for deprecated syntax
      sql/share/romanian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/russian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/serbian/errmsg.txt:
        New warning for deprecated syntax
      sql/share/slovak/errmsg.txt:
        New warning for deprecated syntax
      sql/share/spanish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/swedish/errmsg.txt:
        New warning for deprecated syntax
      sql/share/ukrainian/errmsg.txt:
        New warning for deprecated syntax
      sql/sql_show.cc:
        Change TYPE= with ENGINE=
      sql/sql_yacc.yy:
        Introduce ENGINE keyword,
        Deprecate TYPE= syntax,
        Introduce SHOW ENGINE syntax,
        Deprecate SHOW INNODB/BDB syntax.
      mysql-test/r/alias.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/alter_table.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/auto_increment.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb-alter-table-1.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb-crash.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb-deadlock.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/bdb_cache.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/case.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/cast.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/constraints.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/create.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_collate.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_latin1_de.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_many.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_mb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_recoding.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/ctype_ucs.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/delete.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/distinct.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext2.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext_distinct.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/fulltext_left_join.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_compress.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_date_add.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_group.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_if.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_str.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_system.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_test.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/func_time.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/gis-rtree.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/group_by.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/handler.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap_auto_increment.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap_btree.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/heap_hash.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/help.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb-deadlock.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb_cache.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/innodb_handler.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/insert_select.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/isam.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/join.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/join_crash.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/join_outer.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/key.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/lock.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/lock_tables_lost_commit.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/merge.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/mix_innodb_myisam_binlog.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/multi_update.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/myisam.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/null.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/null_key.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/order_by.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/query_cache.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/range.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/repair_part1.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/replace.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rollback.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl000006.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl_flush_tables.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl_insert_id.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/rpl_relayrotate.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/select.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/select_found.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/show_check.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/sql_mode.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/status.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/subselect.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/subselect2.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/subselect_innodb.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/symlink.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/temp_table.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_blob.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_datetime.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_enum.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_nchar.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/type_set.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/union.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/update.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/r/warnings.result:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/alias.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/alter_table.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/auto_increment.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb-alter-table-1.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb-crash.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb-deadlock.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/bdb_cache.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/create.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/ctype_ucs.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/delete.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/distinct.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext2.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext_distinct.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/fulltext_left_join.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_compress.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_date_add.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_group.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_if.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_str.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_test.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/func_time.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/gis-rtree.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/group_by.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/handler.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap_auto_increment.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap_btree.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/heap_hash.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/help.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb-deadlock.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb_cache.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/innodb_handler.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/insert_select.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/isam.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/join.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/join_crash.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/join_outer.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/key.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/lock.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/lock_tables_lost_commit.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/merge.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/mix_innodb_myisam_binlog.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/multi_update.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/myisam.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/null.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/null_key.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/order_by.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/outfile.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/query_cache.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/query_cache_merge.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/range.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/repair_part1.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/replace.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rollback.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl000006.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl_flush_tables.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl_insert_id.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/rpl_relayrotate.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/select.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/select_found.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/show_check.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/sql_mode.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/status.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/subselect.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/subselect2.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/subselect_innodb.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/symlink.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/temp_table.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/type_datetime.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/type_set.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/union.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/update.test:
        Change occurances of TYPE= to ENGINE=
      mysql-test/t/warnings.test:
        Change occurances of TYPE= to ENGINE=
        New test for deprecated syntax
      80ec8079
  7. 08 Dec, 2003 1 commit
    • unknown's avatar
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions · 417354ea
      unknown authored
      Syntax for TIMESTAMPADD:
      
      TIMESTAMPADD(interval, integer_expression, datetime_expression)
      
      interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | 
      QUARTER | YEAR
      
      Supported SQL_TSI_  prefix  (like SQL_TSI_SECOND)
      
      Syntax for TIMESTAMPDIFF:
      
      TIMESTAMPDIFF(interval, datetime_expression1, datetime_expression2)
      
      interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | 
      QUARTER | YEAR
      
      Supported SQL_TSI_  prefix  (like SQL_TSI_SECOND)
      
      
      mysql-test/r/func_sapdb.result:
        Additional tests for timediff
      mysql-test/r/func_time.result:
        Tests for timestampadd, timestampdiff functions
      mysql-test/r/keywords.result:
        Test for new keywords
      mysql-test/t/func_sapdb.test:
        Additional tests for timediff
      mysql-test/t/func_time.test:
        Tests for timestampadd, timestampdiff functions
      mysql-test/t/keywords.test:
        Test for new keywords
      sql/item_create.cc:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/item_create.h:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/item_timefunc.cc:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/item_timefunc.h:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/lex.h:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/sql_yacc.yy:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      417354ea
  8. 02 Dec, 2003 1 commit
    • unknown's avatar
      WorkLog#1280 - Remove fixed table handler from lex/yacc · c74c90ee
      unknown authored
      include/mysqld_error.h:
        New error message: unknown table engine
      mysql-test/r/create.result:
        New error message: unknown table engine
      mysql-test/t/create.test:
        New error message: unknown table engine
      sql/lex.h:
        Remove some keywords: HEAP, ISAM, MERGE, MEMORY, MRG_MYISAM, MYISAM
      sql/mysql_priv.h:
        Remove unused symbol
      sql/set_var.h:
        New system variable type: sys_var_thd_table_type
      sql/sql_yacc.yy:
        Remove tokens and make table_types resolve at run time
      sql/sql_show.cc:
        Tidy up
      sql/sql_table.cc:
        Tidy up
      include/sql_state.h:
        Fix indent
      sql/mysqld.cc:
        optimize
      mysql-test/r/rpl_change_master.result:
        It wouldn't pass the tests
      mysql-test/r/variables.result:
        Fix for changes
      mysql-test/r/warnings.result:
        Fix for changes
      mysql-test/t/variables.test:
        Fix for changes
      sql/handler.h:
        parameter is a const
      sql/set_var.cc:
        Code clean up for sys_var_thd_table_type::check()
      sql/handler.cc:
        More tidyup
      sql/share/czech/errmsg.txt:
        Fixups during review
      sql/share/danish/errmsg.txt:
        Fixups during review
      sql/share/dutch/errmsg.txt:
        Fixups during review
      sql/share/english/errmsg.txt:
        Fixups during review
      sql/share/estonian/errmsg.txt:
        Fixups during review
      sql/share/french/errmsg.txt:
        Fixups during review
      sql/share/german/errmsg.txt:
        Fixups during review
      sql/share/greek/errmsg.txt:
        Fixups during review
      sql/share/hungarian/errmsg.txt:
        Fixups during review
      sql/share/italian/errmsg.txt:
        Fixups during review
      sql/share/japanese/errmsg.txt:
        Fixups during review
      sql/share/korean/errmsg.txt:
        Fixups during review
      sql/share/norwegian-ny/errmsg.txt:
        Fixups during review
      sql/share/norwegian/errmsg.txt:
        Fixups during review
      sql/share/polish/errmsg.txt:
        Fixups during review
      sql/share/portuguese/errmsg.txt:
        Fixups during review
      sql/share/romanian/errmsg.txt:
        Fixups during review
      sql/share/russian/errmsg.txt:
        Fixups during review
      sql/share/serbian/errmsg.txt:
        Fixups during review
      sql/share/slovak/errmsg.txt:
        Fixups during review
      sql/share/spanish/errmsg.txt:
        Fixups during review
      sql/share/swedish/errmsg.txt:
        Fixups during review
      sql/share/ukrainian/errmsg.txt:
        Fixups during review
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      c74c90ee
  9. 19 Nov, 2003 1 commit
    • unknown's avatar
      Fixed BUG#1862 (flush table in SPs didn't work). · bd226350
      unknown authored
      Fixed various bugs: setting local variables to NULL, SELECT INTO var now actually
      might work, SELECT INTO with not row now gives a "no data" warning (instead of
      the "empty query" error), etc.
      Updated test cases accordingly.
      
      
      mysql-test/r/sp-error.result:
        Corrected security syntax for alter/create procedure.
      mysql-test/r/sp.result:
        Corrected security syntax for alter/create procedure.
        New tests for setting local variables to null,
        bug fixes for SELECT INTO var, FLUSH TABLES calls (BUG#1862),
        and corrected "no data" warning for SELECT INTO with no rows.
      mysql-test/t/sp-error.test:
        Corrected security syntax for alter/create procedure.
      mysql-test/t/sp.test:
        Corrected security syntax for alter/create procedure.
        New tests for setting local variables to null,
        bug fixes for SELECT INTO var, FLUSH TABLES calls (BUG#1862),
        and corrected "no data" warning for SELECT INTO with no rows.
      sql/lex.h:
        Added SQL_SYM (and added a few _SYM suffixes for new symbols).
      sql/sp_head.cc:
        Fixed bug in the item_list copying for "with_wild" cases (list nodes ended
        up in the wrong memroot).
        Catch errors and warnings even if return values is 0 from sub-statements.
        Restore table_list which is zapped by SQLCOM_CREATE_TABLE and INSERT_SELECT.
        Set old table pointers to NULL after sub-statement call (since all tables are
        closed).
      sql/sql_class.cc:
        Corrected error message when no rows return by a SELECT INTO var; should
        be a "no data" warning.
      sql/sql_lex.h:
        Have to store the original table_list first pointer for some
        sub-statements in SPs.
      sql/sql_yacc.yy:
        Corrected SECURITY INVOKER/DEFINER syntax ("SQL" missing), added some _SYM
        suffixes, and fixed valgrind complaints for SP COMMENTs.
        (Also removed some now irrelevant comments.)
      bd226350
  10. 17 Nov, 2003 2 commits
    • unknown's avatar
      WL#1241: SHOW PROCEDURE/FUNCTION · 6c1a2b7f
      unknown authored
      WL#1263: Support for the attributes COMMENT and SUID
               in CREATE/ALTER PROCEDURE/FUNCTION
      
      
      include/mysqld_error.h:
        Error code for 'alter procedure'
      mysql-test/r/sp-error.result:
        Test for WL#1241&WL#1263
      mysql-test/r/sp.result:
        Test for WL#1241&WL#1263
      mysql-test/t/sp-error.test:
        Test for WL#1241&WL#1263
      mysql-test/t/sp.test:
        Test for WL#1241&WL#1263
      sql/share/czech/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/danish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/dutch/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/english/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/estonian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/french/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/german/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/greek/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/hungarian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/italian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/japanese/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/korean/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/norwegian-ny/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/norwegian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/polish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/portuguese/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/romanian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/russian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/serbian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/slovak/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/spanish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/swedish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/ukrainian/errmsg.txt:
        Error massage for 'alter procedure'
      6c1a2b7f
    • unknown's avatar
      WL#1253: LAST_DAY · ac584b24
      unknown authored
      mysql-test/r/func_time.result:
        Test for WL#1253: LAST_DAY
      mysql-test/t/func_time.test:
        Test for WL#1253: LAST_DAY
      ac584b24
  11. 13 Nov, 2003 1 commit
    • unknown's avatar
      Various bug fixes: · c9232c60
      unknown authored
        - Duplicate parameters/variables, conditions and cursors (not allowed).
        - ITERATE in labelled BEGIN-END (not allowed).
        - Missing SQLSTATE [VALUE] keywords in CONDITION/HANDLER declaration (added).
        - Empty BEGIN-END (now allowed).
        - End label (now optional).
      
      
      include/mysqld_error.h:
        New error code for duplicate things (vars et al) in SPs.
      mysql-test/r/sp-error.result:
        New error tests for ITERATE in begin-end block and duplicate variables,
        conditions and cursors.
      mysql-test/r/sp.result:
        New tests for empty begin-end blocks, overriding local variables outside scope
        only, leave a begin-end block, and SQLSTATE [VALUE] words for CONDITION/HANDLER
        declarations.
      mysql-test/t/sp-error.test:
        New error tests for ITERATE in begin-end block and duplicate variables,
        conditions and cursors.
      mysql-test/t/sp.test:
        New tests for empty begin-end blocks, overriding local variables outside scope
        only, leave a begin-end block, and SQLSTATE [VALUE] words for CONDITION/HANDLER
        declarations.
      sql/lex.h:
        New SQLSTATE keyword.
      sql/share/czech/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/danish/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/dutch/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/english/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/estonian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/french/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/german/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/greek/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/hungarian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/italian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/japanese/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/korean/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/norwegian-ny/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/norwegian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/polish/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/portuguese/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/romanian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/russian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/serbian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/slovak/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/spanish/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/swedish/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/share/ukrainian/errmsg.txt:
        New error message for duplicate things (vars et al) in SPs.
      sql/sp_pcontext.cc:
        Keep track on scope limits for error checking of duplicate variables,
        conditions and cursors.
      sql/sp_pcontext.h:
        Keep track on scope limits for error checking of duplicate variables,
        conditions and cursors.
        Also need to flag BEGIN labels to check for illegal ITERATEs.
      sql/sql_yacc.yy:
        End-labels in SPs loop and begin-end blocks are now optional.
        SQLSTATE [VALUE] added to syntax for sqlstates.
        Check for duplicate variable, condition and cursor declarations, but
        only in the same scope.
        Empty BEGIN-END statements now allowed.
        Check if ITERATE is referring to a BEGIN label.
      c9232c60
  12. 28 Oct, 2003 1 commit
    • unknown's avatar
      Worklog #1280, (Stage 1 Implementation) · 6ec82734
      unknown authored
      This is a starting work to remove handler name dependencies 
      from the Lex/Parser.
      
      
      sql/handler.h:
        WorkLog #1280, Stage 1
      sql/lex.h:
        WorkLog #1280, Stage 1
      sql/sql_yacc.yy:
        WorkLog #1280, Stage 1
      sql/handler.cc:
        Use latin1 for string comparison
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      6ec82734
  13. 22 Oct, 2003 1 commit
  14. 20 Oct, 2003 1 commit
  15. 15 Oct, 2003 1 commit
    • unknown's avatar
      Add in bit_xor function (approved by Sergei) · acb47c93
      unknown authored
      sql/item_sum.cc:
        Add in bit_xor class functions.
      sql/item_sum.h:
        Add bit_xor class.
      sql/lex.h:
        Add in bit_xor symbol.
      sql/sql_yacc.yy:
        Add in bit_xor function
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      acb47c93
  16. 13 Oct, 2003 1 commit
    • unknown's avatar
      Many files: · d212ba60
      unknown authored
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      
      
      sql/ha_innodb.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_class.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_parse.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_table.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/ha_innodb.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/handler.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/lex.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/mysql_priv.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_class.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_lex.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_yacc.yy:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/ha/ha0ha.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/ha/hash0hash.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0buf.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0flu.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0lru.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0rea.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/btr/btr0btr.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/btr/btr0sea.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/fil/fil0fil.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/buf0buf.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ha0ha.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/hash0hash.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/row0mysql.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/buf0buf.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ha0ha.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ibuf0ibuf.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/page/page0page.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0mysql.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0purge.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0uins.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0umod.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      d212ba60
  17. 24 Sep, 2003 1 commit
  18. 16 Sep, 2003 1 commit
    • unknown's avatar
      Implemented SP CONDITIONs and HANDLERs, with the extension of handling · 4deedf62
      unknown authored
      MySQL error codes as well.
      (No UNDO HANDLERs yet, and no SIGNAL or RESIGNAL.)
      WL#850
      
      
      Docs/sp-imp-spec.txt:
        Spec of CONDITIONs and HANDLERs (and updated some old stuff too).
      Docs/sp-implemented.txt:
        Updated info about caching, CONDITIONs and HANDLERs.
      include/mysqld_error.h:
        New error for undeclared CONDITION.
      libmysqld/Makefile.am:
        New file: sp_rcontext.cc.
      mysql-test/r/sp-error.result:
        New tests for CONDITIONs and HANDLERs.
      mysql-test/r/sp.result:
        New tests for CONDITIONs and HANDLERs.
      mysql-test/t/sp-error.test:
        New tests for CONDITIONs and HANDLERs.
      mysql-test/t/sp.test:
        New tests for CONDITIONs and HANDLERs.
      sql/Makefile.am:
        New file: sp_rcontext.cc.
      sql/lex.h:
        New symbols for CONDITIONs, HANDLERs and CURSORs.
      sql/mysqld.cc:
        Catch error if we have a handler for it.
      sql/protocol.cc:
        Catch error if we have a handler for it.
      sql/share/czech/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/danish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/dutch/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/english/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/estonian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/french/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/german/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/greek/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/hungarian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/italian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/japanese/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/korean/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/norwegian-ny/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/norwegian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/polish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/portuguese/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/romanian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/russian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/serbian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/slovak/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/spanish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/swedish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/ukrainian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/sp_head.cc:
        New HANDLER code.
      sql/sp_head.h:
        New HANDLER code.
      sql/sp_pcontext.cc:
        New CONDITION and HANDLER code.
      sql/sp_pcontext.h:
        New CONDITION and HANDLER code.
      sql/sp_rcontext.h:
        New CONDITION and HANDLER code.
      sql/sql_yacc.yy:
        New CONDITION and HANDLER code.
      4deedf62
  19. 15 Sep, 2003 1 commit
    • unknown's avatar
      New syntax: · bf6480ba
      unknown authored
      CREATE TABLE t1(a NVARCHAR(10))
      This is for compatibility with MSSQL, DB2, Informix and some other DBMSs.
      
      Note, standard SQL doesn't have "NVARCHAR" syntax.
      There are only these syntaxes in SQL2003:
       NATIONAL VARCHAR
       NCHAR VARCHAR
       NATIONAL CHARACTER VARYING 
       NCHAR VARYING
      
      - Tests were added for all the above syntaxes.
      
      
      sql/lex.h:
        New syntax:
        
        CREATE TABLE t1(a NVARCHAR(10))
        This is for compatibility with MSSQL, DB2, Informix and some other DBMSs.
        
        Note, standard SQL doesn't have "NVARCHAR" syntax.
        There are only these syntaxes in SQL2003:
         NATIONAL VARCHAR
         NCHAR VARCHAR
         NATIONAL CHARACTER VARYING 
         NCHAR VARYING
      sql/sql_yacc.yy:
        New syntax:
        
        CREATE TABLE t1(a NVARCHAR(10))
        This is for compatibility with MSSQL, DB2, Informix and some other DBMSs.
        
        Note, standard SQL doesn't have "NVARCHAR" syntax.
        There are only these syntaxes in SQL2003:
         NATIONAL VARCHAR
         NCHAR VARCHAR
         NATIONAL CHARACTER VARYING 
         NCHAR VARYING
      bf6480ba
  20. 13 Sep, 2003 1 commit
    • unknown's avatar
      Implemented support for START SLAVE UNTIL (WL#868) · 2f8f0a7e
      unknown authored
      include/mysqld_error.h:
        Added error codes for warnings and error messages for START SLAVE UNTIL
      mysql-test/r/rpl000015.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      mysql-test/r/rpl_empty_master_crash.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      mysql-test/r/rpl_flush_log_loop.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      mysql-test/r/rpl_log.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      mysql-test/r/rpl_log_pos.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      mysql-test/r/rpl_redirect.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      mysql-test/r/rpl_replicate_do.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      mysql-test/r/rpl_rotate_logs.result:
        Fixed test because 3 new columns to SHOW SLAVE STATUS output were added
      sql/lex.h:
        Added UNTIL symbol
      sql/log.cc:
        Invalidating until_log_name comparison result if group_relay_log_name is changed
      sql/log_event.cc:
        Invalidating until_log_name comparison result if group_master_log_name is changed
      sql/repl_failsafe.cc:
        Cancel until condition if LOAD MASTER DATA is executed
      sql/share/czech/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/danish/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/dutch/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/english/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/estonian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/french/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/german/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/greek/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/hungarian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/italian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/japanese/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/korean/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/norwegian-ny/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/norwegian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/polish/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/portuguese/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/romanian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/russian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/serbian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/slovak/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/spanish/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/swedish/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/share/ukrainian/errmsg.txt:
        Added error and warning message for START SLAVE UNTIL
      sql/slave.cc:
        Fixed wrong locking order in init_relay_log_pos()
        Added until condition fields to SHOW SLAVE STATUS
        Added checking if UNTIL condition is reached 
        (added proper method, added its invocation, reorganized locking 
        in exec_relay_log_event() and next_event())
      sql/slave.h:
        Members in RELAY_LOG_INFO for storing UNTIL condition. Also 
        methods for for invalidation of cached UNTIL condition comparison
        results
      sql/sql_repl.cc:
        Now honoring UNTIL clause then starting slave thread. Proper 
        errors and warnings.
      sql/sql_yacc.yy:
        Added support for UNTIL clause in START SLAVE. This involved 
        extraction of some of master_defs to separate master_file_def
        non-terminal.
      2f8f0a7e
  21. 01 Sep, 2003 1 commit
    • unknown's avatar
      Implemented replication over SSL · 8a548ffd
      unknown authored
       Added proper options to CHANGE MASTER TO, new fields to SHOW SLAVE STATUS,
       Honoring this parameters during connection to master.
       Introduced new format of master.info file
      
      
      include/mysqld_error.h:
        Added error code for "slave without SSL ignored SSL params warning"
      mysql-test/Makefile.am:
        Copy files required for rpl_openssl test during the make process
      mysql-test/r/rpl000015.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      mysql-test/r/rpl_empty_master_crash.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      mysql-test/r/rpl_flush_log_loop.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      mysql-test/r/rpl_log.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      mysql-test/r/rpl_log_pos.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      mysql-test/r/rpl_redirect.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      mysql-test/r/rpl_replicate_do.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      mysql-test/r/rpl_rotate_logs.result:
        Added fields to SHOW SLAVE STATUS for replication over SSL
      sql/lex.h:
        Added MASTER_SSL lexems for CHANGE MASTER
      sql/mysqld.cc:
        Added --master-ssl-ca parameter. Fixed description of other master-ssl parameters
      sql/repl_failsafe.cc:
        Added SSL support to connect_to_master()
      sql/share/czech/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/danish/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/dutch/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/english/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/estonian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/french/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/german/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/greek/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/hungarian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/italian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/japanese/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/korean/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/norwegian-ny/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/norwegian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/polish/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/portuguese/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/romanian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/russian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/serbian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/slovak/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/spanish/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/swedish/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/share/ukrainian/errmsg.txt:
        Added "slave without SSL ignored SSL params" warning
      sql/slave.cc:
        Introduced new format of master.info file
        Added support of SSL params in master.info and SHOW SLAVE STATUS
        Added support of SSL connections
      sql/slave.h:
        Added SSL parameters to MASTER_INFO
      sql/sql_lex.h:
        Added SSL parameters for CHANGE MASTER TO
      sql/sql_repl.cc:
        Added SSL parameters for CHANGE MASTER TO
      sql/sql_yacc.yy:
        Added SSL parameters for CHANGE MASTER TO
      8a548ffd
  22. 21 Aug, 2003 1 commit
  23. 11 Aug, 2003 1 commit
    • unknown's avatar
      Implemented UTC_TIME, UTC_DATE and UTC_TIMESTAMP functions (WL#345) · 2ad06dc6
      unknown authored
      configure.in:
        ./configure now tests if gmtime_r is present
      include/config-os2.h:
        Supposing that OS/2 have gmtime_r
      include/my_pthread.h:
        Use our imeplementation of gmtime_r if system lacks one
      mysql-test/r/func_time.result:
        Added UTC_* functions to test
      mysql-test/t/func_time.test:
        Added UTC_* functions to test
      mysys/my_pthread.c:
        Our implementation of gmtime_r
      mysys/my_thr_init.c:
        Now we also need LOCK_locktime_r if gmtime_r is absent
      sql/item_timefunc.cc:
        Generalized classes for CURDATE, CURTIME and NOW, abstracted them from
        timezone. Added new children classes for implementing these and UTC_*
        functions.
      sql/item_timefunc.h:
        Generalized classes for CURDATE, CURTIME and NOW, abstracted them from
        timezone. Added new children classes for implementing these and UTC_*
        functions.
      sql/lex.h:
        Added tokens for UTC_TIME, UTC_DATE and UTC_TIMESTAMP
      sql/sql_yacc.yy:
        Added UTC_* functions to grammar. Current functions are using 
        classes now.
      2ad06dc6
  24. 12 Jul, 2003 1 commit
  25. 04 Jul, 2003 1 commit
    • unknown's avatar
      Bug fixes for authentication · ccbcf1c9
      unknown authored
      OLD_PASSWORD made a keyword to allow set password=old_password('abc') constructions.
      
      
      BitKeeper/etc/ignore:
        Added BitKeeper/post-commit BitKeeper/post-commit-manual build_tags.sh tests/connect_test BUILD/compile-pentium-maintainer to the ignore list
      include/mysql_com.h:
        scramble return type changed to void as now it's not used
      libmysql/libmysql.c:
        fixed bug with with failed authentification when scramble contained zero byte
      sql-common/client.c:
        applied patch from Lycos team
        fixed bug with scramble containing zero byte
      sql/item_create.cc:
        removed create_func_old_password, create_func_password as they are not used any more
      sql/item_create.h:
        removed create_func_old_password, create_func_password as they are not used any more
      sql/item_strfunc.cc:
        Added alloc() function to Item_func_password, Item_func_old_password, which is used in sql_yacc.yy
      sql/item_strfunc.h:
        Added alloc() function to Item_func_password, Item_func_old_password, which is used in sql_yacc.yy
      sql/lex.h:
        OLD_PASSWORD now is keyword, to allow statements like
        set password=old_password('abc')
      sql/password.c:
        fixed scramble return value
        trailing zero now is not written
      sql/sql_acl.cc:
        incorporated patch from Lycos team
        41 replaced with constant
        acl_getroot rewritten to support ER_AUTH_... error
      sql/sql_parse.cc:
        authenticate merged with check_user
        check_user return values reversed, support for ER_AUTH in check_user.added
      sql/sql_yacc.yy:
        OLD_PASSWORD now is keyword, to allow statements like
        set password=old_password('abc')
      ccbcf1c9
  26. 23 Jun, 2003 1 commit
  27. 20 Jun, 2003 1 commit
    • unknown's avatar
      Added AsWKT() alias for AsText(). · 2295fcc8
      unknown authored
      Renamed as_text().
      
      
      sql/item_create.cc:
        Renamed as_text().
      sql/item_create.h:
        Renamed as_text().
      sql/lex.h:
        Added AsWKT() alias for AsText().
      2295fcc8
  28. 19 Jun, 2003 1 commit
    • unknown's avatar
      preload.result, preload.test: · 32ddd427
      unknown authored
        Removed non-generic info (key used blocks)
      preload.result, preload.test, lex.h, sql_yacc.yy:
        Syntax change for preload statement
      
      
      sql/sql_yacc.yy:
        Syntax change for preload statement
      sql/lex.h:
        Syntax change for preload statement
      mysql-test/t/preload.test:
        Removed non-generic info (key used blocks)
      mysql-test/r/preload.result:
        Removed non-generic info (key used blocks)
      32ddd427
  29. 12 Jun, 2003 1 commit
    • unknown's avatar
      Many files: · f7aed024
      unknown authored
        New feature: preload indexes into key cache.
      mi_preload.c:
        new file
      Many files:
        Added preload statement.
      
      
      sql/ha_myisam.h:
        Added preload statement.
      sql/handler.cc:
        Added preload statement.
      sql/lex.h:
        Added preload statement.
      sql/mysql_priv.h:
        Added preload statement.
      sql/sql_lex.h:
        Added preload statement.
      sql/sql_base.cc:
        Added preload statement.
      sql/sql_table.cc:
        New feature: preload indexes into key cache.
      sql/sql_parse.cc:
        New feature: preload indexes into key cache.
      sql/mysqld.cc:
        New feature: preload indexes into key cache.
      sql/set_var.cc:
        New feature: preload indexes into key cache.
      sql/sql_yacc.yy:
        New feature: preload indexes into key cache.
      sql/ha_myisam.cc:
        New feature: preload indexes into key cache.
      sql/table.h:
        New feature: preload indexes into key cache.
      mysys/mf_keycache.c:
        New feature: preload indexes into key cache.
      myisam/myisamdef.h:
        New feature: preload indexes into key cache.
      myisam/mi_extra.c:
        New feature: preload indexes into key cache.
      myisam/Makefile.am:
        New feature: preload indexes into key cache.
      include/my_base.h:
        New feature: preload indexes into key cache.
      include/my_sys.h:
        New feature: preload indexes into key cache.
      include/myisam.h:
        New feature: preload indexes into key cache.
      f7aed024
  30. 06 Jun, 2003 2 commits
    • unknown's avatar
      REVOKE all privileges and delete user(244) · d1a1d24c
      unknown authored
      include/mysqld_error.h:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      mysql-test/r/grant.result:
        Test for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      mysql-test/t/grant.test:
        Test for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/czech/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/danish/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/dutch/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/english/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/estonian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/french/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/german/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/greek/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/hungarian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/italian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/japanese/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/korean/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/norwegian-ny/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/norwegian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/polish/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/portuguese/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/romanian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/russian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/serbian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/slovak/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/spanish/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/swedish/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      sql/share/ukrainian/errmsg.txt:
        Error messages for DROP USER, REVOKE ALL PRIVILEGES, GRANT
      d1a1d24c
    • unknown's avatar
      sql_yacc.yy, sql_parse.cc, sql_lex.h, mysqld.cc, lex.h: · 1e7dfec5
      unknown authored
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      
      
      sql/lex.h:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/mysqld.cc:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/sql_lex.h:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/sql_parse.cc:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/sql_yacc.yy:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      1e7dfec5
  31. 21 May, 2003 1 commit
  32. 15 May, 2003 1 commit
    • unknown's avatar
      Scrum task 845. Thi is a behaviour change : · ec72bda5
      unknown authored
      now by default, FLUSH, OPTIMIZE, ANALYZE, REPAIR commands are written to the
      binlog, unless the new NO_WRITE_TO_BINLOG keyword was used :
      OPTIMIZE NO_WRITE_TO_BINLOG table t;
      
      Previously these commands were never written to the binlog, but there are
      2 reasons to change this :
      - the RENAME TABLE in MERGE table bug (#175) on slave
      - the possible "differently optimised queries may lead to different
      updates on the master and slave" bug, until we have automatic ORDER BY.
      
      FLUSH LOGS/SLAVE/MASTER/TABLES WITH READ LOCK are never written to the binlog.
      New test for the new logging behaviour.
      Other small change : reload_acl_and_cache() and reset_slave() don't send their errors themselves,
      this is more usual.
      
      
      mysql-test/mysql-test-run.sh:
        rpl_flush_tables.test generates 'table xx is open on rename'.
        This is normal and done on purpose, so don't report it.
      sql/lex.h:
        New keyword NO_WRITE_TO_BINLOG
      sql/mysql_priv.h:
        reload_acl_and_cache() now decides if we want to write the FLUSH command
        to the binlog or not (FLUSH MASTER, FLUSH SLAVE, FLUSH TABLES
        WITH READ LOCK, FLUSH LOGS cannot go into the binlog).
      sql/mysqld.cc:
        updated for new prototype of reload_acl_and_cache().
      sql/sql_lex.h:
        New boolean no_write_to_binlog in the lex structure.
      sql/sql_parse.cc:
        reload_acl_and_cache() now does not send its errors itself;
        it saves the error and the caller sends it.
        FLUSH, OPTIMIZE, ANALYZE, REPAIR commands don't write to the binlog
        if the NO_WRITE_TO_BINLOG keyword was used.
      sql/sql_repl.cc:
        reset_slave() does not send its errors himself.
      sql/sql_yacc.yy:
        New optional keyword NO_WRITE_TO_BINLOG for OPTIMIZE/ANALYZE/REPAIR/FLUSH :
        OPTIMIZE NO_WRITE_TO_BINLOG TABLE t;
        ANALYZE NO_WRITE_TO_BINLOG TABLE t;
        REPAIR NO_WRITE_TO_BINLOG TABLE t;
        FLUSH NO_WRITE_TO_BINLOG TABLE t;
      ec72bda5
  33. 22 Apr, 2003 1 commit
  34. 16 Apr, 2003 1 commit
    • unknown's avatar
      Add mysys specific error messages · e5c62e32
      unknown authored
      Make RELAY_THREAD and alias for IO_THREAD
      Added new interface for string -> (unsigned) long long.
      
      
      include/my_sys.h:
        Add mysys specific error messages
      sql/lex.h:
        Make RELAY_THREAD an alias for IO_THREAD
      sql/sql_yacc.yy:
        Make RELAY_THREAD an alias for IO_THREAD
      e5c62e32
  35. 10 Apr, 2003 1 commit
    • unknown's avatar
      added compress/uncompress function · 75bdeb1b
      unknown authored
      sql/mysql_priv.h:
        added have_compress variable
      sql/mysqld.cc:
        added have_compress variable
      sql/set_var.cc:
        added have_compress variable
      75bdeb1b