An error occurred fetching the project authors.
  1. 17 Jan, 2006 1 commit
    • unknown's avatar
      WL #2604: Partition Management · 19bbb7cc
      unknown authored
      Optimised version of ADD/DROP/REORGANIZE partitions for
      non-NDB storage engines.
      New syntax to handle REBUILD/OPTIMIZE/ANALYZE/CHECK/REPAIR partitions
      Quite a few bug fixes
      
      
      include/thr_lock.h:
        New method to downgrade locks from TL_WRITE_ONLY
        Possibility to upgrade lock while aborting locks
      mysql-test/r/ndb_autodiscover.result:
        Fix for lowercase and that all NDB tables are now partitioned
      mysql-test/r/ndb_bitfield.result:
        Fix for lowercase and that all NDB tables are now partitioned
      mysql-test/r/ndb_gis.result:
        Fix for lowercase and that all NDB tables are now partitioned
      mysql-test/r/ndb_partition_key.result:
        New test case
      mysql-test/r/partition.result:
        New test case
      mysql-test/r/partition_error.result:
        New test case
      mysql-test/r/partition_mgm_err.result:
        Fix of test case results
      mysql-test/t/disabled.def:
        partition_03ndb still has bug
      mysql-test/t/ndb_partition_key.test:
        New test cases for new functionality and bugs
      mysql-test/t/partition.test:
        New test cases for new functionality and bugs
      mysql-test/t/partition_error.test:
        New test cases for new functionality and bugs
      mysql-test/t/partition_mgm_err.test:
        New test cases for new functionality and bugs
      mysys/thr_lock.c:
        New method to downgrade TL_WRITE_ONLY locks
        Possibility to specify if locks are to be upgraded at abort locks
      sql/ha_archive.cc:
        New handlerton methods
      sql/ha_berkeley.cc:
        New handlerton methods
      sql/ha_blackhole.cc:
        New handlerton methods
      sql/ha_federated.cc:
        New handlerton methods
      sql/ha_heap.cc:
        New handlerton methods
      sql/ha_innodb.cc:
        New handlerton methods
      sql/ha_myisam.cc:
        New handlerton methods
      sql/ha_myisammrg.cc:
        New handlerton methods
      sql/ha_ndbcluster.cc:
        New handlerton methods
        Moved out packfrm and unpackfrm methods
        Adapted many parts to use table_share instead of table->s
        Ensured that .ndb file uses filename and not tablename
        according to new encoding of names (WL 1324)
        All NDB tables are partitioned and set up partition info
        Fixed such that tablenames use tablenames and not filenames in NDB
        NDB uses auto partitioning for ENGINE=NDB tables
        Warning for very large tables
        Set RANGE data
        Set LIST data
        New method to set-up partition info
        Set Default number of partitions flag
        Set linear hash flag
        Set node group array
        Set number of fragments
        Set max rows
        Set tablespace names
        New method to get number of partitions of table to use at open table
      sql/ha_ndbcluster.h:
        Removed partition_flags and alter_table_flags from handler class
        A couple of new and changed method headers
      sql/ha_ndbcluster_binlog.cc:
        Use new method headers
      sql/ha_partition.cc:
        New handlerton methods
        Lots of new function headers
        Use #P# as separator between table name and partition name and
        #SP# as separator between partition name and subpartition name
        Use filename encoding for files both of table name part and of
        partition name parts
        New method to drop partitions based on partition state
        New method to rename partitions based on partition state
        New methods to optimize, analyze, check and repair partitions
        New methods to optimize, analyze, check and repair table
        Helper method to create new partition, open it and external lock
        it, not needed to lock it internally since no one else knows about
        it yet.
        Cleanup method at error for new partitions
        New methods to perform bulk of work at ADD/REORGANIZE partitions
        (change_partitions, copy_partitions)
      sql/ha_partition.h:
        New methods and variables
        A few dropped ones and a few changed ones
      sql/handler.cc:
        Handlerton interface changes
        New flag to open_table_from_share
      sql/handler.h:
        New alter_table_flags
        New partition flags
        New partition states
        More states for default handling
        Lots of new, dropped and changed interfaces
      sql/lex.h:
        Added REBUILD and changed name of REORGANISE to REORGANIZE
      sql/lock.cc:
        Method to downgrade locks
        Able to specify if locks upgraded on abort locks
      sql/log.cc:
        New handlerton methods
      sql/mysql_priv.h:
        Lots of new interfaces
      sql/share/errmsg.txt:
        Lots of new, dropped and changed error messages
      sql/sql_base.cc:
        Adapted to new method headers
        New method to abort and upgrade lock
        New method to close open tables and downgrade lock
        New method to wait for completed table
      sql/sql_lex.h:
        New flags
      sql/sql_partition.cc:
        Return int instead of bool in get_partition_id
        More defaults handling
        Make use of new mem_alloc_error method
        More work on function headers
        Changes to generate partition syntax to cater for intermediate
        partition states
        Lots of new code with large comments describing new features for
        Partition Management:
        ADD/DROP/REORGANIZE/OPTIMIZE/ANALYZE/CHECK/REPAIR partitions
      sql/sql_show.cc:
        Minors
      sql/sql_table.cc:
        Moved a couple of methods
        New methods to copy create lists and key lists
        for use with mysql_prepare_table
        New method to write frm file
        New handling of handlers with auto partitioning
        Fix CREATE TABLE LIKE
        Moved code for ADD/DROP/REORGANIZE partitions
        Use handlerton method for alter_table_flags
      sql/sql_yacc.yy:
        More memory alloc error checks
        New syntax for REBUILD, ANALYZE, CHECK, OPTIMIZE, REPAIR partitions
      sql/table.cc:
        Fix length of extra part to be 4 bytes
        Partition state introduced in frm file
      sql/table.h:
        Partition state introduced
      sql/unireg.cc:
        Partition state introduced
        Default partition
      storage/csv/ha_tina.cc:
        New handlerton methods
      storage/example/ha_example.cc:
        New handlerton methods
      storage/ndb/include/kernel/ndb_limits.h:
        RANGE DATA
      storage/ndb/include/kernel/signaldata/AlterTable.hpp:
        New interfaces in ALTER TABLE towards NDB kernel
      storage/ndb/include/kernel/signaldata/DiAddTab.hpp:
        New section
      storage/ndb/include/kernel/signaldata/DictTabInfo.hpp:
        Lots of new parts of table description
      storage/ndb/include/kernel/signaldata/LqhFrag.hpp:
        tablespace id specified in LQHFRAGREQ
      storage/ndb/include/ndbapi/NdbDictionary.hpp:
        Lots of new methods in NDB dictionary
      storage/ndb/src/common/debugger/signaldata/DictTabInfo.cpp:
        Lots of new variables in table description
      storage/ndb/src/kernel/blocks/dbdict/Dbdict.cpp:
        Lots of new variables in table description
      storage/ndb/src/kernel/blocks/dbdict/Dbdict.hpp:
        Lots of new variables in table description
      storage/ndb/src/kernel/blocks/dblqh/DblqhMain.cpp:
        New error insertion
      storage/ndb/src/kernel/blocks/dbtup/DbtupMeta.cpp:
        a few extra jam's
      storage/ndb/src/ndbapi/NdbBlob.cpp:
        Changes to definition of blob tables
      storage/ndb/src/ndbapi/NdbDictionary.cpp:
        Lots of new stuff in NDB dictionary
      storage/ndb/src/ndbapi/NdbDictionaryImpl.cpp:
        Lots of new stuff in NDB dictionary
      storage/ndb/src/ndbapi/NdbDictionaryImpl.hpp:
        Lots of new stuff in NDB dictionary
      storage/ndb/test/ndbapi/test_event.cpp:
        removed use of methods no longer in existence
      storage/ndb/tools/restore/Restore.cpp:
        Renamed variable
      19bbb7cc
  2. 05 Nov, 2005 1 commit
    • unknown's avatar
      Fix of crashed 5.1 tree (wrong merge + wrong pullout patch forced us to create a new 5.1 tree) · 9314a207
      unknown authored
      This is a merge of 5.0 -> 5.1 + some code from old 5.1 tree to get all tests to work and keep the .frm format the same as the old 5.1 tree.
      
      
      BitKeeper/etc/ignore:
        added libmysqld/sql_plugin.cc
      include/Makefile.am:
        Added plugin.hd
      include/m_ctype.h:
        Added my_strchr
      include/my_base.h:
        Added HA_USES_PARSER
        Merge with old 5.1 tree
      libmysqld/Makefile.am:
        Added sql_plugin.cc
      mysql-test/r/ndb_gis.result:
        Fixed results after merge
      sql/Makefile.am:
        Addes sql_plugin.h and sql_plugin.cc
      sql/ha_heap.h:
        Indentation fix
      sql/ha_partition.cc:
        Made partition_hton visible outside
        After merge fixes (for call to get_new_handler)
      sql/handler.cc:
        Added partition_hton to handlerton
      sql/handler.h:
        Added partion to handlerton
        Updated mysql_unpack_partion() from old 5.1 tree
      sql/mysql_priv.h:
        Added sql_plugin.h
      sql/records.cc:
        After merge fix
      sql/share/errmsg.txt:
        Added new errors messages from old 5.1 tree
      sql/sql_partition.cc:
        Removed compiler warnings
        Updated mysql_unpack_partition() from latest 5.1 tree
      sql/structs.h:
        Update KEY from latest 5.1 tree (to get table.cc to compile)
      sql/table.cc:
        Merged .frm format from 5.0, new 5.1 and old 5.1 tree
        (We now use same format as the old 5.1 tree)
        Note that this patch includes code for HA_USE_PARSER which is not usable until rest of 5.1 tree is restored
      sql/unireg.cc:
        Merged .frm format from 5.0, new 5.1 and old 5.1 tree
        (We now use same format as the old 5.1 tree)
        Note that this patch includes code for HA_USE_PARSER which is not usable until rest of 5.1 tree is restored
      strings/Makefile.am:
        Added my_strchr.c
      include/plugin.h:
        New BitKeeper file ``include/plugin.h''
      sql/sql_plugin.cc:
        New BitKeeper file ``sql/sql_plugin.cc''
      sql/sql_plugin.h:
        New BitKeeper file ``sql/sql_plugin.h''
      strings/my_strchr.c:
        New BitKeeper file ``strings/my_strchr.c''
      9314a207
  3. 26 Oct, 2005 1 commit
    • unknown's avatar
      Change in gis test to allow NDB to be able to call generic tests. Fix for... · a39cb4fa
      unknown authored
      Change in gis test to allow NDB to be able to call generic tests. Fix for Archive so that ALTER TABLE doesn't issue a warning. Also added test case for alter table.
      
      
      mysql-test/include/gis_generic.inc:
        Change in test for NDB (needs order by)
      mysql-test/r/archive.result:
        Change for gis_generic
      mysql-test/r/archive_gis.result:
        Change in test gis_generic
      mysql-test/r/bdb_gis.result:
        Change in gis test means new results
      mysql-test/r/innodb_gis.result:
        Change in gis test means change in results.
      mysql-test/r/ndb_gis.result:
        Change in gis means result change
      mysql-test/t/archive.test:
        Added alter table test to fix bug in alter table
      mysql-test/t/archive_gis.test:
        Change in syntax
      mysql-test/t/ndb_gis.test:
        Change to test both with and not with pushdown conditions
      sql/ha_archive.cc:
        Removed ARN temp file from exts[] to solve warning messages in alter table.
      a39cb4fa
  4. 25 Oct, 2005 2 commits
    • unknown's avatar
      Additional test request by Jonas. We check pushdown conditions for GEOM types. · 8fdc8d13
      unknown authored
      mysql-test/r/ndb_gis.result:
        Result file change to check pushdown conditions.
      mysql-test/t/ndb_gis.test:
        pushdown conditions now checked for geom  types
      mysql-test/r/innodb_gis.result:
        New BitKeeper file ``mysql-test/r/innodb_gis.result''
      8fdc8d13
    • unknown's avatar
      This patch add support for storing Geometry types to Archive, Innodb, NDB, and BDB. · 84ece2e0
      unknown authored
      sql/ha_archive.h:
        Adding support for Geometry type to archive.
      sql/ha_berkeley.cc:
        Adding geometry support to berkely
      sql/ha_innodb.cc:
        Adding geometry support to Innodb.
      sql/ha_ndbcluster.cc:
        Adding Geometry support to NDB.
      mysql-test/include/gis_generic.inc:
        New BitKeeper file ``mysql-test/include/gis_generic.inc''
      mysql-test/r/archive_gis.result:
        New BitKeeper file ``mysql-test/r/archive_gis.result''
      mysql-test/r/bdb_gis.result:
        New BitKeeper file ``mysql-test/r/bdb_gis.result''
      mysql-test/r/ndb_gis.result:
        New BitKeeper file ``mysql-test/r/ndb_gis.result''
      mysql-test/t/archive_gis.test:
        New BitKeeper file ``mysql-test/t/archive_gis.test''
      mysql-test/t/bdb_gis.test:
        New BitKeeper file ``mysql-test/t/bdb_gis.test''
      mysql-test/t/innodb_gis.test:
        New BitKeeper file ``mysql-test/t/innodb_gis.test''
      mysql-test/t/ndb_gis.test:
        New BitKeeper file ``mysql-test/t/ndb_gis.test''
      84ece2e0
  5. 15 Oct, 2005 1 commit
  6. 26 Sep, 2005 1 commit
  7. 21 Sep, 2005 1 commit
    • unknown's avatar
      Fix for bug #12839 (Endian support is absurd) · 8fdef257
      unknown authored
      mysql-test/r/gis.result:
        test result fixed
      mysql-test/t/gis.test:
        test case added
      sql/field.cc:
        ::construct calls added
      sql/item_geofunc.cc:
        ::construct calls added
      sql/spatial.cc:
        Geometry_*::init_from_wkb implemented
      sql/spatial.h:
        init_from_wkb methods declared
      8fdef257
  8. 27 Aug, 2005 1 commit
  9. 10 Aug, 2005 1 commit
    • unknown's avatar
      Fix for bug #10499 (Function creation with GEOMETRY return) · 6cca9a0f
      unknown authored
      mysql-test/r/gis.result:
        test result fixed
      mysql-test/t/gis.test:
        test case
      sql/sp_head.cc:
        m_geom_returns is sent to make_field
      sql/sp_head.h:
        m_geom_returns declared
      sql/sql_yacc.yy:
        m_geom_returns initializing added
      6cca9a0f
  10. 05 Aug, 2005 1 commit
  11. 29 Apr, 2005 1 commit
    • unknown's avatar
      Fix for #6553 and #8776 (no errors on bad spatial data) · 1df25ccd
      unknown authored
      mysql-test/r/gis-rtree.result:
        test result fixed
      mysql-test/r/gis.result:
        test result fixed
      mysql-test/t/gis-rtree.test:
        test case fixed
      mysql-test/t/gis.test:
        test case added
      sql/field.cc:
        error messages launched now when we try to put bad spatial
        data in the GEOMETRY field
      sql/field.h:
        interface fixed
      sql/item_geofunc.cc:
        bad_data sign now instead of NULL now returned from
        Item_geometry_from_text::val_str
      sql/share/errmsg.txt:
        error message added
      sql/spatial.cc:
        bad_geometry data instance
      sql/spatial.h:
        bad_geometry_data declaration
      sql/sql_base.cc:
        messages now created in store_* function
      1df25ccd
  12. 10 Dec, 2004 1 commit
    • unknown's avatar
      Don't display 'usage' privilege in TABLE_PRIVILEGES if we have columns privileges · c7d7c9ca
      unknown authored
      mysqldump skips information_schema db
      'use' now can use information_schema db
      changed value of column 'Null' to 'NO' if column is not nullable
      
      
      client/mysqldump.c:
        mysqldump skips information_schema db
      mysql-test/r/alter_table.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/create.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/ctype_collate.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/ctype_recoding.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/ctype_ujis.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/drop.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/func_sapdb.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/func_time.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/gis.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/information_schema.result:
        Added couple of tests
      mysql-test/r/information_schema_inno.result:
        Removed coulmn 'CONTRAINT_METOD' from TABLE_CONSTRAINTS
        Added column 'POSITION_IN_UNIQUE_CONSTRAINT' to KEY_COLUMN_USAGE
      mysql-test/r/innodb.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/ndb_autodiscover.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/ps_1general.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/rpl000009.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/rpl_create_database.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/schema.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/select.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/show_check.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/sp.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/type_enum.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/r/type_ranges.result:
        changed value of column 'Null' to 'NO' if column is not nullable
      mysql-test/t/information_schema.test:
        Added couple of tests
      sql/sql_acl.cc:
        Don't display 'usage' privilege in TABLE_PRIVILEGES if we have columns privileges
      sql/sql_db.cc:
        'use' now can use information_schema db
      sql/sql_show.cc:
        code cleanup
        informaton_schema(IS) db now contains data about IS itself
      sql/sql_yacc.yy:
        A fix(wrong behavour of 'SHOW COLUMNS, SHOW KEYS' with 'where condition')
      c7d7c9ca
  13. 22 Oct, 2004 1 commit
    • unknown's avatar
      Fix for bug #6117 (Centroid() crashes server) · 7e38104c
      unknown authored
      I learned that one shouldn't use String::set in val_str() methods...
      
      
      mysql-test/r/gis.result:
        Test result for #6117
      mysql-test/t/gis.test:
        Test case #6117
      sql/item_geofunc.cc:
        String::set doesn't work here
      sql/spatial.cc:
        Error message isn't needed here
      7e38104c
  14. 02 Oct, 2004 1 commit
    • unknown's avatar
      More fixes for strict mode: · 6966e869
      unknown authored
      More tests.
      Better error messages.
      Fixed bug when checking if we updated all needed columns for INSERT.
      Give an error if we encounter a wrong float value during parsing.
      Don't print DEFAULT for columns without a default value in SHOW CREATE/SHOW FIELDS.
      Fixed UPDATE IGNORE when using STRICT mode.
      
      
      include/mysqld_error.h:
        More error messages for strict mode
      include/sql_state.h:
        Fixed wrong state
        New error message
      mysql-test/r/alter_table.result:
        Updated results for not automatic default fields
      mysql-test/r/auto_increment.result:
        Better error messages
      mysql-test/r/create.result:
        Updated results for not automatic default fields
        Better error messages
      mysql-test/r/ctype_collate.result:
        Updated results for not automatic default fields
      mysql-test/r/ctype_latin1_de.result:
        Updated results for not automatic default fields
      mysql-test/r/ctype_many.result:
        Updated results for not automatic default fields
      mysql-test/r/ctype_recoding.result:
        Updated results for not automatic default fields
      mysql-test/r/gis-rtree.result:
        Updated results for not automatic default fields
      mysql-test/r/gis.result:
        Updated results for not automatic default fields
      mysql-test/r/innodb.result:
        Updated results for not automatic default fields
      mysql-test/r/insert.result:
        Better error messages
      mysql-test/r/insert_select.result:
        Better error messages
      mysql-test/r/isam.result:
        Updated results for not automatic default fields
      mysql-test/r/key.result:
        Better error messages
      mysql-test/r/merge.result:
        Updated results for not automatic default fields
      mysql-test/r/null.result:
        Better error messages
      mysql-test/r/null_key.result:
        Better error messages
      mysql-test/r/ps_1general.result:
        Updated results for not automatic default fields
      mysql-test/r/select.result:
        Drop views that may interfere with later results
      mysql-test/r/show_check.result:
        Updated results for not automatic default fields
      mysql-test/r/sp.result:
        Updated results for not automatic default fields
      mysql-test/r/strict.result:
        More tests
      mysql-test/r/type_set.result:
        Updated results for not automatic default fields
      mysql-test/r/warnings.result:
        Better error messages
      mysql-test/t/insert.test:
        Using wrong float values now gives an error
      mysql-test/t/select.test:
        Drop views that may interfere with later results
      mysql-test/t/strict.test:
        More tests
      scripts/mysql_fix_privilege_tables.sql:
        Add missing DEFAULT's
      sql/field.cc:
        Fix some strict mode issues for float and double
      sql/field.h:
        Fix DEFAULT handling
      sql/item.cc:
        Give an error if we encounter a wrong float value during parsing.
        Give an error if we use DEFAULT() on a field that doesn't have a default value.
      sql/item.h:
        Give an error if we encounter a wrong float value during parsing.
      sql/mysqld.cc:
        More debug info
      sql/share/czech/errmsg.txt:
        Better error messages
      sql/share/danish/errmsg.txt:
        Better error messages
      sql/share/dutch/errmsg.txt:
        Better error messages
      sql/share/english/errmsg.txt:
        Better error messages
      sql/share/estonian/errmsg.txt:
        Better error messages
      sql/share/french/errmsg.txt:
        Better error messages
      sql/share/german/errmsg.txt:
        Better error messages
      sql/share/greek/errmsg.txt:
        Better error messages
      sql/share/hungarian/errmsg.txt:
        Better error messages
      sql/share/italian/errmsg.txt:
        Better error messages
      sql/share/japanese/errmsg.txt:
        Better error messages
      sql/share/korean/errmsg.txt:
        Better error messages
      sql/share/norwegian-ny/errmsg.txt:
        Better error messages
      sql/share/norwegian/errmsg.txt:
        Better error messages
      sql/share/polish/errmsg.txt:
        Better error messages
      sql/share/portuguese/errmsg.txt:
        Better error messages
      sql/share/romanian/errmsg.txt:
        Better error messages
      sql/share/russian/errmsg.txt:
        Better error messages
      sql/share/serbian/errmsg.txt:
        Better error messages
      sql/share/slovak/errmsg.txt:
        Better error messages
      sql/share/spanish/errmsg.txt:
        Better error messages
      sql/share/swedish/errmsg.txt:
        Better error messages
      sql/share/ukrainian/errmsg.txt:
        Better error messages
      sql/sql_insert.cc:
        Fixed bug in last push of checking of default values.
      sql/sql_parse.cc:
        Enum fields has always a default value
      sql/sql_show.cc:
        Don't print DEFAULT for columns without a default value in SHOW CREATE/SHOW FIELDS
      sql/sql_table.cc:
        Fixed storing/retrieving of NO_DEFAULT_VALUE_FLAG
      sql/sql_update.cc:
        Don't abort for wrong values for UPDATE IGNORE
      sql/sql_yacc.yy:
        Abort if we find a wrong float value
      sql/table.cc:
        Fixed storing/retrieving of NO_DEFAULT_VALUE_FLAG
      6966e869
  15. 24 Sep, 2004 1 commit
  16. 22 Sep, 2004 1 commit
    • unknown's avatar
      Additional fix for bug #5136 (Geometry object is corrupted when queried) · 126ea49d
      unknown authored
      CREATE TABLE t1 SELECT POINT(1,2); fixed
      
      
      mysql-test/r/gis.result:
        Appropriate test result
      mysql-test/t/gis.test:
        test case
      sql/item_geofunc.cc:
        Item_geometry_func::fix_lengths_and_dec implementation
        several fix_length_and_dec's not needed now
      sql/item_geofunc.h:
        Item_geometry_func class presented
      126ea49d
  17. 15 Sep, 2004 1 commit
    • unknown's avatar
      Fix for bug #5532 (error 22 inserting GIS data) · d8a92015
      unknown authored
      This bug is the result of weird error happening with mi_float8get and double
      arythmetic. I described that in 'Bug that looks potentially dangerous' email
      
      
      myisam/rt_mbr.c:
        *ab_area was changed with the local variable just to make the function
        working without errors
      mysql-test/r/gis.result:
        appropriate test result
      mysql-test/t/gis.test:
        Test case
      d8a92015
  18. 26 Aug, 2004 1 commit
  19. 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
  20. 13 May, 2004 1 commit
  21. 17 Mar, 2004 1 commit
    • unknown's avatar
      Fix for #233 · e308d66a
      unknown authored
      test for IGNORE added
      
      
      mysql-test/r/gis.result:
        test result for IGNORE added
      mysql-test/t/gis.test:
        test for IGNORE added
      e308d66a
  22. 16 Mar, 2004 1 commit
    • unknown's avatar
      Fix for #233 (final part) · 26d0c4b1
      unknown authored
      mysql-test/r/gis.result:
        test result added
      mysql-test/t/gis.test:
        test case added
      sql/field.h:
        now set_field_to_null can return -1
      sql/field_conv.cc:
        now set_field_to_null* can return -1
      26d0c4b1
  23. 04 Mar, 2004 1 commit
    • unknown's avatar
      Optimized GIS functions · afa6728a
      unknown authored
      heap/hp_delete.c:
        Added comments
      mysql-test/r/gis.result:
        Updated results after name changes (all results line are unchanged)
      mysql-test/r/show_check.result:
        Update test results after fix in hp_delete.cc
      mysql-test/t/gis.test:
        Changed table names to longer, hopefully non conflicting ones.
        Added missing drop table
      mysys/hash.c:
        Inendation cleanup
      mysys/tree.c:
        Updated comments
        Decrease tree->allocated on delete (for status)
      sql/field.cc:
        Added safety checking for GIS objects
      sql/gstream.cc:
        Added copyright message
        Made a lot of speed/space optimizations
        Changed class names to be MySQL compliant
      sql/gstream.h:
        Made a lot of speed/space optimizations
        Changed class names to be MySQL compliant
      sql/item_create.cc:
        Indentation fixup
      sql/item_geofunc.cc:
        Use new gis interface functions and new gis class names.
        Simple optimizations
        Indentation fixups
        Fixed a lot of unlikely but possible errors.
      sql/item_geofunc.h:
        Moved SRID_SIZE to spatial.h
      sql/spatial.cc:
        Added copyright message
        Made a lot of speed/space optimizations
        Changed class names to be MySQL compliant
      sql/spatial.h:
        Made a lot of speed/space optimizations
        Changed class names to be MySQL compliant
        Indentation fixes
        Use bool instead of int as result type for functions that only return 0 or 1
      sql/sql_string.cc:
        Simple optimizations
      sql/sql_string.h:
        Simple cleanups
      sql/structs.h:
        Added LEX_STRING_WITH_INIT (needed by spatial.cc)
      afa6728a
  24. 06 Nov, 2003 1 commit
    • unknown's avatar
      fixed printability of gis functions · fd0cc03f
      unknown authored
      code covarage for srid, GeomFromText with 2 parameters
      code covarage foe print() method of gis functions
      
      
      mysql-test/r/gis.result:
        code covarage for srid, GeomFromText with 2 parameters
        code covarage foe print() method of gis functions
      mysql-test/t/gis.test:
        code covarage for srid, GeomFromText with 2 parameters
        code covarage foe print() method of gis functions
        + commented test for issimple() (bugreport sent)
      sql/item_geofunc.h:
        fixed printability of gis functions
      fd0cc03f
  25. 02 Jun, 2003 1 commit
  26. 23 May, 2003 1 commit
    • unknown's avatar
      SHOW FIELDS changes, more SQL99 INFORMATION_SCHEMA.COLUMNS compatibility: · ab8418a5
      unknown authored
      Character set is not displayed in "Type" column anymore
      In "Collation" column NULL instead of BINARY is now displayd for for non-character data types
      
      
      mysql-test/r/alter_table.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/create.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/ctype_collate.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/ctype_recoding.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/gis.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/innodb.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/select.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/show_check.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/type_blob.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/type_float.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      mysql-test/r/type_ranges.result:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      sql/field.cc:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      sql/field.h:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      sql/sql_show.cc:
        Character set is not displayed in "Type" column of SHOW FIELDS anymore
      ab8418a5
  27. 03 Apr, 2003 1 commit
  28. 02 Apr, 2003 1 commit
    • unknown's avatar
      GEOMCOLLFROMWKB(), GEOMETRYCOLLECTIONFROMWKB(), · c709993b
      unknown authored
      LINEFROMWKB(), LINESTRINGFROMWKB(), MLINEFROMWKB(), MPOINTFROMWKB(),
      MPOLYFROMWKB(), MULTILINESTRINGFROMWKB(), MULTIPOINTFROMWKB(),
      MULTIPOLYGONFROMWKB(), POINTFROMWKB(), POLYFROMWKB(), POLYGONFROMWKB()
      functions have been added (as synonyms for GEOMFROMWKB()).
      
      
      mysql-test/t/gis.test:
        GEOMCOLLFROMWKB(), GEOMETRYCOLLECTIONFROMWKB(),
        LINEFROMWKB(), LINESTRINGFROMWKB(), MLINEFROMWKB(), MPOINTFROMWKB(),
        MPOLYFROMWKB(), MULTILINESTRINGFROMWKB(), MULTIPOINTFROMWKB(),
        MULTIPOLYGONFROMWKB(), POINTFROMWKB(), POLYFROMWKB(), POLYGONFROMWKB()
        functions have been added (as synonyms for GEOMFROMWKB()).
      sql/lex.h:
        GEOMCOLLFROMWKB(), GEOMETRYCOLLECTIONFROMWKB(),
        LINEFROMWKB(), LINESTRINGFROMWKB(), MLINEFROMWKB(), MPOINTFROMWKB(),
        MPOLYFROMWKB(), MULTILINESTRINGFROMWKB(), MULTIPOINTFROMWKB(),
        MULTIPOLYGONFROMWKB(), POINTFROMWKB(), POLYFROMWKB(), POLYGONFROMWKB()
        functions have been added (as synonyms for GEOMFROMWKB()).
      c709993b
  29. 31 Mar, 2003 1 commit
  30. 27 Mar, 2003 1 commit
    • unknown's avatar
      More OpenGIS compatibility: · 8bbbd1d6
      unknown authored
      Point, MultiLine, Poligom, etc, are now not aliases
      for Geometry, but separate field types.
      
      
      8bbbd1d6
  31. 18 Mar, 2003 1 commit
    • unknown's avatar
      SRID support. · 3ccd93c7
      unknown authored
      GeomertyFromWKB() function.
      SRID() function.
      ::store() methods for Field_geom.
      Code cleanup.
      
      
      myisam/sp_key.c:
        SRID support.
      mysql-test/r/gis.result:
        We should use GeometryFromWKB().
      mysql-test/t/gis.test:
        We should use GeometryFromWKB().
      sql/field.cc:
        SRID support.
        ::store() methods for Field_geom.
        Code cleanup.
      sql/field.h:
        SRID support.
        ::store() methods for Field_geom.
        Code cleanup.
      sql/item_cmpfunc.cc:
        SRID support.
        Code cleanup.
      sql/item_create.cc:
        Code cleanup.
      sql/item_create.h:
        Code cleanup.
      sql/item_func.cc:
        SRID support.
        Code cleanup.
      sql/item_func.h:
        SRID support.
      sql/item_strfunc.cc:
        SRID support.
        GeometryFromWKB() function.
        Code cleanup.
      sql/item_strfunc.h:
        SRID support.
        GeometryFromWKB() function.
        Code cleanup.
      sql/lex.h:
        GeometryFromWKB() function.
        SRID() function.
      sql/spatial.cc:
        Code cleanup.
      sql/spatial.h:
        Code cleanup.
      sql/sql_yacc.yy:
        Fix for xxxFromText() functions.
        GeometryFromWKB() function.
      3ccd93c7
  32. 06 Mar, 2003 1 commit
  33. 01 Mar, 2003 1 commit