Ticket #1022 (closed defect: fixed)

Opened 7 years ago

Last modified 6 years ago

MySQL driver open fails on a database with no tables

Reported by: hobu Owned by: hobu
Priority: high Milestone: 1.5.0
Component: OGR_SF Version: 1.4.0
Severity: normal Keywords:
Cc: mchapman, mloskot

Description (last modified by mloskot) (diff)

ogrinfo will report that it can correctly open a MySQL database that has no tables. Attempting to do the same thing with Python will result in an error.

Filing this so I remember to clean this issue up when implementing CreateDatasource?

Change History

Changed 6 years ago by hobu

  • status changed from new to assigned
  • description modified (diff)
  • cc mchapman added
  • version changed from unspecified to 1.4.0
  • milestone set to 1.5.0
  • owner changed from warmerdam to hobu

I think Martin Chapman has already fixed this one, but I'm not sure. CC'ing him for confirmation.

Changed 6 years ago by mloskot

  • cc mloskot added
  • description modified (diff)

Changed 6 years ago by hobu

  • status changed from assigned to closed
  • resolution set to fixed

Confirmed that this one seems to work ok. sptest is a newly created database with nothing in it: 

fire:gdal hobu$ ogrinfo MySQL:sptest
INFO: Open of `MySQL:sptest'
      using driver `MySQL' successful.
fire:gdal hobu$ export CPL_DEBUG=on
fire:gdal hobu$ ogrinfo MySQL:sptest
OGR: OGROpen(MySQL:sptest/0x201f90) succeeded as MySQL.
INFO: Open of `MySQL:sptest'
      using driver `MySQL' successful.
OGR: GetLayerCount() = 0

fire:gdal hobu$ ogrinfo MySQL:sptest,user=hobu -so
OGR: OGROpen(MySQL:sptest,user=hobu/0x201fa0) succeeded as MySQL.
INFO: Open of `MySQL:sptest,user=hobu'
      using driver `MySQL' successful.
OGR: GetLayerCount() = 0
Note: See TracTickets for help on using tickets.