Ticket #2295 (new defect)

Opened 1 year ago

Last modified 1 year ago

WebStorageClientTest DB error’s [Hardy]

Reported by: fvanberckel Assigned to: anonymous
Priority: normal Milestone: 1.4.0-Monrovia
Component: Development Environment Version:
Severity: minor Keywords:
Cc:

Description

While setting up Campcaster on the Ubuntu Hardy beta with postgresql-8.3. Getting these DB error ‘s in the WebStorageClientTest.

src/WebStorageClientTest.cxx:563:Assertion
Test name: LiveSupport::StorageClient::WebStorageClientTest::simplePlaylistTest
forced failure
- XML-RPC method 'locstor.savePlaylist' returned error message:
805 - xr_savePlaylist: DB Error: unknown error 
            SELECT parmd.predns as parns, parmd.predicate as parname,
                md.predxml, md.predns as chns, md.predicate as chname
            FROM ls_mdata parmd
            INNER JOIN ls_mdata md
                ON parmd.id=md.subject AND md.subjns='_I'
            WHERE md.id=8018 [nativecode=ERROR:  operator does not exist: integ
er = character varying
LINE 6:                 ON parmd.id=md.subject AND md.subjns='_I'
                                   ^
HINT:  No operator matches the given name and argument type(s). You might need 
to add explicit type casts.]
src/WebStorageClientTest.cxx:241:Assertion
Test name: LiveSupport::StorageClient::WebStorageClientTest::playlistTest
forced failure
- XML-RPC method 'locstor.savePlaylist' returned error message:
805 - xr_savePlaylist: DB Error: unknown error 
            SELECT parmd.predns as parns, parmd.predicate as parname,
                md.predxml, md.predns as chns, md.predicate as chname
            FROM ls_mdata parmd
            INNER JOIN ls_mdata md
                ON parmd.id=md.subject AND md.subjns='_I'
            WHERE md.id=8444 [nativecode=ERROR:  operator does not exist: integ
er = character varying
LINE 6:                 ON parmd.id=md.subject AND md.subjns='_I'
                                   ^
HINT:  No operator matches the given name and argument type(s). You might need 
to add explicit type casts.]
src/WebStorageClientTest.cxx:484:Assertion
Test name: LiveSupport::StorageClient::WebStorageClientTest::audioClipTest
forced failure
- XML-RPC method 'locstor.storeAudioClipClose' returned error message:
805 - xr_storeAudioClipClose: StoredFile::RecallByToken: invalid token (7c85d61
e45036b6b) 
src/WebStorageClientTest.cxx:1048:Assertion
Test name: LiveSupport::StorageClient::WebStorageClientTest::importPlaylistTest
unexpected exception caught
- Caught: LiveSupport::Core::XmlRpcMethodFaultException
- What(): XML-RPC method 'locstor.savePlaylist' returned error message:
805 - xr_savePlaylist: DB Error: unknown error 
            SELECT parmd.predns as parns, parmd.predicate as parname,
                md.predxml, md.predns as chns, md.predicate as chname
            FROM ls_mdata parmd
            INNER JOIN ls_mdata md
                ON parmd.id=md.subject AND md.subjns='_I'
            WHERE md.id=11530 [nativecode=ERROR:  operator does not exist: inte
ger = character varying
LINE 6:                 ON parmd.id=md.subject AND md.subjns='_I'
                                   ^
HINT:  No operator matches the given name and argument type(s). You might need 
to add explicit type casts.]

Change History

  04/04/08 14:18:45 changed by fvanberckel

  • summary changed from WebStorageClientTest DB error ‘s to WebStorageClientTest DB error’s [Hardy].

  05/21/08 21:04:00 changed by tomash

Hi, it looks analogical to #2300

Every SQL comparison like:
parmd.id=md.subject
have to be probably extended of explicit cast:
parmd.id=md.subject::integer