View previous topic :: View next topic |
Author |
Message |
yi
Joined: 17 May 2005 Posts: 12 Location: France
|
Posted: Sun Nov 19, 2006 18:31 Post subject: Serveur with NWNX4 1.04 crash when a select retreive a NULL |
|
|
Papillon,
NWNXServeur crash when I retreive a NULL string with the version 1.04 (with MySQL database)
request : a simple Quote: | SELECT toto FROM table |
A will do some test to have more precision _________________ http://www.arkalym.com |
|
Back to top |
|
|
amphiprion
Joined: 07 Nov 2006 Posts: 44 Location: Toulouse (France)
|
Posted: Sun Nov 19, 2006 18:34 Post subject: |
|
|
Same bug here (field type independant - VARCHAR - INT- ....) |
|
Back to top |
|
|
yi
Joined: 17 May 2005 Posts: 12 Location: France
|
Posted: Sun Nov 19, 2006 18:53 Post subject: |
|
|
more details
it crashs if the result of the request is NULL
it does not crahs if the result of the resquest is empty
I hope it helps _________________ http://www.arkalym.com |
|
Back to top |
|
|
Papillon x-man
Joined: 28 Dec 2004 Posts: 1060 Location: Germany
|
Posted: Sun Nov 19, 2006 19:42 Post subject: |
|
|
Fixed. Redownload the prototype4 archive to get the updated version.
I wonder what would be better: Should NWNX return "NULL" or "" (empty string) for NULL columns ? I think an empty string is more in line with how NWScript works and what users probably expect. _________________ Papillon |
|
Back to top |
|
|
yi
Joined: 17 May 2005 Posts: 12 Location: France
|
|
Back to top |
|
|
amphiprion
Joined: 07 Nov 2006 Posts: 44 Location: Toulouse (France)
|
Posted: Sun Nov 19, 2006 19:58 Post subject: |
|
|
thanks papillon, and yes, it's better to return empty value for compliance and nwscript logic. |
|
Back to top |
|
|
Grinning Fool
Joined: 12 Feb 2005 Posts: 264
|
Posted: Mon Nov 20, 2006 4:52 Post subject: |
|
|
Agreed, empty string makes the most sense and would be consistent with prior versions (and compatible with existing scripts). |
|
Back to top |
|
|
|