Alan M. Feldstein wrote: > > I should be able to use ij to execute SQL statements > interactively ... in order to add a couple of rows to the > database. > > I want to put a couple of rows into the database on a clean machine > using a minimalist approach, as proof of concept for the > database specification I'm writing here > (http://www.alanfeldstein.com/products/software/fss/download/test_cases_database.html). > I'll be just about done writing that Web page once I can explain the > requirements for populating the executableFile column. >
For a minimalist approach, I tried the following two SQL statements at the ij prompt. Both failed. ij> INSERT INTO "ADDTestCases" ( "pairID", "expectedSum", "executableFile" ) VALUES( 1, 0, X'7f' '45' '4c' '46' '02' '02' '01' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '02' '00' '2b' '00' '00' '00' '01' '00' '00' '00' '01' '00' '00' '00' 'b0' '00' '00' '00' '00' '00' '00' '00' '40' '00' '00' '00' '00' '00' '00' '03' '78' '00' '00' '00' '00' '00' '40' '00' '38' '00' '02' '00' '40' '00' '07' '00' '06' '00' '00' '00' '01' '00' '00' '00' '05' '00' '00' '00' '00' '00' '00' '00' 'b0' '00' '00' '00' '01' '00' '00' '00' 'b0' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '58' '00' '00' '00' '00' '00' '00' '00' '58' '00' '00' '00' '00' '00' '10' '00' '00' '00' '00' '00' '01' '00' '00' '00' '07' '00' '00' '00' '00' '00' '00' '01' '08' '00' '00' '00' '01' '00' '10' '01' '08' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '18' '00' '00' '00' '00' '00' '00' '00' '18' '00' '00' '00' '00' '00' '10' '00' '00' '0b' '00' '00' '00' '8a' '11' '60' '01' '8b' '29' '70' '20' '09' '00' '04' '00' '88' '11' '21' '08' '88' '11' '00' '05' 'c2' '59' '00' '00' '0b' '00' '00' '00' '8a' '11' '60' '01' '8b' '29' '70' '20' '09' '00' '04' '00' '88' '11' '21' '10' '88' '11' '00' '05' 'c4' '59' '00' '00' '86' '00' '40' '02' '0b' '00' '00' '00' '8a' '11' '60' '01' '8b' '29' '70' '20' '09' '00' '04' '00' '88' '11' '21' '18' '88' '11' '00' '05' 'c6' '71' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '01' '04' '00' 'ff' 'f1' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '01' '00' '00' '00' '01' '00' '00' '00' 'b0' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '02' '00' '00' '00' '01' '00' '10' '01' '08' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '03' '00' '00' '00' '01' '00' '10' '01' '20' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '04' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '05' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '06' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '25' '01' '00' '00' '03' '00' '00' '00' '01' '00' '10' '01' '20' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '2b' '01' '00' '00' '01' '00' '00' '00' '01' '00' '00' '00' 'b0' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '07' '01' '00' '00' '02' '00' '00' '00' '01' '00' '10' '01' '18' '00' '00' '00' '00' '00' '00' '00' '08' '00' '00' '00' '0b' '01' '00' '00' '02' '00' '00' '00' '01' '00' '10' '01' '08' '00' '00' '00' '00' '00' '00' '00' '08' '00' '00' '00' '13' '01' '00' '00' '02' '00' '00' '00' '01' '00' '10' '01' '10' '00' '00' '00' '00' '00' '00' '00' '08' '00' '00' '00' '1b' '11' '00' '00' '03' '00' '00' '00' '01' '00' '10' '01' '20' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '20' '12' '00' '00' '01' '00' '00' '00' '01' '00' '00' '00' 'b0' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '1d' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '02' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '1d' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '33' '11' '00' '00' '02' '00' '00' '00' '01' '00' '10' '01' '20' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '3a' '11' '00' '00' '01' '00' '00' '00' '01' '00' '00' '01' '08' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '41' '11' '00' 'ff' 'f1' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '61' '2e' '6f' '75' '74' '00' '73' '75' '6d' '00' '61' '64' '64' '65' '6e' '64' '31' '00' '61' '64' '64' '65' '6e' '64' '32' '00' '5f' '65' '6e' '64' '00' '6d' '61' '69' '6e' '00' '5f' '45' '4e' '44' '5f' '00' '5f' '53' '54' '41' '52' '54' '5f' '00' '5f' '65' '64' '61' '74' '61' '00' '5f' '65' '74' '65' '78' '74' '00' '5f' '44' '59' '4e' '41' '4d' '49' '43' '00' '00' '2e' '74' '65' '78' '74' '00' '2e' '64' '61' '74' '61' '00' '2e' '62' '73' '73' '00' '2e' '73' '79' '6d' '74' '61' '62' '00' '2e' '73' '74' '72' '74' '61' '62' '00' '2e' '73' '68' '73' '74' '72' '74' '61' '62' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '01' '00' '00' '00' '01' '00' '00' '00' '00' '00' '00' '00' '06' '00' '00' '00' '01' '00' '00' '00' 'b0' '00' '00' '00' '00' '00' '00' '00' 'b0' '00' '00' '00' '00' '00' '00' '00' '58' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '04' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '07' '00' '00' '00' '01' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '00' '01' '00' '10' '01' '08' '00' '00' '00' '00' '00' '00' '01' '08' '00' '00' '00' '00' '00' '00' '00' '18' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '08' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '0d' '00' '00' '00' '08' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '00' '01' '00' '10' '01' '20' '00' '00' '00' '00' '00' '00' '01' '20' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '01' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '12' '00' '00' '00' '02' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '01' '20' '00' '00' '00' '00' '00' '00' '01' 'e0' '00' '00' '00' '05' '00' '00' '00' '0d' '00' '00' '00' '00' '00' '00' '00' '08' '00' '00' '00' '00' '00' '00' '00' '18' '00' '00' '00' '1a' '00' '00' '00' '03' '00' '00' '00' '00' '00' '00' '00' '20' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '00' '00' '00' '00' '00' '00' '00' '00' '4a' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '01' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '22' '00' '00' '00' '03' '00' '00' '00' '00' '00' '00' '00' '20' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '03' '4a' '00' '00' '00' '00' '00' '00' '00' '2c' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '00' '01' '00' '00' '00' '00' '00' '00' '00' '00' ); ERROR 42X01: Syntax error: Encountered "\'45\'" at line 2, column 7. ij> INSERT INTO "ADDTestCases" ( "pairID", "expectedSum", "executableFile" ) VALUES( 1, 0, X'7f454c460202010000000000000000000002002b0000000100000001000000b00000000000000040000000000000037800000000004000380002004000070006000000010000000500000000000000b000000001000000b0000000000000000000000000000000580000000000000058000000000010000000000001000000070000000000000108000000010010010800000000000000000000000000000018000000000000001800000000001000000b0000008a1160018b297020090004008811210888110005c25900000b0000008a1160018b297020090004008811211088110005c4590000860040020b0000008a1160018b297020090004008811211888110005c6710000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010400fff100000000000000000000000000000000000000000300000100000001000000b000000000000000000000000003000002000000010010010800000000000000000000000003000003000000010010012000000000000000000000000003000004000000000000000000000000000000000000000003000005000000000000000000000000000000000000000003000006000000000000000000000000000000000000002501000003000000010010012000000000000000000000002b0100000100000001000000b000000000000000000000000701000002000000010010011800000000000000080000000b01000002000000010010010800000000000000080000001301000002000000010010011000000000000000080000001b1100000300000001001001200000000000000000000000201200000100000001000000b00000000000000000000000001d00000000000000000000020000000000000000000000001d000000000000000000000300000000000000000000003311000002000000010010012000000000000000000000003a1100000100000001000001080000000000000000000000411100fff10000000000000000000000000000000000612e6f75740073756d00616464656e643100616464656e6432005f656e64006d61696e005f454e445f005f53544152545f005f6564617461005f6574657874005f44594e414d494300002e74657874002e64617461002e627373002e73796d746162002e737472746162002e7368737472746162000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000001000000000000000600000001000000b000000000000000b00000000000000058000000000000000000000000000000040000000000000000000000070000000100000000000000030000000100100108000000000000010800000000000000180000000000000000000000000000000800000000000000000000000d000000080000000000000003000000010010012000000000000001200000000000000000000000000000000000000000000000010000000000000000000000120000000200000000000000000000000000000000000000000000012000000000000001e0000000050000000d000000000000000800000000000000180000001a00000003000000000000002000000000000000000000000000000300000000000000004a000000000000000000000000000000010000000000000000000000220000000300000000000000200000000000000000000000000000034a000000000000002c000000000000000000000000000000010000000000000000' ); ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. ij> -- View this message in context: http://www.nabble.com/VALUES-expression%2C-BLOB%2C-and-using-ij-tf3808458.html#a10821160 Sent from the Apache Derby Users mailing list archive at Nabble.com.
