An error occurred fetching the project authors.
  1. 28 Jan, 2009 1 commit
    • Alexey Kopytov's avatar
      Fix for bug #21205: Different number of digits for float/double/real in --ps-protocol · a0194637
      Alexey Kopytov authored
      Various parts of code used different 'precision' arguments for sprintf("%g") when converting
      floating point numbers to a string. This led to differences in results in some cases 
      depending on whether the text-based or prepared statements protocol is used for a query.
      
      Fixed by changing arguments to sprintf("%g") to always be 15 (DBL_DIG) so that results are
      consistent regardless of the protocol.
      
      This patch will be null-merged to 6.0 as the problem does not exists there (fixed by the
      patch for WL#2934).
      
      client/sql_string.cc:
        Use 15 (DBL_DIG) as a precision argument for sprintf(), as Field_double::val_str() does.
      libmysql/libmysql.c:
        Use 15 (DBL_DIG) as a precision argument for sprintf(), as Field_double::val_str() does.
      mysql-test/r/archive_gis.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/func_group.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/func_math.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/func_str.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/gis.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/innodb_gis.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/select.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/sp.result:
        Fixed test results to take additional precision into account.
      mysql-test/r/type_float.result:
        Fixed test results to take additional precision into account.
      mysql-test/t/type_float.test:
        Fixed test results to take additional precision into account.
      sql/sql_string.cc:
        Use 15 (DBL_DIG) as a precision argument for sprintf(), as Field_double::val_str() does.
      a0194637
  2. 23 Oct, 2007 1 commit
  3. 10 Oct, 2007 1 commit
    • unknown's avatar
      Bug #30825: Problems when putting a non-spatial index on a GIS column · aec287fd
      unknown authored
       Fixed the usage of spatial data (and Point in specific) with 
       non-spatial indexes.
       Several problems :
         - The length of the Point class was not updated to include the 
           spatial reference system identifier. Fixed by increasing with 4 
           bytes.
         - The storage length of the spatial columns was not accounting for
           the length that is prepended to it. Fixed by treating the 
           spatial data columns as blobs (and thus increasing the storage
           length)
         - When creating the key image for comparison in index read wrong
           key image was created (the one needed for and r-tree search,
           not the one for b-tree/other search). Fixed by treating the
           spatial data columns as blobs (and creating the correct kind of
           image based on the index type). 
      
      
      mysql-test/r/bdb_gis.result:
        Bug #30825: bdb tests
      mysql-test/r/gis-rtree.result:
        Bug #30825: key length changed
      mysql-test/r/gis.result:
        Bug #30825: MyISAM tests
      mysql-test/r/innodb_gis.result:
        Bug #30825: InnoDB tests
      mysql-test/t/bdb_gis.test:
        Bug #30825: bdb tests
      mysql-test/t/gis.test:
        Bug #30825: MyISAM tests
      mysql-test/t/innodb_gis.test:
        Bug #30825: InnoDB tests
      sql/field.cc:
        Bug #30825: Removed Field_geom::get_key_image as Field_blog::get_key_image 
          takes type parameter into consideration and is a superset of 
          Field_geom::get_key_image()
      sql/field.h:
        Bug #30825: Removed Field_geom::get_key_image as Field_blog::get_key_image 
          takes type parameter into consideration and is a superset of 
          Field_geom::get_key_image()
      sql/sql_select.h:
        Bug #30825: Geometry data are a blob derivate
      sql/sql_table.cc:
        Bug #30825: Increased key length to accomodate for
          spatial reference system identifier (srid)
      sql/sql_yacc.yy:
        Bug #30825: Increased key length to accomodate for
          spatial reference system identifier (srid)
      sql/table.cc:
        Bug #30825: It stores a length for spatial data
         as well, so increase the storage length (as it's
         done for blobs).
      mysql-test/include/gis_keys.inc:
        Bug #30825: Test file for spatial data and non-spatial indexes
      aec287fd
  4. 29 May, 2007 1 commit
    • unknown's avatar
      Bug #27531: 5.1 part of the fix · aff34a8c
      unknown authored
      - Renamed "Using join cache" to "Using join buffer".
      - "Using join buffer" is now printed on the last
        table that "reads" from the join buffer cache.
      
      
      mysql-test/r/archive_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/compress.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ctype_utf8.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/derived.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/distinct.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/func_group.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/func_group_innodb.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/greedy_optimizer.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/group_by.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/group_min_max.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/index_merge_myisam.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/information_schema.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/innodb_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/innodb_mysql.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/join.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/join_nested.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/key_diff.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/myisam.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ndb_condition_pushdown.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ndb_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/range.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/row.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/select.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ssl.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ssl_compress.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/subselect.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/subselect3.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/union.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/view.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      sql/sql_select.cc:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      aff34a8c
  5. 04 May, 2007 1 commit
    • unknown's avatar
      bug #27531: 5.1 part of the fix: · 0c835da8
      unknown authored
       - added join cache indication in EXPLAIN (Extra column).
       - prefer filesort over full scan over 
         index for ORDER BY (because it's faster).
       - when switching from REF to RANGE because
         RANGE uses longer key turn off sort on
         the head table only as the resulting 
         RANGE access is a candidate for join cache
         and we don't want to disable it by sorting
         on the first table only. 
      
      
      mysql-test/r/archive_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/compress.result:
        bug #27531:
         - join cache in EXPLAIN. 
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ctype_utf8.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/derived.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/distinct.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/func_group.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/func_group_innodb.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/greedy_optimizer.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/group_by.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/group_min_max.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/index_merge_myisam.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/information_schema.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/innodb_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/innodb_mysql.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/join.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/join_nested.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/key_diff.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/myisam.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/ndb_condition_pushdown.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/ndb_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/range.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/row.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/select.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ssl.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ssl_compress.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/subselect.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/subselect3.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/union.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/view.result:
        bug #27531: join cache in EXPLAIN
      sql/sql_select.cc:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over
           index for ORDER BY.
         - disable sorting on the first table only
           when switching from REF to RANGE.
      0c835da8
  6. 29 Mar, 2007 2 commits
    • unknown's avatar
      gis_generic test cases: · 4e907a7f
      unknown authored
        Revert test case to NOT define any keys; the NDB warning can be handled, and ARCHIVE does not allow indexes
      
      
      mysql-test/include/gis_generic.inc:
        Revert test case to NOT define any keys; the NDB warning can be handled, and ARCHIVE does not allow indexes
      mysql-test/r/archive_gis.result:
        Revert test case to NOT define any keys; the NDB warning can be handled, and ARCHIVE does not allow indexes
      mysql-test/r/bdb_gis.result:
        Revert test case to NOT define any keys; the NDB warning can be handled, and ARCHIVE does not allow indexes
      mysql-test/r/innodb_gis.result:
        Revert test case to NOT define any keys; the NDB warning can be handled, and ARCHIVE does not allow indexes
      mysql-test/r/ndb_gis.result:
        Revert test case to NOT define any keys; the NDB warning can be handled, and ARCHIVE does not allow indexes
      4e907a7f
    • unknown's avatar
      Update test for bug #24563 (MBROverlaps does not seem to function propertly.);... · b9fd97f5
      unknown authored
      Update test for bug #24563 (MBROverlaps does not seem to function propertly.); ARCHIVE doesn't support AUTO_INCREMENT, so specify PK values explicitly
      
      
      mysql-test/r/archive_gis.result:
        update test result
      mysql-test/r/bdb_gis.result:
        update test result
      mysql-test/r/innodb_gis.result:
        update test result
      mysql-test/r/ndb_gis.result:
        update test result
      b9fd97f5
  7. 28 Mar, 2007 1 commit
    • unknown's avatar
      Update test for bug #24563 (MBROverlaps does not seem to function propertly.): · 942bb0df
      unknown authored
      - Add primary key to test table, so NDB with binlog doesn't complain
      - Add extra results for bdb_gis.result
      
      
      mysql-test/include/gis_generic.inc:
        Update test for bug #24563 (MBROverlaps does not seem to function propertly.):
        - Add primary key to test table, so NDB with binlog doesn't complain
      mysql-test/r/archive_gis.result:
        update test results
      mysql-test/r/bdb_gis.result:
        update test results
      mysql-test/r/innodb_gis.result:
        update test results
      mysql-test/r/ndb_gis.result:
        update test results
      942bb0df
  8. 23 Mar, 2007 1 commit
    • unknown's avatar
      Bug #24563: MBROverlaps does not seem to function propertly. · eee28a26
      unknown authored
      Fix is to rewrite the MBR::overlaps() function, to compute the dimension of both
      arguments, and the dimension of the intersection; test that all three dimensions are the
      same (e.g., all are Polygons).
      
      Add tests for all MBR* functions for various combinations of shapes, lines and points.
      
      
      mysql-test/include/gis_generic.inc:
        Add tests & checks for bug #24563 and bug #24588 - some GIS functions missing in
        5.1; many GIS functions not tested; Overlaps() function was incorrect when MBR shifted
        only along one axis; Overlaps() needs to take dimension of shape into account.
      mysql-test/r/archive_gis.result:
        Update test results.
      mysql-test/r/bdb_gis.result:
        Update test results.
      mysql-test/r/gis.result:
        Update test results.
      mysql-test/r/innodb_gis.result:
        Update test results.
      mysql-test/r/ndb_gis.result:
        Update test results.
      mysql-test/t/gis.test:
        Add tests & checks for bug #24563 and bug #24588 - some GIS functions missing in
        5.1; many GIS functions not tested; Overlaps() function was incorrect when MBR shifted
        only along one axis; Overlaps() needs to take dimension of shape into account.
      sql/spatial.h:
        Add MBR::dimension() (map MBR to integral dimension: point -> 0, line -> 1,
        polygon -> 2, invalid -> -1)
        
        Fix MBR::overlaps() to handle MBRs which are shifted on one dimension only, and to
        take MBR dimension into account.  Also, test both within() and contains() predicates (so
        that overlaps(a, b) == overlaps(b, a)).
      eee28a26
  9. 02 Mar, 2007 1 commit
    • unknown's avatar
      after merge fix (bug #26038) · d4272a16
      unknown authored
      Item_func_geometry_from_text::val_str() should set null_value
      in case of wrong data.
      
      
      mysql-test/include/gis_generic.inc:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/archive_gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/innodb_gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/ndb_gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/t/gis.test:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      sql/item_geofunc.cc:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      d4272a16
  10. 24 Jan, 2007 1 commit
    • unknown's avatar
      bug #22682 Test fails --without-geometry · f469aa00
      unknown authored
      geometry dependent parts moved to proper .test files
      
      
      mysql-test/r/gis.result:
        result fixed
      mysql-test/r/innodb.result:
        result fixed
      mysql-test/r/innodb_gis.result:
        result fixed
      mysql-test/r/view.result:
        result fixed
      mysql-test/t/gis.test:
        HAVE_GEOMETRY dependent part moved here from view.test
      mysql-test/t/innodb.test:
        HAVE_GEOMETRY dependent part moved to innodb_gis.test
      BitKeeper/etc/ignore:
        Added libmysqld/sql_servers.cc to the ignore list
      mysql-test/t/innodb_gis.test:
        HAVE_GEOMETRY dependent part moved here from innodb.test
      mysql-test/t/view.test:
        HAVE_GEOMETRY dependent part moved to gis.test
      f469aa00
  11. 28 Jul, 2006 1 commit
    • unknown's avatar
      BUG#14940 "MySQL choose wrong index", v.2 · ef452e19
      unknown authored
      - Make the range-et-al optimizer produce E(#table records after table 
                                                 condition is applied),
      - Make the join optimizer use this value,
      - Add "filtered" column to EXPLAIN EXTENDED to show 
        fraction of records left after table condition is applied
      - Adjust test results, add comments
      
      
      mysql-test/r/archive_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/auto_increment.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/bdb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/bench_count_distinct.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/binlog_stm_blackhole.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/case.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/cast.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ctype_collate.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ctype_cp1250_ch.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/date_formats.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/distinct.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/fulltext.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_crypt.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_default.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_encrypt.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_gconcat.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_group.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_if.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_in.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_like.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_math.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_op.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_regexp.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_set.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_str.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_system.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_test.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_time.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/group_by.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/group_min_max.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/having.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/heap.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/heap_hash.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge_innodb.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge_ror.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/innodb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/insert_update.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/join.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/join_nested.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/key_diff.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/myisam.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ndb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/negation_elimination.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/null.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/olap.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/partition_pruning.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/query_cache.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/row.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/rpl_get_lock.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/rpl_master_pos_wait.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/select.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ssl.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ssl_compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/subselect.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/type_blob.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/union.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/varbinary.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/variables.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/view.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/ctype_cp1250_ch.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/func_like.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/group_min_max.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/index_merge_ror.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/index_merge_ror_cpk.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/join.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/partition_pruning.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      sql/opt_range.cc:
        BUG#14940: Make range/index_merge/group-min-max optimizer produce TABLE::quick_condition_rows -
          estimate of #records that will match the table condition.
      sql/sql_class.cc:
        BUG#14940: Add "filtered" column to output of EXPLAIN EXTENDED
      sql/sql_select.cc:
        BUG#14940: 
        - Make the join optimizer to use TABLE::quick_condition_rows=
          = E(#table records after filtering with table condition) 
        - Add "filtered" column to output of EXPLAIN EXTENDED
      sql/sql_select.h:
        BUG#14940: Added comments
      sql/table.h:
        BUG#14940: Added comments
      ef452e19
  12. 03 Mar, 2006 1 commit
    • unknown's avatar
      Bug#17728 tests that fails are: ndb_gis rpl_ndb_multi_update2 · 88841e3c
      unknown authored
       - Fix for ndb_gis to run with all types of logging
      
      
      mysql-test/include/gis_generic.inc:
        Make the test tables for gis have a primary key with auto increment
      mysql-test/r/archive_gis.result:
        Update test result
      mysql-test/r/bdb_gis.result:
        Update test result
      mysql-test/r/innodb_gis.result:
        Update test result
      mysql-test/r/ndb_gis.result:
        Update test result
      mysql-test/t/ndb_gis.test:
        Remove the requirement to only run thiswhen binlog format is row.
      88841e3c
  13. 22 Feb, 2006 1 commit
    • unknown's avatar
      Bug#10460 SHOW CREATE TABLE uses inconsistent upper/lower case · 31a7a0d6
      unknown authored
      mysql-test/r/alter_table.result:
        Update test result
      mysql-test/r/analyse.result:
        Update test result
      mysql-test/r/archive.result:
        Update test result
      mysql-test/r/archive_bitfield.result:
        Update test result
      mysql-test/r/archive_gis.result:
        Update test result
      mysql-test/r/bdb.result:
        Update test result
      mysql-test/r/bdb_gis.result:
        Update test result
      mysql-test/r/bigint.result:
        Update test result
      mysql-test/r/binary.result:
        Update test result
      mysql-test/r/case.result:
        Update test result
      mysql-test/r/cast.result:
        Update test result
      mysql-test/r/constraints.result:
        Update test result
      mysql-test/r/create.result:
        Update test result
      mysql-test/r/ctype_collate.result:
        Update test result
      mysql-test/r/ctype_create.result:
        Update test result
      mysql-test/r/ctype_latin1_de.result:
        Update test result
      mysql-test/r/ctype_many.result:
        Update test result
      mysql-test/r/ctype_mb.result:
        Update test result
      mysql-test/r/ctype_recoding.result:
        Update test result
      mysql-test/r/ctype_sjis.result:
        Update test result
      mysql-test/r/ctype_tis620.result:
        Update test result
      mysql-test/r/ctype_ucs.result:
        Update test result
      mysql-test/r/ctype_ujis.result:
        Update test result
      mysql-test/r/ctype_utf8.result:
        Update test result
      mysql-test/r/default.result:
        Update test result
      mysql-test/r/events.result:
        Update test result
      mysql-test/r/federated.result:
        Update test result
      mysql-test/r/fulltext.result:
        Update test result
      mysql-test/r/func_gconcat.result:
        Update test result
      mysql-test/r/func_group.result:
        Update test result
      mysql-test/r/func_math.result:
        Update test result
      mysql-test/r/func_misc.result:
        Update test result
      mysql-test/r/func_str.result:
        Update test result
      mysql-test/r/func_system.result:
        Update test result
      mysql-test/r/gis-rtree.result:
        Update test result
      mysql-test/r/heap.result:
        Update test result
      mysql-test/r/index_merge_innodb.result:
        Update test result
      mysql-test/r/information_schema.result:
        Update test result
      mysql-test/r/innodb.result:
        Update test result
      mysql-test/r/innodb_gis.result:
        Update test result
      mysql-test/r/key.result:
        Update test result
      mysql-test/r/merge.result:
        Update test result
      mysql-test/r/myisam.result:
        Update test result
      mysql-test/r/mysqldump-max.result:
        Update test result
      mysql-test/r/mysqldump.result:
        Update test result
      mysql-test/r/ndb_bitfield.result:
        Update test result
      mysql-test/r/ndb_gis.result:
        Update test result
      mysql-test/r/ndb_partition_key.result:
        Update test result
      mysql-test/r/null.result:
        Update test result
      mysql-test/r/partition.result:
        Update test result
      mysql-test/r/partition_02myisam.result:
        Update test result
      mysql-test/r/partition_mgm_err.result:
        Update test result
      mysql-test/r/partition_range.result:
        Update test result
      mysql-test/r/ps_2myisam.result:
        Update test result
      mysql-test/r/ps_3innodb.result:
        Update test result
      mysql-test/r/ps_4heap.result:
        Update test result
      mysql-test/r/ps_5merge.result:
        Update test result
      mysql-test/r/ps_6bdb.result:
        Update test result
      mysql-test/r/rpl_mixed_ddl_dml.result:
        Update test result
      mysql-test/r/rpl_multi_engine.result:
        Update test result
      mysql-test/r/rpl_ndb_UUID.result:
        Update test result
      mysql-test/r/show_check.result:
        Update test result
      mysql-test/r/sp-vars.result:
        Update test result
      mysql-test/r/sp.result:
        Update test result
      mysql-test/r/sql_mode.result:
        Update test result
      mysql-test/r/strict.result:
        Update test result
      mysql-test/r/subselect.result:
        Update test result
      mysql-test/r/symlink.result:
        Update test result
      mysql-test/r/synchronization.result:
        Update test result
      mysql-test/r/system_mysql_db.result:
        Update test result
      mysql-test/r/temp_table.result:
        Update test result
      mysql-test/r/trigger.result:
        Update test result
      mysql-test/r/type_binary.result:
        Update test result
      mysql-test/r/type_bit.result:
        Update test result
      mysql-test/r/type_bit_innodb.result:
        Update test result
      mysql-test/r/type_blob.result:
        Update test result
      mysql-test/r/type_decimal.result:
        Update test result
      mysql-test/r/type_enum.result:
        Update test result
      mysql-test/r/type_float.result:
        Update test result
      mysql-test/r/type_nchar.result:
        Update test result
      mysql-test/r/type_newdecimal.result:
        Update test result
      mysql-test/r/type_set.result:
        Update test result
      mysql-test/r/type_timestamp.result:
        Update test result
      mysql-test/r/type_varchar.result:
        Update test result
      mysql-test/r/union.result:
        Update test result
      mysql-test/r/user_var.result:
        Update test result
      mysql-test/r/variables.result:
        Update test result
      sql/sql_show.cc:
        Make ouput from SHOW CREATE TABLE use uppercase for "CHARACTER SET", "COLLATE", "DEFAULT", "ON UPDATE" and "AUTO_INCREMENT"
      31a7a0d6
  14. 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
  15. 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
  16. 15 Oct, 2005 1 commit
  17. 26 Sep, 2005 1 commit
  18. 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
  19. 27 Aug, 2005 1 commit
  20. 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
  21. 05 Aug, 2005 1 commit
  22. 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
  23. 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
  24. 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
  25. 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
  26. 24 Sep, 2004 1 commit
  27. 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
  28. 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
  29. 26 Aug, 2004 1 commit
  30. 20 Jul, 2004 1 commit
    • unknown's avatar
      mark subquery in the FROM clause like derived and quoate all identifiers (BUG#4609) · ec33aa2b
      unknown authored
      mysql-test/r/bench_count_distinct.result:
        Quoting of fields and tables names
      mysql-test/r/case.result:
        Quoting of fields and tables names
      mysql-test/r/fulltext.result:
        Quoting of fields and tables names
      mysql-test/r/func_default.result:
        Quoting of fields and tables names
      mysql-test/r/func_gconcat.result:
        Quoting of fields and tables names
      mysql-test/r/func_group.result:
        Quoting of fields and tables names
      mysql-test/r/func_if.result:
        Quoting of fields and tables names
      mysql-test/r/func_in.result:
        Quoting of fields and tables names
      mysql-test/r/func_regexp.result:
        Quoting of fields and tables names
      mysql-test/r/func_test.result:
        Quoting of fields and tables names
      mysql-test/r/gis.result:
        Quoting of fields and tables names
      mysql-test/r/group_by.result:
        Quoting of fields and tables names
      mysql-test/r/having.result:
        Quoting of fields and tables names
      mysql-test/r/insert_update.result:
        Quoting of fields and tables names
      mysql-test/r/join_nested.result:
        Quoting of fields and tables names
      mysql-test/r/olap.result:
        Quoting of fields and tables names
      mysql-test/r/query_cache.result:
        Quoting of fields and tables names
      mysql-test/r/select.result:
        Quoting of fields and tables names
      mysql-test/r/subselect.result:
        Quoting of fields and tables names
      mysql-test/r/union.result:
        Quoting of fields and tables names
      mysql-test/r/varbinary.result:
        Quoting of fields and tables names
      mysql-test/r/view.result:
        Quoting of fields and tables names
        test of view with quated fields
      mysql-test/t/view.test:
        test of view with quated fields
      sql/item.cc:
        Quoting of fields and tables names
      sql/item.h:
        Quoting of fields and tables names
      sql/sql_select.cc:
        Quoting of fields and tables names
      sql/sql_view.cc:
        mark subquery in the FROM clause like derived
      ec33aa2b
  31. 13 May, 2004 1 commit
  32. 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
  33. 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
  34. 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
  35. 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
  36. 02 Jun, 2003 1 commit
  37. 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
  38. 03 Apr, 2003 1 commit