Hi, I am migrating a project from SA 0.3 to SA 0.4 and the following field/ index produces an error:
sa.Table('resource_path', self.db_metadata, sa.Column('id', sa.Integer, primary_key = True), sa.Column('path', sa.Binary(255), index = True), mysql_engine='INNODB' ) The complete error message is: ------------------------ Traceback (most recent call last): File "Guard/DBTest.py", line 43, in setUp self.assert_(self.db.install()) File "/home/sam/code/spiff_guard/tests/Guard/../../src/Guard/DB.py", line 35, in install table.create(checkfirst = True) File "/var/lib/python-support/python2.5/sqlalchemy/schema.py", line 300, in create self.metadata.create_all(bind=bind, checkfirst=checkfirst, tables=[self]) File "/var/lib/python-support/python2.5/sqlalchemy/schema.py", line 1215, in create_all bind.create(self, checkfirst=checkfirst, tables=tables) File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 1131, in create self._run_visitor(self.dialect.schemagenerator, entity, connection=connection, **kwargs) File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 1160, in _run_visitor visitorcallable(self.dialect, conn, **kwargs).traverse(element) File "/var/lib/python-support/python2.5/sqlalchemy/sql/visitors.py", line 76, in traverse meth(target) File "/var/lib/python-support/python2.5/sqlalchemy/sql/compiler.py", line 760, in visit_metadata self.traverse_single(table) File "/var/lib/python-support/python2.5/sqlalchemy/sql/visitors.py", line 30, in traverse_single return meth(obj, **kwargs) File "/var/lib/python-support/python2.5/sqlalchemy/sql/compiler.py", line 796, in visit_table self.traverse_single(index) File "/var/lib/python-support/python2.5/sqlalchemy/sql/visitors.py", line 30, in traverse_single return meth(obj, **kwargs) File "/var/lib/python-support/python2.5/sqlalchemy/sql/compiler.py", line 881, in visit_index self.execute() File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 1760, in execute return self.connection.execute(self.buffer.getvalue()) File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 844, in execute return Connection.executors[c](self, object, multiparams, params) File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 854, in _execute_text self.__execute_raw(context) File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 916, in __execute_raw self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context) File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 953, in _cursor_execute self._handle_dbapi_exception(e, statement, parameters, cursor) File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py", line 935, in _handle_dbapi_exception raise exceptions.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect) OperationalError: (OperationalError) (1170, "BLOB/TEXT column 'path' used in key specification without a key length") 'CREATE INDEX ix_guard_resource_path_path ON guard_resource_path (path)' {} ------------------------ The same table specification works in SA 0.3. Any idea? -Samuel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---