psDBGenerateCreateTableSQL() incorrectly handles most "META" types

[jhoblitt]

Similar to bug #345, this function mishandles non-numeric types. A
'PS_META_VEC'/etc. does not map to an SQL vachar.

} else if ((item->type == PS_META_STR)

(item->type ==

PS_META_VEC)

(item->type == PS_META_IMG)

(item->type ==

PS_META_HASH)

(item->type == PS_META_LOOKUPTABLE)

(item->type ==

PS_META_JPEG)

(item->type == PS_META_PNG)

(item->type ==

PS_META_ASTROM)

(item->type == PS_META_UNKNOWN)

(item->type ==

PS_TYPE_PTR)) {

+ column name + _ + varchar( + length + )
psStringAppend(&query, "%s VARCHAR(%s)", item->name, item->data.V);

} else {

[aaron.culliney@…]

I believe this is now fixed.

[jhoblitt]

Verified by source inspection. Thanks.

[Paul Price]

Bugs have been fixed... closing.