View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005761 | VALENTINA SERVER | SQL | public | 2012-04-04 10:07 | 2012-04-10 22:38 |
Reporter | Kirill Pekarov | Assigned To | Ivan Smahin | ||
Priority | high | Severity | crash | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
Product Version | 5.0 | ||||
Fixed in Version | 5.0 | ||||
Summary | 0005761: VServer crashes on query with binding from VPHP5.0 | ||||
Description | PHP script: <?php ini_set('display_errors',1); $conn = valentina_connect( "192.168.1.6:15433", "sa", "sa", "Latin1" ); if(!$conn) die ("error connecting!"); valentina_select_db("database1"); valentina_query("SELECT * FROM person WHERE Name = :1", array('john')); valentina_close( $conn ); ?> Database damp attached | ||||
Tags | No tags attached. | ||||
1.sql (3,416 bytes) |
|
Binding array looks good. After the query "SELECT * FROM person WHERE Name = :1", VServer has sent exception 394504 and crashed. |
|
2012-04-04 13:28:29.176171 (TID 140187690264320): (UID 27) Database 'database1.vdb' remoteID 34114704 registered. 2012-04-04 13:28:29.176224 (TID 140187690264320): (UID 27) Database 'database1' has been successfully opened. 2012-04-04 13:28:29.189456 (TID 140187665086208): (UID 27) I_SqlDatabase 'database1.vdb' SqlQuery 'SELECT * FROM person WHERE Name = :1'. |
|
issue was in fact that VPHP send strings as varbinary value, and there was no such convert ion in kernel ... it is added now .. Besides this bug have inspired improves in the Binding area of VPHP... |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2012-04-04 10:07 | Kirill Pekarov | New Issue | |
2012-04-04 10:07 | Kirill Pekarov | File Added: 1.sql | |
2012-04-04 10:22 | Kirill Pekarov | Note Added: 0006258 | |
2012-04-04 10:35 | Kirill Pekarov | Note Added: 0006259 | |
2012-04-10 22:38 | Ruslan Zasukhin | Note Added: 0006263 | |
2012-04-10 22:38 | Ruslan Zasukhin | Status | assigned => resolved |
2012-04-10 22:38 | Ruslan Zasukhin | Fixed in Version | => 5.0 |
2012-04-10 22:38 | Ruslan Zasukhin | Resolution | open => fixed |