mariano / node-db-oracle

Oracle database bindings for Node.js
http://nodejsdb.org
141 stars 34 forks source link

SegFault when performing SELECT to alternate schema #34

Open ghost opened 12 years ago

ghost commented 12 years ago

I am getting a SegFault when I try to do a SELECT to alternate schema. No SegFault when schema is not specified or changed. Assume code excerpts occurs after valid connection and authentication have taken place.

First scenario:

db.query().execute("SELECT * FROM greensboro.address_lt", function(error, rows, cols) { ... }

Yields:

Segmentation fault (core dumped)

Second scenario:

db.query().execute('ALTER SESSION SET CURRENT_SCHEMA = greensboro', function(error, rows, cols) {
    db.query().execute("SELECT * FROM address_lt", function(error, rows, cols) { ... }
}

Yields:

Segmentation fault (core dumped)

Details:

  • Oracle 11g
  • Ubuntu 32bit Server 12.04
  • Node 0.6.16
  • db-oracle 0.2.3
ghost commented 12 years ago

This might be an Oracle Instant Client issue. Repeatable with other Node Oracle driver. This might be a Close/Ignore.