[CDBI] Bug with sequences and the object cache ( I think )

[prev] [thread] [next] [Date index for 2005/11/09]

------=_Part_14313_26537094.1131556017057
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

I came across some odd behaviour in Class::DBI and have reduced it
down to the attached test script.

It involves sequences - when a primary key is created from a sequence
then the object is not correctly fetched from / stored in  the object
cache which leads to there being two objects in memory at once. My
guess is that the identifier is being looked at differently / maybe a
string/integer thing. I haven't dug into the sources so this is just a
guess.

The test needs a postgres database called 'cdbi_test'. It creates the
tables and sequences that it needs and then clears them out at the
end. As SQLite does not have sequences I did not know how to go about
getting this working with that.

Tested against CDBI version 'v3.0.12'.

Attached - the test script and the output that I get.

Cheers,
  Edmund.

--
In reality I'm evdb@xxxxxxxxxx.xx.xx - http://ecclestoad.co.uk

------=_Part_14313_26537094.1131556017057
Content-Type: text/plain; name="output.txt"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="output.txt"

IyAkQ2xhc3M6OkRCSTo6VkVSU0lPTjogJ3YzLjAuMTInCiMgQ3JlYXRpbmcgdGFibGVzIGFuZCBz
ZXF1ZW5jZQpOT1RJQ0U6ICBDUkVBVEUgVEFCTEUgLyBQUklNQVJZIEtFWSB3aWxsIGNyZWF0ZSBp
bXBsaWNpdCBpbmRleCAicGFyZW50c19wa2V5IiBmb3IgdGFibGUgInBhcmVudHMiCk5PVElDRTog
IENSRUFURSBUQUJMRSAvIFBSSU1BUlkgS0VZIHdpbGwgY3JlYXRlIGltcGxpY2l0IGluZGV4ICJj
aGlsZHJlbl9wa2V5IiBmb3IgdGFibGUgImNoaWxkcmVuIgojCiMgdXNpbmcgY2RiaV9pZDogMTAw
MDAwMAojCm9rIDEgLSBjcmVhdGUgdGVzdCBwYXJlbnQKb2sgMiAtIGNyZWF0ZSB0ZXN0IGNoaWxk
Cm9rIDMgLSBuYW1lcyB0aGUgc2FtZQpvayA0IC0gY2hhbmdlIG5hbWUKb2sgNSAtIG5hbWVzIHRo
ZSBzYW1lCm9rIDYgLSB1cGRhdGUKb2sgNyAtIG5hbWVzIHRoZSBzYW1lCm9rIDggLSBkYmlfY29t
bWl0Cm9rIDkgLSBuYW1lcyB0aGUgc2FtZQojCiMgdXNpbmcgY2RiaV9pZDogdW5kZWYKIwpvayAx
MCAtIGNyZWF0ZSB0ZXN0IHBhcmVudApvayAxMSAtIGNyZWF0ZSB0ZXN0IGNoaWxkCm9rIDEyIC0g
bmFtZXMgdGhlIHNhbWUKb2sgMTMgLSBjaGFuZ2UgbmFtZQpub3Qgb2sgMTQgLSBuYW1lcyB0aGUg
c2FtZQojICAgICBGYWlsZWQgdGVzdCAoY2xhc3MtZGJpLXN0cmFuZ2VuZXNzLnQgYXQgbGluZSA4
OSkKIyAgICAgICAgICBnb3Q6ICduZXcgbmFtZScKIyAgICAgZXhwZWN0ZWQ6ICd0ZXN0IHBhcmVu
dCcKb2sgMTUgLSB1cGRhdGUKbm90IG9rIDE2IC0gbmFtZXMgdGhlIHNhbWUKIyAgICAgRmFpbGVk
IHRlc3QgKGNsYXNzLWRiaS1zdHJhbmdlbmVzcy50IGF0IGxpbmUgOTEpCiMgICAgICAgICAgZ290
OiAnbmV3IG5hbWUnCiMgICAgIGV4cGVjdGVkOiAndGVzdCBwYXJlbnQnCm9rIDE3IC0gZGJpX2Nv
bW1pdApub3Qgb2sgMTggLSBuYW1lcyB0aGUgc2FtZQojICAgICBGYWlsZWQgdGVzdCAoY2xhc3Mt
ZGJpLXN0cmFuZ2VuZXNzLnQgYXQgbGluZSA5NCkKIyAgICAgICAgICBnb3Q6ICduZXcgbmFtZScK
IyAgICAgZXhwZWN0ZWQ6ICd0ZXN0IHBhcmVudCcKIyAkVkFSMSA9IHsKIyAgICAgICAgICAgJyRw
YXJlbnQnID0+IGJsZXNzKCB7CiMgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAnbmFt
ZScgPT4gJ25ldyBuYW1lJywKIyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICdjZGJp
X2lkJyA9PiAnMicKIyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB9LCAnUGFyZW50JyAp
LAojICAgICAgICAgICAnJGNoaWxkLT5wYXJlbnQnID0+IGJsZXNzKCB7CiMgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgJ25hbWUnID0+ICd0ZXN0IHBhcmVudCcsCiMgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgJ2NkYmlfaWQnID0+ICcyJwojICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB9LCAnUGFyZW50JyApCiMgICAgICAg
ICB9OwojIERlc3Ryb3lpbmcgdGFibGVzIGFuZCBzZXF1ZW5jZQoxLi4xOAojIExvb2tzIGxpa2Ug
eW91IGZhaWxlZCAzIHRlc3RzIG9mIDE4LgoK
------=_Part_14313_26537094.1131556017057
Content-Type: application/x-troff; name="class-dbi-strangeness.t"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="class-dbi-strangeness.t"

IyBUaGlzIGlzIGEgdGVzdCB0byBzaG93IHVuZXhwZWN0ZWQgYmVoYXZpb3VyIHdpdGggcmVsYXRp
b24gdG8gJ29ubHkKIyBvbmUgb2JqZWN0IGluIG1lbW9yeScuIElmIGEgcm93IGlzIGFkZGVkIHRv
IHRoZSBkYXRhYmFzZSBhbmQgdGhlCiMgdmFsdWUgb2YgaXQncyBwcmltYXJ5IGtleSBjb21lcyBm
cm9tIGEgc2VxdWVuY2UgdGhlbiBpdCBpcyBub3QKIyBmZXRjaGVkIHByb3Blcmx5IGZyb20gdGhl
IG9iamVjdCBjYWNoZS4gVGhlIHNhbWUgYmVoYXZpb3VyIGlzIG5vdAojIHNob3duIGlmIGEgdmFs
dWUgaXMgZXhwbGljaXRseSBnaXZlbiBmb3IgdGhlIHByaW1hcnkga2V5LiBJIHRoaW5rCiMgdGhp
cyBpcyB0aGUgcHJvYmxlbSBhbnl3YXkuLi4KCiMgVGhlIHRlc3RzIGJlbG93IGFzc3VtZSB0aGF0
IHRoZXJlIGlzIGEgcG9zdGdyZXMgZGF0YWJhc2UgJ2NkYmlfdGVzdCcKIyAtIFNRTGl0ZSBkb2Vz
IG5vdCBoYXZlIHNlcXVlbmNlcyBhbmQgc28gSSBkb24ndCB0aGluayB0aGF0IHRoZXNlCiMgdGVz
dHMgY2FuIGJlIHJ1biBhZ2FpbnN0IGl0LgoKIyBQbGVhc2UgbGV0IG1lIGtub3cgaWYgdGhlcmUg
aXMgYW55dGhpbmcgZWxzZSB0aGF0IEkgY2FuIGRvIHRvIGhlbHAKIyB5b3Ugd2l0aHRoaXMgYnVn
ICggYXQgbGVhc3QgSSB0aGluayBpdCBpcyBhIGJ1ZyApLgoKIyBFZG11bmQgdm9uIGRlciBCdXJn
CiMgZXZkYkBlY2NsZXN0b2FkLmNvLnVrCiMgaHR0cDovL2VjY2xlc3RvYWQuY28udWsKCnVzZSBz
dHJpY3Q7CnVzZSB3YXJuaW5nczsKdXNlIERhdGE6OkR1bXBlcjsKdXNlIFRlc3Q6Ok1vcmUgJ25v
X3BsYW4nOwoKIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIwoKcGFja2FnZSBDREJJOwoKdXNlIGJhc2UgJ0Ns
YXNzOjpEQkknOwpDREJJLT5jb25uZWN0aW9uKCJkYmk6UGc6ZGJuYW1lPWNkYmlfdGVzdCIpOwpD
REJJLT5zZXF1ZW5jZSgnY2RiaV9pZF9zZXEnKTsKCiMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMKCnBhY2th
Z2UgUGFyZW50Owp1c2UgYmFzZSAnQ0RCSSc7Cgp1c2UgRGF0YTo6RHVtcGVyOwoKUGFyZW50LT50
YWJsZSgncGFyZW50cycpOwoKUGFyZW50LT5jb2x1bW5zKCBQcmltYXJ5ID0+IHF3KGNkYmlfaWQp
ICk7ClBhcmVudC0+Y29sdW1ucyggT3RoZXJzICA9PiBxdyhuYW1lKSApOwoKUGFyZW50LT5oYXNf
bWFueSggY2hpbGRyZW4gPT4gJ0NoaWxkJyApOwoKc3ViIGNyZWF0ZV9zcWwgeyAnJyB9CgojIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjCgpwYWNrYWdlIENoaWxkOwp1c2UgYmFzZSAnQ0RCSSc7CgpDaGlsZC0+
dGFibGUoJ2NoaWxkcmVuJyk7CgpDaGlsZC0+Y29sdW1ucyggUHJpbWFyeSA9PiBxdy9jZGJpX2lk
LyApOwpDaGlsZC0+Y29sdW1ucyggT3RoZXJzICA9PiBxdy9wYXJlbnQvICk7CgpDaGlsZC0+aGFz
X2EoIHBhcmVudCA9PiAnUGFyZW50JyApOwoKc3ViIGNyZWF0ZV9zcWwgeyAnJyB9CgojIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjCgpwYWNrYWdlIG1haW47CgpkaWFnICJcJENsYXNzOjpEQkk6OlZFUlNJT046
ICciIC4gJENsYXNzOjpEQkk6OlZFUlNJT04gLiAiJyI7CgpjcmVhdGVfdGFibGVzKCk7Cgpmb3Ig
bXkgJGNkYmlfaWQgKCAxXzAwMF8wMDAsIHVuZGVmICkgewoKICAgIGRpYWcgIiI7CiAgICBkaWFn
ICJ1c2luZyBjZGJpX2lkOiAiLCBkZWZpbmVkICRjZGJpX2lkID8gJGNkYmlfaWQgOiAndW5kZWYn
OwogICAgZGlhZyAiIjsKCiAgICAjIGNyZWF0ZSBhIHRlc3QgcGFyZW50LgogICAgbXkgJHBhcmVu
dCA9CiAgICAgIFBhcmVudC0+Y3JlYXRlKCB7IGNkYmlfaWQgPT4gJGNkYmlfaWQsIG5hbWUgPT4g
J3Rlc3QgcGFyZW50JyB9ICk7CiAgICBvayAkcGFyZW50LCAnY3JlYXRlIHRlc3QgcGFyZW50JzsK
CiAgICAjIGNyZWF0ZSBhIHRlc3QgY2hpbGQuCiAgICBteSAkY2hpbGQgPSBDaGlsZC0+Y3JlYXRl
KCB7IHBhcmVudCA9PiAkcGFyZW50LCB9ICk7CiAgICBvayAkY2hpbGQsICdjcmVhdGUgdGVzdCBj
aGlsZCc7CgogICAgIyBkbyBhIHRlc3QgdG8gc2VlIGlmIGFuIHVwZGF0ZSB0byB0aGUgcGFyZW50
IGlzIHJlZmxlY3RlZCBpbiB0aGUKICAgICMgY2hpbGQncyBwYXJlbnQuCiAgICBpcyAkcGFyZW50
LT5uYW1lLCAkY2hpbGQtPnBhcmVudC0+bmFtZSwgIm5hbWVzIHRoZSBzYW1lIjsKICAgIG9rICRw
YXJlbnQtPm5hbWUoJ25ldyBuYW1lJyksICJjaGFuZ2UgbmFtZSI7CiAgICBpcyAkcGFyZW50LT5u
YW1lLCAkY2hpbGQtPnBhcmVudC0+bmFtZSwgIm5hbWVzIHRoZSBzYW1lIjsKICAgIG9rICRwYXJl
bnQtPnVwZGF0ZSwgICAgICJ1cGRhdGUiOwogICAgaXMgJHBhcmVudC0+bmFtZSwgICAgICAgJGNo
aWxkLT5wYXJlbnQtPm5hbWUsICJuYW1lcyB0aGUgc2FtZSI7CiAgICBvayAkcGFyZW50LT5kYmlf
Y29tbWl0LCAiZGJpX2NvbW1pdCI7CgogICAgaXMoICRwYXJlbnQtPm5hbWUsICRjaGlsZC0+cGFy
ZW50LT5uYW1lLCAibmFtZXMgdGhlIHNhbWUiICkKICAgICAgfHwgZGlhZyBEdW1wZXIgewogICAg
ICAgICckcGFyZW50JyAgICAgICAgPT4gJHBhcmVudCwKICAgICAgICAnJGNoaWxkLT5wYXJlbnQn
ID0+ICRjaGlsZC0+cGFyZW50CiAgICAgIH07CgogICAgIyBDbGVhbnVwLgogICAgJHBhcmVudC0+
ZGVsZXRlOwogICAgUGFyZW50LT5kYmlfY29tbWl0Owp9CgpkZWxldGVfdGFibGVzKCk7CkNEQkkt
PmRiaV9jb21taXQ7CgojIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjCgpzdWIgY3JlYXRlX3RhYmxlcyB7CiAg
ICBteSAkZGJoID0gQ0RCSS0+ZGJfTWFpbjsKCiAgICBkaWFnICJDcmVhdGluZyB0YWJsZXMgYW5k
IHNlcXVlbmNlIjsKCiAgICAkZGJoLT5kbyggPDwiIiApOwpjcmVhdGUgc2VxdWVuY2UgY2RiaV9p
ZF9zZXEKCiAgICAkZGJoLT5kbyggPDwiIiApOwpjcmVhdGUgdGFibGUgcGFyZW50cyAoCiAgY2Ri
aV9pZCAgIGludDggcHJpbWFyeSBrZXksCiAgbmFtZSAgICAgIHRleHQgbm90IG51bGwKKQoKICAg
ICRkYmgtPmRvKCA8PCIiICk7CmNyZWF0ZSB0YWJsZSBjaGlsZHJlbiAoCiAgY2RiaV9pZCAgIGlu
dDggcHJpbWFyeSBrZXksCiAgcGFyZW50ICAgIGludDggbm90IG51bGwgcmVmZXJlbmNlcyBwYXJl
bnRzCikKCn0KCnN1YiBkZWxldGVfdGFibGVzIHsKICAgIG15ICRkYmggPSBDREJJLT5kYl9NYWlu
OwoKICAgIGRpYWcgIkRlc3Ryb3lpbmcgdGFibGVzIGFuZCBzZXF1ZW5jZSI7CiAgICAkZGJoLT5k
bygiZHJvcCB0YWJsZSAkXyIpIGZvciBxdyggY2hpbGRyZW4gcGFyZW50cyApOwogICAgJGRiaC0+
ZG8oImRyb3Agc2VxdWVuY2UgY2RiaV9pZF9zZXEiKTsKCn0K
------=_Part_14313_26537094.1131556017057
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

------=_Part_14313_26537094.1131556017057--