Sequoia don't recover Metadata field information correctly (FIELD FLAGS)
------------------------------------------------------------------------
Key: SEQUOIA-914
URL: https://forge.continuent.org/jira/browse/SEQUOIA-914
Project: Sequoia
Type: Bug
Components: Core
Versions: Sequoia 2.10.5, Sequoia 3.0 beta2, Sequoia 2.10.4, Sequoia
2.10.3, Sequoia 3.0 beta1, Sequoia 2.10.2, Sequoia 2.10.1, Sequoia 2.10,
Sequoia 2.9
Environment: PHP 5.2, Mysql 5.0.22
Reporter: r
Priority: Critical
If you try to recover Field Flags, using for example the function
mysqli_fetch_field and try to get the propery object flags, Seqouia doesn't
return you correct values. This avoid to determinet if a certain field is a
primary key, unique, indexed, not null... correctly.
I tried to attack with the same code one table to get Fields informatión, with
sequoia and without it.... This is the table and these the results:
Field name Type Allow nulls? Key Default value Extras
id int(20) unsigned No Primary auto_increment
gateway varchar(50) No Indexed
domain varchar(50) No None
subscriber varchar(50) No None
dest_id varchar(25) No Indexed
dest_name varchar(255) No None
WITH SEQUOIA:
Name: id
Tipo: int
Len: 20
Flags: not_null unsigned auto_increment
Flags Original Number: 37409
Name: gateway
Tipo: string
Len: 50
Flags: not_null unsigned
Flags Original Number: 4129
Name: domain
Tipo: string
Len: 50
Flags: not_null unsigned
Flags Original Number: 4129
Name: subscriber
Tipo: string
Len: 50
Flags: not_null unsigned
Flags Original Number: 4129
Name: dest_id
Tipo: string
Len: 25
Flags: not_null unsigned
Flags Original Number: 4129
WITHOUT SEQUOIA (SAME CODE):
Name: id
Tipo: int
Len: 20
Flags: not_null primary_key unsigned auto_increment
Flags Original Number: 49699
Tabla: destinations
Name: gateway
Tipo: string
Len: 50
Flags: not_null multiple_key
Flags Original Number: 16393
Name: domain
Tipo: string
Len: 50
Flags: not_null
Flags Original Number: 16385
Name: subscriber
Tipo: string
Len: 50
Flags: not_null
Flags Original Number: 16385
Name: dest_id
Tipo: string
Len: 25
Flags: not_null multiple_key
Flags Original Number: 16393
Name: dest_name
Tipo: string
Len: 255
Flags: not_null
Flags Original Number: 1
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
