Bug #990

interbase/firebird SQL compatibility suggestions

Details

Submitted	2004-03-10 17:03 UTC
From	banshee at netcetera dot pl
Assigned	lsmith
Status	Closed
Package	LiveUser
PHP Version	4.3.4
OS	linux
Roadmaps	(Not assigned)

Comments

[2004-03-10 17:03 UTC] banshee at netcetera dot pl

Description:
------------
Two things:

1) field name "type" used in some database tables is a interbase/firebird reserved word, so some querys (and therefore entire LiveUser) won't work. :(

2) the CASE .. WHEN sql statements in LiveUser_admin_auth_DB::getUsers().
This statement is not implemented in Interbase / firebird1.0,

thats all for now;)

[2004-04-07 22:23 UTC] banshee at netcetera dot pl

Well they claim to be sql 92, but not the CASE statement (and a few others). Anyway I'm more into firebird now(waiting for stable 1.5 ;) ). So I think i'll just change this 'N's and 'Y's to 0 and 1, change some querys and make my firebird-only version of liveuser. In fact I already did it for db_medium(to some extent) ;)

[2004-04-24 11:23 UTC] smith at backendmedia dot com

1) is fixed in CVS
2) will not be fixed .. we recommend using the MDB[2] containers instead or you can manually adjust the DB container. Please also note that you can use DB in your application and use MDB[2] inside LiveUser.