1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
isXblob - gif
:memory: #use in-memory database
SELECT Hex(blob), IsPngBlob(blob), IsGifBlob(blob), IsGeometryBlob(blob), IsZipBlob(blob), IsPdfBlob(blob), IsTiffBlob(blob), IsJpegBlob(blob), IsExifBlob(blob), IsExifGpsBlob(blob), IsWebpBlob(blob) FROM (SELECT BlobFromFile('sql_stmt_tests/ktorrent_sidebar.gif') as blob) dummy
1 # rows (not including the header row)
11 # columns
Hex(blob)
IsPngBlob(blob)
IsGifBlob(blob)
IsGeometryBlob(blob)
IsZipBlob(blob)
IsPdfBlob(blob)
IsTiffBlob(blob)
IsJpegBlob(blob)
IsExifBlob(blob)
IsExifGpsBlob(blob)
IsWebpBlob(blob)
4749463839610D00B80BA52E00BDBDBDCBCBCBCCCCCCCFCFCFD0D0D0D1D1D1D3D3D3D4D4D4D5D5D5D7D7D7D8D8D8D9D9D9DBDBDBDCDCDCDEDEDEDFDFDFE2E2E2E3E3E3E4E4E4E5E5E5E6E6E6E7E7E7E8E8E8E9E9E9EAEAEAEBEBEBECECECEDEDEDEEEEEEEFEFEFF0F0F0F1F1F1F2F2F2F3F3F3F4F4F4F5F5F5F6F6F6F7F7F7F8F8F8F9F9F9FAFAFAFBFBFBFCFCFCFDFDFDFEFEFEFFFFFFBDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC1BDBCC121F904010A003F002C000000000D00B80B0006FEC0952A853291449E4DA63201088946A492E91C168FC965F379956AAB50EC746B8D66A95CF318DC3D93C35E7459FC4DD3E570375B5D9FC7DF6D6B767F7B77807C78817D79827E7A838F8E8D8C8B8A898887868584909396999C9295989B9194979A9DA3A9A2A8A1A7A0A69FA59EA4AAAEB2B6ADB1B5ACB0B4ABAFB3B7BCC1B9BEC3BBC0B8BDC2BABFC4CBC5CCC6CDC7CEC8CFC9D0CAD1DEDDE0DCE2DBE4DAE6D9E8D8EAD7ECD6EED5F0D4F2D3F4D2F6DFE3E7EBEFF3F7E1E5E9DAC5AB870FE0BE81FEF205E447F09F3E81FD0A3E6498D020C4860A0F4674B810A1C48E1B335EAC38D123478D182D52FC889224C8942543AA342972E5C9912C71DEB45993E6FE4C993161BE74D93227CF9F428BEEF41994A8CE9E40871A652A756954A550933E45EAF468D3A957B77EB5AAD56BD5AC5DA962E50AB6AC5AB167D9924D1BD6ECDAB168DBD2755BF7AD5DB877E3E2959B77AEDEC38613175E4CB8F1E0C78223079E0CB8F2DFCB7E33F7DDCCB7F3DECF881943A68C993368C58E255BD6EC39746AD2AC4F8B565DBA35EAD1AB4DBBC65D5BF6EBDCB667C3D67D9B76ECDDC6890B07EE9BF7F1E2C383FFEE8D3C7AF3E4D29D2B9FFE7C3975E8CCAB8707FFDD7B77EEDBB567C77EDDBAF8F2E8D7BB277F5E7DFBF1E6D3B37F5F7F3F7DFDF3E5271F7EF1DD079F7DFC01482082FF0D78A07F021AD85F800526E8E0840B4258618312FE2AF820850C46686187177A88E1871982A861881B8AC8E18830BE28A38B34B668238B38AEA8A38A3CA6E8238A409E28A489449668248948C658638E3D0659649233DEB8E38F431EA9A4944D5609E592533A6965944C52F9E495617AB92596627EC965966382D9A59664BED9E69A699E59269C6EB2A9269A66C6A9A79D72EE79E79C7CE249679F79D6E9A7A289227AA8A185123AA8A08102FAE7A28E464AE9A58D423AA9A58C3E2A69A5987A4A6AA7A3722AEAA6A16A0A6AA69F969A6AABB1A2CA2AACA7AEFAAAA9AABA2AEBADBCD29AABAFB6EE3A2BAEBDD6AAEBAFC6027B6CB0C80A9BECB0CA12BB6CB1CC668BEDB6D7766BEDB7D5864BEDB8D3962BEDB9FED1A60BEDBACFB6EBECBBCDC6ABADB7E29AABAEBBF2720B2EB9E8B20BEFBCFBDAEB6FBEF4F27BEFBFFAD6DB2FBE002B7C30C1012F8C70C102339CB0C103378CB1C5144B0CB1C3195F5CF1C4113FACF1C81F6F4C32C81C971C72C7268BECF1C933CB1C33CC2FBBDC32CB2BAB9C32CA34DFAC73CF40DB9C33CF3FD78CF3CE3E077D74D346335DF4D2442B3D74D24223EDB4D4566B1D75D559434D35D64F4F7DF5D66097DDB5D8677F4D36D7619BEDF5D868BF9D36DC6AC7BDB6DC6CCFDD36DD6ED72D78E084036EF8DF88FBAD78DF8CF3EDF8DE90EB2D79DE94E36DF9DD98DBADF9E0872FFEF8E4976F5E78E28D475E79E69C93FEF9E9A2775E3AE8A88FEEB9FEE9A1A73E3BECADAB4E7BECAEAF5EBBECAFB36E7BF0BFF7BE7BEEB70B0FBCEFBCEB8EFBF0CC234F7CF3C917EFBCF2C63FBFFCF1D073BFBDF6D9637FBDF5D5533FBDF4D1770FFEF8E6A7FFBDF8E5A3EF7DF8E49FAF3EFCF6BF5FBFFBF4B73F3FFBF25B5FFCEEB7BFFF0D507FFE1360FEFA1740FCF10F80044CA0030DB8400822104A2A48C6106CF1040E0EE1049A60C10A8450841120810319C840004448421398D0032854210B33E8C213A6708523A4E10B39A0810C0860866DE0A10F8108C213F6F087394401084700C3231291044CEC8006348044122EF1031D50C2009E38022C6A918B5844E11693B8441074808704E022089A98463242718D3C2C8008FE5590C1327A208B7274E308D6884722BA30041FD8C0060C30C3149CE08F1FE0C0060E30C70F2292031C60A4101C390240425292563864251319C93912419396E400023CA9C4478AB291A5DC24073A304A32D6D08B09F0A30961294B11C0510185D4E41E6188CB1C1AD285BBE4C00266A88243BE118BC3F4A53137D98164E67099806C2631515082128820046B64000B4958CD4A66739B19EC26363DA0CD1176B004DE242738536002748EB39CBE6C673AE179CE7436009C2A90A72D3D70CF6D12019DD704810358E0CF1300149B030527358F10821024D49CE16468081E405088A6A00412A5A8428D50C9895634891C6DA846734843288AB405D3C4A8086CFE09019492949AD664A94B27598483B6749AF2AC6404664AC79A8E40A73CDD203043B0D3692E53044525E92FA12802091094881835E1049E4AC6A88A800254B522468F80D58FD6B19A5CCD6A1DDB09C50A88B594DD34AB57D18A4EB5FAB19B16F8E8130E6904125C40AE8EACEB5DD7790263DA55AC863C6435310058B612D6AB9F34A8093080D2422A91AE1968AC2F1F6B02136440AE56346607B26A452596C0039CB582673F20D9C99692B47825C2691B5BC8C48280B54A45816C43D082D2AA800B2810416D9FCAC214586104BBCDAA6F89005CD6F6D60A2408AE57877051E58AB091C574EE0A66B802144897BAD635EE74E758DDDAB2B605D3F5A5779F0A415E8B8E97A0E535670ACECB02F0FA93BDEE15AF724BBB82F5CE57AEF6FD6E7BD5EB5DF6EE5705FD752E78011C60DE0E38C0286DAC4B11DC5EF48A10C1C175691000003B
0
1
0
0
0
0
0
0
0
0
|
