Re: [Phpgroupware-developers] compatibility between all databases

[Chris Weiss]

address@hidden (address@hidden) wrote*:
>
>> >insert into phpgw accounts
>> >(account lid, account type, account pwd,
>> >account firstname, account lastname, account status,
>> >account expires) values
>> >('Default','g','438bf90a818801ad1fc0982c343ef11b',
>> >'Default','Group','A','-1')
>>
>> should that '-1' really be a string value?
>>
>
>It seems to be a int.
>Check phpgwapi/setup/tables current.inc.php (line 67 for
>me): it is an int, precision=4.
>
>Is that a bug?
>

I would call it a big fat bug.  It's total violation of ANSI-SQL.

IMO, you need not add hacks to "fix" other peoples failure to comply with
standards.  Report the bug, fix it on your end, and go on about life.