#19045 [Fbk-NoF]: SELECT DISTINCT with just ONE table doesn't work
ID: 19045 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: No Feedback Bug Type: ODBC related Operating System: IIS4 on NT4 PHP Version: 4.2.2 New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to Open. Thank you. Previous Comments: [2003-01-06 12:32:42] [EMAIL PROTECTED] Can you send me a sample schema/dataset to immitate your behavior exactly? [2002-12-09 11:06:38] [EMAIL PROTECTED] I made the test again with PHP Version 4.3.0RC2, and I have the same results ; with two tables it works, but not with one. [2002-11-26 19:59:40] [EMAIL PROTECTED] No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to Open. Thank you. [2002-11-15 18:11:26] [EMAIL PROTECTED] Any chance you can check to see if this is still happening for you with the 4.3RC? [2002-10-04 07:03:49] [EMAIL PROTECTED] I didn't find any tab with 'logging on' checkbox in ODBC Administrator program ; so, I changed the value of the 'Driver Logging' parameter to 17 in the oraodbc.ini file. I hope it can help you... Merci. // logging results when the request works fine (with two joined tables) Oracle ODBC 32 Bit Driver Version 08.00.6000 Oracle ODBC 32 Bit Driver File Version08.00.6000 0X0013BA50: php 0X 0X0013F078: php 0X 0X0013F8D0: php 0X 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES, GROUPE_MACHINE where poste=machine 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES, GROUPE_MACHINE where poste=machine 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES, GROUPE_MACHINE where poste=machine 0X0013FC70: Rows Fetched = 0X006E // logging results when the request doesn't work fine (with one table) Oracle ODBC 32 Bit Driver Version 08.00.6000 Oracle ODBC 32 Bit Driver File Version08.00.6000 0X0013BA50: php 0X 0X0013F078: php 0X 0X0013F8D0: php 0X 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES 0X0013FC70: SELECT ROWID from TEMPSCUMULES 0X0013FC70: SELECT ROWID,distinct SOCIETE, POSTE from TEMPSCUMULES WHERE ROWID='' 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19045 -- Edit this bug report at http://bugs.php.net/?id=19045edit=1
#19045 [Fbk-NoF]: SELECT DISTINCT with just ONE table doesn't work
ID: 19045 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: No Feedback Bug Type: ODBC related Operating System: IIS4 on NT4 PHP Version: 4.2.2 New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to Open. Thank you. Previous Comments: [2002-11-15 18:11:26] [EMAIL PROTECTED] Any chance you can check to see if this is still happening for you with the 4.3RC? [2002-10-04 07:03:49] [EMAIL PROTECTED] I didn't find any tab with 'logging on' checkbox in ODBC Administrator program ; so, I changed the value of the 'Driver Logging' parameter to 17 in the oraodbc.ini file. I hope it can help you... Merci. // logging results when the request works fine (with two joined tables) Oracle ODBC 32 Bit Driver Version 08.00.6000 Oracle ODBC 32 Bit Driver File Version08.00.6000 0X0013BA50: php 0X 0X0013F078: php 0X 0X0013F8D0: php 0X 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES, GROUPE_MACHINE where poste=machine 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES, GROUPE_MACHINE where poste=machine 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES, GROUPE_MACHINE where poste=machine 0X0013FC70: Rows Fetched = 0X006E // logging results when the request doesn't work fine (with one table) Oracle ODBC 32 Bit Driver Version 08.00.6000 Oracle ODBC 32 Bit Driver File Version08.00.6000 0X0013BA50: php 0X 0X0013F078: php 0X 0X0013F8D0: php 0X 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES 0X0013FC70: SELECT ROWID from TEMPSCUMULES 0X0013FC70: SELECT ROWID,distinct SOCIETE, POSTE from TEMPSCUMULES WHERE ROWID='' 0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES [2002-10-03 07:48:10] [EMAIL PROTECTED] Open your ODBC Administrator and there should be tab that has a little check box that says Turn Logging On I believe it's on the same tab as the Pooling information. [2002-10-03 01:40:16] [EMAIL PROTECTED] how I can turn the logging on ? [2002-10-02 12:28:21] [EMAIL PROTECTED] Any chance you can re-do this with logging turned on? I did some research into this, and believe I've figured it out although I'd like to see if your actions fall into the same series of steps as mine. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19045 -- Edit this bug report at http://bugs.php.net/?id=19045edit=1
